Three ways to smuggle SQLite into Nix

kept by sundarpatel aug 21

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.
also on Nix, #software-engineering, #developer-tools
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.
also on Nix, #software-engineering, #developer-tools
SQLite for Everything
SQLite can replace many specialized systems—search, document store, queue, cache, vector DB, etc.—by serving as a single-file, zero‑maintenance database for applications.
also on SQLite, #performance, #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, #performance, #developer-tools