[timenova]

Does anyone know how well does DuckDB's persistent mode compare to SQLite for example?

Does it write synchronously on COMMIT and never lose data? Is it reliable enough to use instead of SQLite?

[r1cka]

DuckDB targets analytical workloads. Your question sounds like your workload is transactional to me, so I'd recommend sticking with SQLite.

[cipherzero]

Agree, in fact this wonderful book calls this out, stating:

  As DuckDB is an analytics database, it has only minimal support for transactions and parallel write access. You therefore couldn’t use it in applications and APIs that process and store input data arriving arbitrarily. Similarly when multiple concurrent processes read from a writeable database.