4 ms·
I think the OP wants duckdb. The first two points are deliberate SQLite design decisions so they're unlikely to change.
by red_admiral 3mo ago
I think the OP wants duckdb.
The first two points are deliberate SQLite design decisions so they're unlikely to change.
- deskamess 3mo agoWhat are the defaults for duckdb? Is it the pragma 2026 equivalent?
- red_admiral 3mo agoI can't speak for speed, but foreign keys and data type checking are on by default.
- mort96 3mo agoNo, I actually like SQLite with the settings tweaked a tiny bit. Disagreement with the defaults isn't enough to make me switch databases completely
- weberer 3mo agoDuckDB is a OLAP database. Its optimized for batch analytics, not for individual transactions. Its great for data science work, but I wouldn't use it for a production system.