6 ms·
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 reliabl
by timenova 3y ago
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 3y agoDuckDB targets analytical workloads. Your question sounds like your workload is transactional to me, so I'd recommend sticking with SQLite.
- cipherzero 3y agoAgree, 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.