Optimizing Datasette (and other weeknotes)
Simon Willison's Weblog: Entries
Loading Twitter Birdwatch into SQLite for analysis with Datasette
Simon Willison TIL
Weeknotes: Datasette, sqlite-utils, Datasette Desktop
Simon Willison's Weblog: Entries
DALL-E 3, GPT4All, PMTiles, sqlite-migrate, datasette-edit-schema
Simon Willison's Weblog: Entries
Subqueries in select expressions in SQLite
Simon Willison TIL
Ask questions of SQLite databases and CSV/JSON files in your terminal
Simon Willison's Weblog: Entries
Compiling and running sqlite3-rsync from a branch
Simon Willison TIL
Combining CTEs and VALUES in SQLite
Simon Willison TIL
DALL-E 3, GPT4All, PMTiles, sqlite-migrate, datasette-edit-schema
Simon Willison's Weblog: Entries
Measuring traffic during the Half Moon Bay Pumpkin Festival
Simon Willison's Weblog: Entries
Exploring the Overture Maps places data using DuckDB, sqlite-utils and Datasette
Simon Willison TIL
The SQLite now argument is stable within the same query
Simon Willison TIL
SQLite VACUUM: database or disk is full
Simon Willison TIL
Designing a write API for Datasette
Simon Willison's Weblog: Entries
Multi-threaded SQLite without the OperationalErrors
charlesleifer.com