[red_admiral]

I think the OP wants duckdb.

The first two points are deliberate SQLite design decisions so they're unlikely to change.

[mort96]

No, 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]

DuckDB 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.

[deskamess]

What are the defaults for duckdb? Is it the pragma 2026 equivalent?

[red_admiral]

I can't speak for speed, but foreign keys and data type checking are on by default.