Simon Willison’s Weblog

Subscribe

Sunday, 9th April 2023

TIL Saving an in-memory SQLite database to a file in Python — I was messing around in Python with an in-memory SQLite database, when I decided I actually wanted to save my experimental database to a file so I could explore it using [Datasette](https://datasette.io/).
Release sqlite-history 0.1a0 — Track changes to SQLite tables using triggers
TIL Unix timestamp in milliseconds in SQLite — I wanted to retrieve the time in milliseconds since the Unix epoch in SQLite.
Release sqlite-history 0.1 — Track changes to SQLite tables using triggers