Simon Willison’s Weblog

A Minimalist Guide to SQLite. Pretty comprehensive actually—covers the sqlite3 command line app, importing CSVs, integrating with Python, Pandas and Jupyter notebooks, visualization and more.

Posted 2nd November 2017 at 1:23 am

Recent articles

A new SQL-powered permissions system in Datasette 1.0a20 - 4th November 2025
New prompt injection papers: Agents Rule of Two and The Attacker Moves Second - 2nd November 2025
Hacking the WiFi-enabled color screen GitHub Universe conference badge - 28th October 2025

pandas 16 python 1203 sqlite 302 jupyter 44

Monthly briefing

Sponsor me for $10/month and get a curated email digest of the month's most important LLM developments.

Pay me to send you less!

Sponsor & subscribe