← Latest briefing

Technology

Developer presents experimental binary format using SQLite databases as executables

The SELF proof-of-concept embeds compiled program binary segments and application runtime state into a single SQLite file.

The short version

  • Developer Faraz Zakaria introduced SELF, an experimental binary format that structures executable programs as SQLite database files.
  • Using kernel mechanisms like binfmt_misc alongside argv[0], executables can directly query and update their own database structure and transactional state while running.
  • A proof-of-concept web server, self-httpd, demonstrates storing binary code, static web routes, visitor logs, and application state within a single executable file.

Key facts

  • The SELF format structures an executable binary as a SQLite database file.[Hacker News]
  • The implementation relies on binfmt_misc to invoke an interpreter, which maps program segments from the SQLite file before handing off execution while passing the file path through argv[0].[Hacker News]
  • The self-httpd proof-of-concept web server stores application code, website routes, and runtime logs transactionally in its own file.[Hacker News]
  • Application updates for SELF executables can be managed similarly to database migrations using SQLite ATTACH and INSERT statements to migrate state between software versions.[Hacker News]

What remains uncertain

  • The developer noted that the project is an experimental proof of concept and described its underlying codebase as potentially incomplete.[Hacker News]

Sources