Skip to content
KG.
  • Blog
  • Hire me, or see what I ship.

    • ProjectsCase studies & shipped work
    • ServicesWork with me
    • SponsorSponsor the blog
  • Essays and references on AI engineering.

    • BlogEssays on AI engineering
    • Learning PathsGuided curricula
    • Topic PillarsDeep-dive hubs
    • GlossaryAI & dev terms, defined
    • CheatsheetsQuick references
    • ComparisonsX vs Y, decided
  • Things to click, play, and take apart.

    • Tools29 dev & AI utilities
    • Games16 browser games
    • DemosInteractive explainers
    • ChallengesDaily coding puzzles
  • Me

    • AboutWho I am
    • UsesMy gear & setup
    • ResumeCV (PDF)

    Shelf

    • BookshelfBooks I recommend
    • Reading ListWhat I'm reading
  • Subscribe
  • Let's talk
  1. Home
  2. ›
  3. Blog
  4. ›
  5. Migrations

Migrations

1 post tagged #migrations

black iphone 4 on white table Developer Tools

Single File Web App SQLite: Migrations + Backups That Work

“One binary + one database file” is a great deployment model until you hit migrations under load and WAL backups. Here’s the safety-first playbook I actually trust.

September 16, 2026 12 min read
Read more

Keep exploring

Close to this topic, not on this page.

  • Render vs Railway for Side Projects: Pricing, DX, Uptime I'd pick Render for stable, set-it-and-forget-it side projects that need a free tier, and Railway for fast-moving apps where developer… 12 min read
  • SQLite vs PostgreSQL for App Backends: When to Use Each I'd pick SQLite for single-server apps under ~10k daily active users and PostgreSQL the moment you need concurrent writes, multi-node… 11 min read
  • arXiv API Rate Limits: Ingest Papers Without Getting Blocked arXiv capped author submissions on Oct 1, 2026, and its API allows one request every three seconds. 10 min read

Content

  • Blog
  • Topic Pillars
  • Learning Paths
  • Games
  • Demos

Resources

  • Tools
  • Glossary
  • Cheatsheets
  • Comparisons
  • LLM Prices
  • Embedding Prices

About Me

  • About
  • Uses
  • Bookshelf
  • Reading List

Meta

  • Subscribe
  • Changelog
  • Sitemap
  • Privacy
  • Terms
  • RSS
KG

Building intelligent systems. Still chasing those sour icecreams.

Made with coffee and curiosity in Toronto. 2026.