[civilized]

You need a columnar database for good performance. Try DuckDB to ease them into it, it's a columnar SQLite.

[orhmeh09]

Thanks, I’m checking it out, it seems pretty interesting to keep an eye on. Lots of properties that would be useful in our shared computing environment like not requiring root or Docker.

[hated]

Might also be worth running a local instance of Postgres 13. Super easy to do on Windows without administrator rights.