Articles from fzakaria.com

Farid Zakaria demonstrates how to add version‑range support to Nixpkgs using a clingo‑based solver (grail) that queries the nixpkgs multiverse for compatible revisions.

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

Replacing ELF with SQLite as an executable format (SELF) yields queryable binaries with ~1% size overhead, enabling closure‑based dependency packing and SQL‑based tooling.

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.

The author demonstrates four methods—exec, importNative, giant Nix file, and WASM—to embed SQLite queries in Nix, comparing their speed and resource usage.