4 ms·
SQLite is great! But if you have mainly analytical queries over your data, you might want to give DuckDB [1] a go. It's an embedded database that uses a columna
by hesk 5y ago
SQLite is great! But if you have mainly analytical queries over your data, you might want to give DuckDB [1] a go. It's an embedded database that uses a columnar representation similar to MonetDB (it's from the same group).
[1] https://duckdb.org/ https://duckdb.org/
- legg0myegg0 5y agoI completely agree!! We see 20-100x performance from DuckDB over SQLite for OLAP style queries.