100k TPS over a billion rows: the unreasonable effectiveness of SQLitekept by eddie • dec 05, 25SQLite achieves over 100k transactions per second on a billion-row dataset by avoiding network overhead, though durability and HA remain trade-offs.AboutCollector · Hacker News · PostgreSQL · SQLite · Syncthing · TxtAIFiled#databases#developer-tools#performance#software-engineeringRelatedDeep dive into Turso, the “SQLite rewrite in Rust”Turso rewrites SQLite in Rust to enable a new database engine compatible with SQLite's file format while addressing C's memory safety issues and adding support for concurrent writes.also on #databases, SQLite, PostgreSQL, Hacker News, #software-engineering, #developer-toolsdebloat.dev — replace the junkdebloat.dev lists open-source alternatives to replace bloated vendor software, featuring projects like VSCodium, Immich, and Home Assistant with licensing and user ratings.also on Syncthing, #software-engineering, #developer-toolsMaybe we don't need a serverSyncthing syncs files directly between devices without a server, and the author imagines a future where calendars, contacts, and email are just synced files.also on SyncthingAn interactive visualization that follows a single HTTP request through its entire ~200ms life — DNS, TCP, TLS, the kernel, Node's event loop, Postgres, and backThe visualization walks through a single HTTP request's ~211 ms journey, showing DNS, TCP, TLS, kernel, Node event loop, Postgres, and rendering.also on #databases, #performance, #developer-toolsThree ways to smuggle SQLite into NixThe author demonstrates four methods—exec, importNative, giant Nix file, and WASM—to embed SQLite queries in Nix, comparing their speed and resource usage.also on SQLite, #performance, #software-engineering, #developer-tools
100k TPS over a billion rows: the unreasonable effectiveness of SQLite