https://simonwillison.net/2021/Jun/19/sqlite-utils-memory/
Joining CSV and JSON data with an in-memory SQLite database
The new sqlite-utils memory command can import CSV and JSON data directly into an in-memory SQLite database, combine and query it using SQL and output the...
joining csvjson datamemory
https://simonwillison.net/2022/Jun/20/datasette-lite-csvs/
Joining CSV files in your browser using Datasette Lite
I added a new feature to Datasette Lite—my version of Datasette that runs entirely in your browser using WebAssembly (previously): you can now use it to load...
joining csvbrowser usingfiles