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