Sqlite
-
TIL: sqlite3 .backup is way better than .dump
The online backup API produces a consistent copy without locking writers.
-
Migrating to SQLite STRICT tables: mostly boring, sometimes not
We turned on STRICT mode on a decade-old SQLite schema. Here is what broke.
-
What they don't tell you about SQLite WAL in production
WAL mode is a huge usability win for SQLite, but it has teeth that bite during backups, fsync, and NFS.
-
TIL: SQLite has RETURNING now
SQLite 3.35 added RETURNING, so you can get the inserted row back in one round-trip.
-
Recursive CTE to walk a parent-child tree in SQLite
The WITH RECURSIVE pattern for a self-joining table, with depth and path.
-
TIL: sqlite3 CLI has a .mode box
No more squinting at column output — box mode gives you pretty ASCII tables.