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 nattaylor on Friday March 25, 2022 @06:00PM (#30807420)
Can't wait to see what simonw comes up for using this with datasette!
[ Parent | on HN ]
Re:Directly running DuckDB queries on data stored in SQLite ... by simonw on Friday March 25, 2022 @06:44PM (#30807709)
Setting up a plugin hook that lets you use alternative database backends is getting more and more tempting...
[ Parent | on HN ]
Re:Directly running DuckDB queries on data stored in SQLite ... by notRobot on Saturday March 26, 2022 @12:07AM (#30809157)
Like PHP PDO? https://www.php.net/manual/en/book.pdo.php

Or are you talking about something else?

[ Parent | on HN ]
Re:Directly running DuckDB queries on data stored in SQLite ... by samwillis on Friday March 25, 2022 @06:30PM (#30807622)
This would be super useful for something I’m working on using datasette, querying across three tables with over 1.5m rows. Going to try the same queries on this tomorrow.
[ Parent | on HN ]
Re:Directly running DuckDB queries on data stored in SQLite ... by 41b696ef1113 on Friday March 25, 2022 @09:55PM (#30808646)
Exactly what I have been hoping to see as well. Analytical queries are a tad too slow for datasette, so I have had to materialize the more interesting roll-ups.
[ Parent | on HN ]