GoKawiilDeveloper builds self-httpd, a web server that stores itself and its data in one SQLite file
Following up on his earlier SELF executable format that stores a program as a SQLite database, the author released self-httpd, a proof-of-concept web server whose code, website, routes, and visitor logs all live in a single SQLite file. The program reads its own instructions and writes new state, such as button-press logs, back into that same file transactionally, eliminating the need for separate folders like /var, /tmp, or /home.
GoKawiil's interpretation of the reporting above, not reported fact.
This approach collapses the traditional split between application binaries and their runtime data into one queryable, portable unit, which could simplify deployment, backup, and debugging for small services. It's an experimental idea rather than production-ready, but it hints at a future where SQL becomes the universal interface for both code and application state.
- self-httpd combines executable code, website content, and logs in a single SQLite database file.
- Program state, like button-press counts, is written back into the same file the program runs from.
- The concept builds on the SELF format, using SQL to unify binary tooling and application storage.
Using SQLite" by Jay A. Kreibich (O'Reilly) — If this SELF experiment has you rethinking what a single SQLite file can do, this O'Reilly book is a great deep dive into the embedded database at the heart of the idea. It walks through schema design, transactions, and the C API — exactly the ground you'd cover to build something like a self-storing executable.
See Using SQLite" by Jay A. Kreibich (O'Reilly) on Amazon → Affiliate link — we may earn a commission on purchases, at no extra cost to you. Product picked by AI based on this article; it is not a tested recommendation.Source: fzakaria.com, 2026-08-26
Published there as: “Queryable Executables”
Read the original report → The summary and analysis above are GoKawiil's own, written from reporting by the source above. Facts and quotes belong to the original publisher.