My Hosting Platform Runs on Two SQLite Files. Here's How I Back Them Up and Bring Them Back.

Every app, database, and API key on my server is a row in a SQLite file. That sounds fragile until you see how SQLite's WAL mode and VACUUM INTO work. Here's where the files live, how backups run, and how to restore them on a new box.