News for hackers. Stuff that matters.

A comment on SQLite the only database you will ever need in most cases.

Re:SQLite the only database you will ever need in most cases by hesk on Thursday April 15, 2021 @08:45AM (#26819754)
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/

[ Parent | on HN ]
Re:SQLite the only database you will ever need in most cases by legg0myegg0 on Thursday April 15, 2021 @03:29PM (#26825096)
I completely agree!! We see 20-100x performance from DuckDB over SQLite for OLAP style queries.
[ Parent | on HN ]