Relevant Articles

Mon Aug 29 2022

SQLite VACUUM: database or disk is full

Simon Willison TIL

Fri Oct 04 2024

Compiling and running sqlite3-rsync from a branch

Simon Willison TIL

Thu Jul 27 2023

Exploring the Overture Maps places data using DuckDB, sqlite-utils and Datasette

Simon Willison TIL

Mon Jan 30 2023

Combining CTEs and VALUES in SQLite

Simon Willison TIL

Wed Feb 21 2024

gemini-cli: Access Gemini models from the command-line

Eli Bendersky's website

Thu Jul 19 2018

Misadventures in Python Packaging: Optional C Extensions

charlesleifer.com

Thu Apr 20 2023

Data analysis with SQLite and Python for PyCon 2023

Simon Willison's Weblog: Entries

Wed Nov 09 2022

Designing a write API for Datasette

Simon Willison's Weblog: Entries

Tue Jun 11 2024

Modern SQLite: Delete limit

Sun Dec 31 2023

Last weeknotes of 2023

Simon Willison's Weblog: Entries

Wed Sep 13 2023

Trying out cr-sqlite on macOS

Simon Willison TIL

Sat Mar 16 2024

Weeknotes: the aftermath of NICAR

Simon Willison's Weblog: Entries

Mon Jan 30 2017

Multi-threaded SQLite without the OperationalErrors

charlesleifer.com

Thu Aug 25 2022

Building a searchable archive for the San Francisco Microscopical Society

Simon Willison's Weblog: Entries

Fri Jun 21 2024

Building search-based RAG using Claude, Datasette and Val.Town

Simon Willison's Weblog: Entries