3 ms·
DuckDb supports reading/writing to a SQLite database, while using the improved DuckDB syntax. Sounds too good to be true, but I keep meaning to explore if there
by 0cf8612b2e1e 3y ago
DuckDb supports reading/writing to a SQLite database, while using the improved DuckDB syntax. Sounds too good to be true, but I keep meaning to explore if there are any obvious gotchas.
- samwillis 3y agoDuckDBs 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.
- chrisjc 3y agoBut isn't this the point of being able to use both duckdb databases and sqlite databases from the duckdb runtime? You can mix and match read/write use-cases within the same duckdb db runtime? 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.