News for hackers. Stuff that matters.

A comment on SQLite JSON at Full Index Speed Using Generated Columns. Parent comment

Re:SQLite JSON at Full Index Speed Using Generated Columns by mikepurvis on Friday December 12, 2025 @01:21PM (#46246974)
Whoa. Is that first query building an index of random filesystem json files on the fly?
[ Parent | on HN ]
Re:SQLite JSON at Full Index Speed Using Generated Columns by NortySpock on Friday December 12, 2025 @01:57PM (#46247405)
It's not an index, it's just (probably parallel) file reads

That being said, it would be trivial to tweak the above script into two steps, one reading data into a DuckDB database table, and the second one reading from that table.

[ Parent | on HN ]