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?
Does it write synchronously on COMMIT and never lose data? Is it reliable enough to use instead of SQLite?
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.