I've been dealing with lots of data and SQLite and my outtakes are: - language has very little to do since the bottleneck will most likely be the way you inser

I've been dealing with lots of data and SQLite and my outtakes are: - language has very little to do since the bottleneck will most likely be the way you insert data - indeed prepared statements are useful but the performance didn't change much when I did long transactions and commit every certain amount of thousand of rows - having lots of rows in your table is good but certain queries, like aggregation over many rows, are not what SQLite is great about. - ClickHouse can easily ingest that and more in a laptop without even any scripting language.