Best of SQLiteOctober 2025

  1. 1
    Article
    Avatar of newstackThe New Stack·33w

    Why We Created Turso, a Rust-Based Rewrite of SQLite

    Turso is a Rust-based rewrite of SQLite designed to address modern development needs while maintaining compatibility. SQLite's single-writer architecture, synchronous design, and limited extensibility create bottlenecks for high-throughput writes, real-time applications, and modern features like vector search and CDC. Turso introduces asynchronous I/O, concurrent writes through MVCC, native encryption, vector search, CDC support, and live materialized views. The rewrite enables SQLite-like simplicity with architectural improvements for edge computing, AI agents, and streaming analytics while fostering an open contribution model with over 150 contributors.

  2. 2
    Article
    Avatar of nodejsNode.js·30w

    Node.js — Node.js v25.1.0 (Current)

    Node.js v25.1.0 introduces several minor enhancements including an HTTP server option to optimize empty requests, SQLite defensive flag configuration, and a watch config namespace. The release includes updates to root certificates (NSS 3.116), dependency updates for simdjson, corepack, and inspector_protocol, plus V8 visibility improvements. Additional changes cover module loading refactoring, inspector network payload limits, test improvements, and build system updates including Visual Studio 2022 upgrade for Windows.

  3. 3
    Article
    Avatar of hnHacker News·32w

    Why Is SQLite Coded In C

    SQLite remains implemented in C because it provides optimal performance, universal compatibility across platforms and languages, minimal runtime dependencies, and stability. C enables SQLite to be called from any programming language, requires only basic standard library functions, and avoids the complexity of modern language runtimes. While safe languages like Rust are acknowledged as potential future options, the SQLite team prioritizes mature, well-understood languages and notes that recoding would likely introduce more bugs than it would fix. The article addresses common questions about why SQLite wasn't built with object-oriented languages or modern safe alternatives.

  4. 4
    Article
    Avatar of flydotioFly.io·31w

    Corrosion

    Corrosion is an open-source distributed service discovery system built with Rust, SQLite, and CRDTs that uses gossip protocols instead of distributed consensus. Developed by Fly.io to solve global state synchronization across their platform, it propagates SQLite databases using SWIM-based gossip and cr-sqlite for conflict resolution. The article details major outages caused by the system, including a deadlock bug that locked up their entire proxy fleet, and describes their iterative improvements: watchdogs for event-loop stalls, extensive testing with Antithesis, eliminating partial updates, and regionalizing clusters to reduce blast radius.