November 28, 2025
One file to rule them all?
SQLite as an Application File Format
Developers swoon over one‑file apps; SQLite gets the crown
TLDR: SQLite is being pitched as a simple, single‑file way to store an app’s data that stays compatible for decades. Commenters largely cheered, sharing real projects and past threads, with minor tone‑policing drama—in short, big love for portable, future‑proof app documents that anyone can open anywhere.
Tech folks are buzzing over the idea of using SQLite—a tiny database that lives in a single file—as the go‑to way to save app data. The pitch: one file you can email, copy, and open anywhere, with decades of compatibility and no mysterious “opaque blob” formats. Commenters sprinted to share the previous thread, and the vibe was mostly “this is the future,” with one user marveling that it’s been backward‑compatible since 2004. That sparked a chorus of “you could do a lot worse” and nostalgic trust in tools that just keep working.
There was a tiny splash of drama when someone dropped the old link and another chimed in, “It’s a helpful link, not a criticism,” reminding everyone that tone is a feature too. Meanwhile, builders showed receipts: one shared a real project using SQLite as the single file for all data, with an HTML interface so anyone can use it in a browser—no installs, just open and go. It’s the dream of moving from messy piles‑of‑files to one tidy suitcase.
Humor showed up as devs joked about sending entire app states as attachments like “PDF who?” and calling out Git’s packfiles as the “mystery meat” they’re glad to avoid. The strongest take? SQLite as the simple, portable, future‑proof document format—we love to see it.
Key Points
- •SQLite database files with defined schemas are proposed as strong candidates for application file formats.
- •The article lists twelve benefits of using SQLite for application formats, including single-file documents and atomic transactions.
- •It distinguishes “file formats” (single object) from “application formats” (multiple objects and relationships).
- •Examples of custom application formats include DOC, DWG, PDF, XLS, PPT; these are often opaque and require specialized tools.
- •Pile-of-files formats like Git improve accessibility but include opaque components and are less convenient to move or treat as a single document.