hey if you're wondering where the public data dump for April is, I need help figuring out the implications of my decisions with the Snapchain setup -- would love any ideas.

Short of it: Snapchain prefers a 24/7 running instance, can't afford to run a heavy box 24/7, stuck on filtering 90GB of data on 8GB of RAM

here's the old code for doing this on a beefy server capable of loading everything in RAM:

here's the old code for doing this on a beefy server capable of loading everything in RAM: https://github.com/jc4p/fast-hub-client/blob/9db0f923b6ad0f1fb943e45e3caaa1e1e7746d9d/HubClient/scripts/export_non_removed_reactions.sql