3 ms·
DuckDB only supports either one read+write client or arbitrary read clients with no writer. This is the biggest blocker for adopting it in a real-world hosted a
by ilumanty 2y ago
DuckDB only supports either one read+write client or arbitrary read clients with no writer. This is the biggest blocker for adopting it in a real-world hosted app.
Rel: https://duckdb.org/docs/connect/concurrency.html#handling-concurrency https://duckdb.org/docs/connect/concurrency.html#handling-co...
- sdenton4 2y agoThat's the same limitation as sqlite, actually.
- ilumanty 2y agoNo. Once a writer connects to a DuckDB database file, it does not allow any other. SQLite always lets you connect additional reader (and writer) processes. You do not run into any locks until you execute write transactions concurrently.