News for hackers. Stuff that matters.
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.
Re:DuckDB: SQLite for Analytics by ivan_ah on Saturday May 23, 2020 @09:45PM (#23288373)
Some more info about columnar DBs here https://en.wikipedia.org/wiki/Column-oriented_DBMS for anyone not familiar with the idea.