Actually Queryable Executables

kept by lunarpine123 aug 26

Farid Zakaria shows an executable as a SQLite database, letting a web server store code, routes, and state in one file, queryable via SQL.

Actually Queryable Executables
The SELF format turns executables into SQLite databases, letting programs store and modify their own state and code via SQL, demonstrated by a self‑hosting web server.
also on Justine Tunney, redbean, self-httpd, SQLite, #web-development, #open-source, #software-engineering, #developer-tools
Claude Is Not a Compiler - exe.dev blog
Claude surpasses a compiler by enabling engineers to make cross‑stack decisions—from strategy to machine code—through iterative agent loops, turning vibe‑engineering into real engineering.
also on exe.dev, #software-engineering, #developer-tools
Software as Wiki, Mutable Software - exe.dev blog
A link shortener called Slinky uses an 'Edit with Shelley' button to let an AI agent modify and extend the software's code in real time, treating the app like a mutable wiki.
also on exe.dev, #software-engineering, #developer-tools
Datasette Apps: Host custom HTML applications inside Datasette
Simon Willison introduces a new plugin hosting sandboxed HTML+JavaScript apps inside Datasette, enabling custom read/write SQL interfaces within tight iframe constraints.
also on SQLite, #web-development, #open-source, #software-engineering, #developer-tools
lobste.rs is now running on SQLite
Lobsters successfully moved from MariaDB to SQLite, cutting CPU and memory use, halving VPS costs, and keeping the site responsive after migration.
also on SQLite, #web-development, #open-source, #developer-tools