{"repo":"nsrht/time-travel-sqlite-debugger","free":true,"listed":false,"github":"https://github.com/nsrht/time-travel-sqlite-debugger","clone":"git clone https://github.com/nsrht/time-travel-sqlite-debugger.git","description":"⏱️ A zero-dependency, ultra-lightweight database time machine for SQLite. Monitors changes in real-time and lets you scrub back to any previous state in seconds during local development!","language":"HTML","stars":42,"topics":["developer-tools","i18n","open-source","php","sqlite","time-travel","vanilla-js","zero-dependencies","database-debugger","wal-support"],"license":null,"category":"databases-storage","readme_excerpt":"⏱️ Time-Travel SQLite Debugger (Database Time Machine) An open-source, ultra-lightweight web application and CLI daemon designed to track and instantly rewind a corrupted or modified SQLite database file back to any previous state (e.g. 3 minutes ago) during local development — just like scrubbing a video. 🇹🇷 Türkçe Dokümantasyon: Türkçe rehber için lütfen README.tr.md dosyasına bakın. --- ⚠️ Important Note on Architecture & Local Development - Strictly for Local Development: This tool is designed for zero-dependency, local development debugging. - WAL Checkpointing & Abort Protection: Before creating any snapshot or performing a restore, the tool executes PRAGMA wal checkpoint(TRUNCATE); via PDO. If the WAL checkpoint fails (e.g. database busy or locked), the operation strictly aborts to prevent recording or loading un-flushed data. When successful, all WAL frames write into the main .sqlite file, eliminating race conditions without requiring separate -wal or -shm backup files. - Pre-Restore Safety Net & Validation: Prior to any restoration, an automatic pre-restore-safety-snapshot is generated. If safety snapshot creation fails, the restore process immediately aborts to protect current state. Post-restoration, PRAGMA integrity check; validates database structure. - Localhost Security & Quotas: API access is restricted strictly to socket peer IPs ( 127.0.0.1 / ::1 ), and disk usage is managed via 50-file unpinned snapshot count and 1 GB storage limits. --- 🚀 Features - ⚡ ","default_branch":null,"files":null,"tree":[],"storefront":"/r/nsrht","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/nsrht/time-travel-sqlite-debugger/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}