Recent Posts

Mar 9, 2023

Datasette SQLite PostgreSQL

Using SQL with GDAL Simon Willison TIL

Oct 29, 2022

Datasette

git bisect Simon Willison TIL

Oct 29, 2022

SQLite Datasette Python

The Perfect Commit Simon Willison's Weblog: Entries

Jan 10, 2023

SQLite Datasette

Scraping the Sky News Westminster Accounts, a Flourish application Simon Willison TIL

Feb 17, 2023

Datasette GraphQL SQLite

Analytics: Hacker News v.s. a tweet from Elon Musk Simon Willison's Weblog: Entries

Jun 5, 2022

Datasette

How to play with the GPT-3 language model Simon Willison's Weblog: Entries

Aug 16, 2022

SQLite Datasette

Analyzing Google Cloud spend with Datasette Simon Willison TIL

Aug 17, 2022

SQLite Datasette

Sort by number of JSON intersections Simon Willison TIL

Sep 16, 2022

SQLite Datasette PostgreSQL

Returning related rows in a single SQL query using JSON Simon Willison TIL

Sep 29, 2022

SQLite Datasette

Exploring 10m scraped Shutterstock videos used to train Meta's Make-A-Video text-to-video model Simon Willison's Weblog: Entries

Jun 30, 2022

SQLite Datasette

s3-ocr: Extract text from PDF files stored in an S3 bucket Simon Willison's Weblog: Entries

Jul 24, 2022

Datasette Python

Using pytest and Playwright to test a JavaScript web application Simon Willison TIL

Nov 1, 2022

Jekyll Datasette Ruby

GitHub Pages: The Missing Manual Simon Willison TIL

Dec 14, 2022

SQLite Datasette C

Comparing database rows before and after with SQLite JSON functions Simon Willison TIL

Feb 5, 2023

SQLite Datasette

The SQLite now argument is stable within the same query Simon Willison TIL