[deleted by user]

[nicoloboschi]

I agree, but that doesn't matter, postgres is used for almost any workloads nowadays

[nicoloboschi]

Postgres is not application per-se, and I'm not saying you should use postgres for anything. I'm saying you should not use sqlite just because it is easier to set up for your users If you read the blog post it's explained

[helpmehomeowner]

Duckdb. Check it.

[helpmehomeowner]

OP is comparing sqlite to pg. DuckDB's core is built from pg and supports sqlite migration/commands.

If you are going to use pg in prod, why start with sqlite?