↓Skip to main content
Zeitgeist — a spike by Chris Gathercole
  1. Creators/
  2. Simon Willison — Creator of Datasette; co-creator of Django/

Your executable is a SQLite database

Blog · Watch/Read · (gathered 2026-08-29)

  • Simon Willison shares a fascinating Linux pattern that allows a SQLite database file to function directly as an executable binary.
  • This is achieved by setting the SQLite file’s 4-byte application ID to SELF (Structured Executable & Linkable Format), arranging ELF executable components into SQLite tables, and using a “self-exec interpreter” to extract and execute them.
  • The Linux binfmt_misc mechanism can be configured to teach the kernel to recognize and execute any file matching the SELF binary pattern, making the SQLite database itself a runnable program.