3 ms·
I've been making a lot of use of SQLite WASM over the past few months. The other day I learned that it's built into Observable notebooks now - so if you have a
by simonw 4y ago
I've been making a lot of use of SQLite WASM over the past few months.
The other day I learned that it's built into Observable notebooks now - so if you have a SQLite database file that's hosted anywhere online with open CORS headers you can load and query that directly from a notebook.
This notebook here uses that trick: https://observablehq.com/@simonw/mastodon-users-and-statuses-over-time https://observablehq.com/@simonw/mastodon-users-and-statuses... - I wrote more about how that all works here: https://simonwillison.net/2022/Nov/20/tracking-mastodon/ https://simonwillison.net/2022/Nov/20/tracking-mastodon/
SQLite compiled to WASM is also bundled with the Python Pyodide WebAssembly system, which is how my https://lite.datasette.io/ https://lite.datasette.io/ Datasette Lite application works: https://simonwillison.net/2022/May/4/datasette-lite/ https://simonwillison.net/2022/May/4/datasette-lite/