Topic
SQL
2 posts from the Query.Farm blog tagged SQL.
DuckDB
Call an API From Every Row in DuckDB, Without the Loop
A table function turns an API call into rows in your database. A LATERAL join lets every row on the left call it — and VGI makes those calls in batches.
23 min read
DuckDB
A SQL WHERE Clause for Taste
I pointed DuckDB at Hacker News and at Jev, TypeSafe's decision model, and asked it to score 500 stories against one sentence about what I like. It took 17 seconds and cost less than a penny.
13 min read