nihilism is exhausting
Fucking nighmare! I wanted to migrate a 30gb sqlite database into postgres. Apart from the Tablespace nonsense (required for storing data on external drive), the pgloader file that eventually worked is: Must be run directly from the server though. pgloader is a BITCH when it comes to ssh connections. Run with external variable (pgloader doesn’t…
Group all the records by the smiles column, count the number of occurrences for each unique SMILES string, and then filter the results to show only those strings that appear more than once… Show how many records in total exist in your table and then subtracts the number of unique SMILES strings. The result is…
"Your revolution is over. The bums lost!"