News for hackers. Stuff that matters.
Re:SQLite's File Format by da_chicken on Sunday September 07, 2025 @12:26PM (#45159613)
I think it's one of the reasons DuckDB has seen the popularity that it has.
Re:SQLite's File Format by benjiro on Sunday September 07, 2025 @03:49PM (#45161539)
DuckDB is a columnar database, and columnar DBs are way better for analytics, statistics... That is its main reason for its popularity, the ability to run specific workloads that row based databases will struggle/be slower at.

Nothing to do with the posters badly formatted complained about Sqlite. By that metric DuckDB has a ton of issues that even out scale Sqlite.

Re:SQLite's File Format by qaq on Sunday September 07, 2025 @03:50PM (#45161546)
thats a strange argument DuckDB is for OLAP and SQLite is for OLTP
Re:SQLite's File Format by da_chicken on Monday September 08, 2025 @01:00AM (#45164764)
Yeah, but most applications are small. So, at the scale of most applications you can drop in DuckDB with zero change in actual performance. It still has indexes to support highly selective queries because it needs to have functional primary keys.