4 ms·
If you like SQLite for data analysis, you might want to check out DuckDB https://github.com/cwida/duckdb https://github.com/cwida/duckdb which is billed as "SQL
by kyllo 6y ago
If you like SQLite for data analysis, you might want to check out DuckDB https://github.com/cwida/duckdb https://github.com/cwida/duckdb which is billed as "SQLite for analytics."
SQLite is a row store, which is best for OLTP (point queries, inserting/updating/deleting one or a few rows at a time), while DuckDB is a column store, which means the data layout has values from the same column stored contiguously, making aggregation queries (GROUP BY) perform much better.
- pachico 6y agoThis is great! Thanks for sharing!
- erichocean 6y agoWow, why isn't DuckDB not more widely known!?!?! Looks incredible!!!
- kyllo 6y agoI was wondering the same--I guess because it's fairly new (2018) and it came out of a database research group at a European university, rather than a SV tech firm. Therefore, limited marketing budget. By the way, here's a YT video of a talk given by one of the DuckDB implementers about why they made it, what it's for, and how it works: https://www.youtube.com/watch?v=PFUZlNQIndo https://www.youtube.com/watch?v=PFUZlNQIndo
- nojvek 6y agoSQLite is started by some Aussie devs right ?
- kyllo 6y agoSQLite was started by Dwayne Richard Hipp from North Carolina. 20 years ago.
- justinclift 6y ago> Aussie devs Not SQLite itself. One of the DB Browser for SQLite dev's is an Aussie though. :)