All posts

Oct

• The WAL file never shrinks on its own

  2026-10-02 · 1 min read
  Note

  • #SQLite
  • #Operations

  The -wal file next to the database only grows: wal_autocheckpoint writes pages back to the main database, but it never shortens the file.

Sep

• Turning on WAL is the cheapest SQLite change you can make

  2026-09-28 · 1 min read
  Note

  • #SQLite
  • #Performance

  Set journal_mode to WAL and write contention drops without touching any business code.

• Starting here

  2026-09-20 · 1 min read
  Post

  • #meta

  Why this site exists and what I plan to write.

• How this site is built

  2026-09-18 · 1 min read
  Post

  • #meta
  • #engineering

  Design trade-offs behind the two-repository split, the content contract and build-time gates.