top | item 46499015

(no title)

nlittlepoole | 1 month ago

DuckDB can read/write SQLite files via extension. So you can do that now with DuckDB as is.

https://duckdb.org/docs/stable/core_extensions/sqlite

discuss

order

sanderjd|1 month ago

My understanding is that this is still too slow for quick inserts, because duckdb (like all columnar stores) is designed for batches.

theanonymousone|1 month ago

The way I understood it, you can do your inserts with SQLite "proper", and simultaneously use DuckDB for analytics (aka read-only).