Re:SQLite 3.32
by erichocean on Saturday May 23, 2020 @05:08PM
(#23286467)
Wow, why isn't DuckDB not more widely known!?!?! Looks incredible!!!
I 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
SQLite is started by some Aussie devs right ?
SQLite was started by Dwayne Richard Hipp from North Carolina. 20 years ago.
Re:SQLite 3.32
by justinclift on Sunday May 24, 2020 @03:57AM
(#23289951)
> Aussie devs
Not SQLite itself. One of the DB Browser for SQLite dev's is an Aussie though. :)
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.