DuckDBs concurrency model is not ideal for every use case. It's either single read/write process or multi read process (no write).
Other than that it's awesome. I've stuck to its native file format though as scanning SQLite is slower.
Other than that it's awesome. I've stuck to its native file format though as scanning SQLite is slower.
Perform OLTP actions against sqlite db from within duckdb.
Perform OLAP actions against duckdb db from within duckdb.
Sometimes your OLTP content drives the OLAP query so read from both sqlite db and duckdb db at the same time.