News for hackers. Stuff that matters.

A comment on Directly running DuckDB queries on data stored in SQLite files.

Re:Directly running DuckDB queries on data stored in SQLite ... by samwillis on Friday March 25, 2022 @06:26PM (#30807597)
Would love to see a benchmark comparing SQLite, DuckDB and this SQLite/DuckDB combo with the same queries and data.

Is this adapter copying the contents of the SQLite db into DuckDBs own memory layout in order to optimise the queries or is it just “proxying” to the SQLite library?

[ Parent | on HN ]
Re:Directly running DuckDB queries on data stored in SQLite ... by 1egg0myegg0 on Friday March 25, 2022 @06:55PM (#30807780)
It is just scanning the data (in parallel), not copying it into DuckDB!
[ Parent | on HN ]