Best of SQLite — February 2026

  1. 1
    Article
    Avatar of nodejsNode.js·13w

    Node.js — Node.js 25.7.0 (Current)

    Node.js 25.7.0 has been released with several notable changes: HTTP/2 gains an `http1Options` parameter for HTTP/1 fallback configuration, Single Executable Applications (SEA) now support ESM entry points, the built-in SQLite module is marked as a release candidate, `Duplex.toWeb()` type option is renamed to `readableType`, and the test runner now shows interrupted tests on SIGINT. Additional fixes include HTTP keep-alive socket reuse race conditions, FileHandle leaks in HTTP/2 and REPL, zstd memory tracking improvements, brotli compression dictionary support in zlib, and a new `throwIfNoEntry` option for `fs.stat`. npm is upgraded to 11.10.1.

  2. 2
    Article
    Avatar of architectureweeklyArchitecture Weekly·14w

    How I cheated on transactions

    Building a multi-database driver library (Dumbo) for Node.js revealed tradeoffs when supporting Cloudflare D1, which exposes databases via HTTP API and doesn't support traditional transactions. The solution uses D1's session-based repeatable reads and SQL batches to mimic transaction behavior, requiring explicit opt-in and accepting limitations like inability to rollback across multiple statements. This approach prioritizes API safety by making users acknowledge non-standard behavior while enabling practical use cases in event sourcing and document operations.

  3. 3
    Article
    Avatar of hnHacker News·14w

    micasa — your house, in a terminal

    micasa is an open-source terminal UI application for tracking everything related to home ownership — maintenance schedules, projects, appliances, vendors, quotes, incidents, and documents. All data is stored in a single local SQLite file with no cloud, no account, and no subscription required. Built with Go, it features vim-style modal keyboard navigation inspired by VisiData, and is available for Linux, macOS, and Windows on amd64 and arm64.

See all SQLite archives