Best of SQLite — December 2025

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

    Node.js — Node.js v24.12.0 (LTS)

    Node.js v24.12.0 (LTS) 'Krypton' has been released with several notable changes including HTTP server optimization options, stable type stripping support, new Node-API object creation methods, SQLite defensive flag configuration, watch mode configuration namespace, portable compile cache options, inspector permission controls, and V8 CPU profiling capabilities. The release includes numerous bug fixes, performance improvements, and dependency updates across modules like crypto, buffer, console, and testing infrastructure.

  2. 2
    Article
    Avatar of flydotioFly.io·24w

    Litestream VFS

    Litestream VFS is a SQLite plugin that enables querying databases directly from object storage backups without downloading the entire database. It supports point-in-time recovery through SQL pragmas, allowing instant queries against historical database states. The system uses LTX file format for efficient page-level compaction, fetches only needed pages via S3 range requests, implements LRU caching for hot pages, and can maintain near-realtime replicas by polling backup storage every second. The VFS module works as a plugin to existing SQLite installations without requiring application modifications.

  3. 3
    Article
    Avatar of hnHacker News·22w

    Backing up Spotify

    Anna's Archive created a comprehensive backup of Spotify containing 256 million track metadata entries and 86 million music files (~300TB), representing 99.6% of listens. The archive uses torrents for distribution, prioritizes tracks by popularity, stores files in OGG Vorbis (160kbit/s for popular tracks) and OGG Opus (75kbit/s for unpopular tracks), and includes the world's largest publicly available music metadata database with 186 million unique ISRCs. The metadata is structured in SQLite databases covering artists, albums, tracks, playlists, audio features, and file information, making it the first fully open music preservation archive that can be easily mirrored.

See all SQLite archives