I will describe our recent progress in the combined experimental and theoretical study of single-photon double-ionization process and the Coulomb explosion dynamics that it triggers in small molecules. In particular, I will describe the roaming H₂ dynamics and formation of the H₃⁺ cation and demonstrate how molecular dynamics measurements help identify the spin-correlation of the electron-pair, ejected in single-photon double-ionization of methanol.