7 ms·
Hello! I would recommend trying out DuckDB's SQLite attach feature! You can read or write data, and even make schema changes, all with DuckDB's engine and synta
by 1egg0myegg0 2y ago
Hello! I would recommend trying out DuckDB's SQLite attach feature! You can read or write data, and even make schema changes, all with DuckDB's engine and syntax. The storage then uses SQLite, which is row oriented!
https://duckdb.org/docs/extensions/sqlite https://duckdb.org/docs/extensions/sqlite
(I work at MotherDuck and DuckDB Labs)
- wild_egg 2y agoThis is excellent — do you have any content around the performance affect here over using SQLite directly? I could see DuckDB's engine being faster for some cases but the SQLite storage format might hinder it. Curious if there's any analysis around this