News for hackers. Stuff that matters.

A comment on DuckDB 1.5.2 – SQL database that runs on laptop, server, in the browser. Parent comment

Re:DuckDB 1.5.2 – SQL database that runs on laptop, server, ... by andrewstuart on Wednesday April 22, 2026 @02:39PM (#47867532)
No, I tried Clickhouse instead, which worked without crashing or manual memory tuning.

Search the issues of the duckdb GitHub there’s at least 110 open and closed oom (out of memory) and maybe 400 to 500 that reference “memory”.

[ Parent | on HN ]
Re:DuckDB 1.5.2 – SQL database that runs on laptop, server, ... by goerch on Wednesday April 22, 2026 @02:50PM (#47867667)
> Search the issues of the duckdb GitHub there’s at least 110 open and closed oom (out of memory) and maybe 400 to 500 that reference “memory”.

Ah, missed this the first time around. Will check this out. And yes, I noticed that DuckDB rather aggressively tries to use the resources of your computer.

[ Parent | on HN ]
Re:DuckDB 1.5.2 – SQL database that runs on laptop, server, ... by goerch on Wednesday April 22, 2026 @02:43PM (#47867589)
Understood: SQLite is to Postgres as DuckDB is to ClickHouse.
[ Parent | on HN ]
Re:DuckDB 1.5.2 – SQL database that runs on laptop, server, ... by andrewstuart on Wednesday April 22, 2026 @02:45PM (#47867614)
I don’t see the analogy, if you’re using it to excuse crashing on small data sets and indexes.

SQLite isn’t small and crashy, it’s small and reliable.

There’s something fundamentally wrong with the codebase/architecture if there’s so many memory problems.

And the absolute baseline requirement for a production database is no crashes.

[ Parent | on HN ]
Re:DuckDB 1.5.2 – SQL database that runs on laptop, server, ... by ciupicri on Wednesday April 22, 2026 @03:17PM (#47868002)
I think the authors disagree with me, but I see it like a online analytical processing (OLAP) database, not like a OLTP (online transaction processing) database, so crashes are more tolerable.
[ Parent | on HN ]
Re:DuckDB 1.5.2 – SQL database that runs on laptop, server, ... by goerch on Wednesday April 22, 2026 @03:07PM (#47867881)
Agree with your assessment of small and reliable for SQLite. Disagree with your baseline requirement. ACID is more important for me and does not contain `No crashes`.
[ Parent | on HN ]