Fetching from the wire…
Public story · 2026-08-26 · high
Farid Zakaria's format stores code, symbols and app data as SQLite rows in one file, so a live webserver updates its routes with no restart.
Why now: Zakaria posted the format and demo webserver on August 24, 2026.
Farid Zakaria built a Linux executable that stores its own code, symbols and application data as rows inside a SQLite database. Deploying a change means writing a row instead of shipping a new binary. The live process can be queried and audited with ordinary SQL while it runs.
His Self-Executing Linux Format hands the file to an interpreter through binfmt_misc. The interpreter reads a segments table to map code into memory and jump to the entry point. The running program finds its own path through argv[0], then queries itself for the rest.
The payoff shows up in his demo webserver, which keeps its routes, visits and presses as tables inside the same binary it runs from. It reports 13 segments, 179 symbols, 105 relocations, 3 routes and 103 visits. Zakaria can read or update any of that data by transaction, with no restart.
Zakaria says the format buys him ACID deployments, sqldiff diffs between versions for an audit trail, and single-file distribution over scp. What he doesn't say is how a public-facing version would stop an untrusted request from reaching those same writable tables.
Each link below shares sources, entities, or timing with this story.
He set the 4-byte SQLite application ID at offset 68 to "SELF", decomposed an ELF binary's components into rows across a custom schema, and registered a binfmt_misc handler that hands the file to a self-exec interpreter which queries the tables and runs the program. One file,...
fzakaria/selfdb defines SELF, Structured Executable and Linkable Format, where the rows are the binary rather than a SQL view over ELF as in the author's earlier sqlelf (GitHub). It ships elf2self and self2elf converters, a binfmt interpreter with three modes including one tha...
The submission titled "CEO fired developers to make room for AI. Developers create open source AI CEO" pointed at SenteLabsAI/OpenExecutive, an Apache-2.0 FastAPI and Next.js 15 app running eight specialist Claude agents (CSO, CFO, CHRO, General Counsel, COO, CMO, CPO, Board C...
The argument is that agent discovery answers which agents exist but not who should work with whom once execution has begun. It evaluates three routes in one auditable objective: SELF when existing capability and context suffice, COLLABORATE when a small complementary team cove...
The r/ClaudeAI post drew 1,354 upvotes and 173 comments. Self-reported and unaudited, but bracket it against Willison's measured $23.28 for a 52-minute one-shot session and the shape becomes clear: sustained iteration is where the money goes, not generation. First drafts are c...
Triple-stream retrieval (BM25 keyword, vector embeddings, knowledge-graph traversal) fused via Reciprocal Rank Fusion on the iii engine, with SQLite for state and an in-memory vector index, no external database. The economic claim: ~170K tokens/year (~$10) versus ~650K tokens...
MindPattern daily
One email a day at 7 AM. Sources and a take on every story. Unsubscribe anytime.