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-co...
Rel: https://duckdb.org/docs/connect/concurrency.html#handling-co...
SQLite always lets you connect additional reader (and writer) processes. You do not run into any locks until you execute write transactions concurrently.