Re:DuckDB: SQLite for Analytics
by georgewfraser on Saturday May 23, 2020 @08:21PM
(#23287920)
It’s much faster for analytical queries, because it’s a column store rather than a row store.
[ Parent
| on HN ]
Some more info about columnar DBs here https://en.wikipedia.org/wiki/Column-oriented_DBMS for anyone not familiar with the idea.