HeadlinesBriefing favicon HeadlinesBriefing.com

Time-Travel SQLite Debugger for Zero-Dependency Database Rewind

Hacker News •
×

GitHub's "time-travel-sqlite-debugger" is an open-source, zero-dependency tool built with PHP 8+ and Vanilla JS that lets developers instantly rewind corrupted or modified SQLite databases to any previous state. The CLI daemon watcher.php monitors database changes in real-time and automatically creates timestamped snapshots, enabling users to scrub back to any point in seconds during local development. The tool supports up to 50 backups, automatically purging older unpinned snapshots to prevent disk clutter, and offers a visual data diff viewer to compare row counts and table changes before restoration.

Key features include full i18n support with dynamic language switching, one-click snapshot pinning and export, and keyboard navigation shortcuts for smooth timeline interaction. Users can install and run the project with simple commands, opening a local web interface at http://127.0.0.1:8000 to manage their database timelines. The project is released under the MIT license and is available on GitHub for anyone needing a lightweight, no-framework database time machine.