On: SQLite on Rails: The how and why of optimal performance

[notpushkin]

This. If you’re looking for something portable, DuckDB is hard to beat. It’s pretty much the SQLite for analytics.

I’ve had good experience with ClickHouse, too, but it feels a bit more like Postgres rather than SQLite in terms of portability.

[tosh → notpushkin]

Take a look at chDB and clickhouse-local. Clickhouse can do a lot even without running it as a server.

https://clickhouse.com/docs/en/chdb

https://clickhouse.com/docs/en/operations/utilities/clickhou...