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
My understanding is that this is still too slow for quick inserts, because duckdb (like all columnar stores) is designed for batches.
alt Hacker News
My understanding is that this is still too slow for quick inserts, because duckdb (like all columnar stores) is designed for batches.