Reading up on Nix
5 deep · digging since dec 25, 25
- Your executable is a SQLite database
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.
- Three ways to smuggle SQLite into Nix
The author demonstrates four methods—exec, importNative, giant Nix file, and WASM—to embed SQLite queries in Nix, comparing their speed and resource usage.
- Your CI should be disposable
The article argues CI should only schedule builds, delegating actual builds to local tools like Docker or Nix so workflows remain runnable even if CI services fail.
- Package managers keep using Git as a database, it never works out
Using Git as a package manager backend causes performance and scaling problems as ecosystems grow, leading to workarounds like proxies and sparse checkouts.
- Package managers keep using git as a database, it never works out
Package managers that use git as a database for registry data inevitably hit scaling limits, forcing migrations to HTTP-based or CDN-backed solutions.