Repository navigation
TxnStage v0.2.0
SQLite foreign-key rebuild experiments, complete-record preservation checks and updated public documentation.
Changes
- Add six built-in FK rebuild experiments covering cascading child deletion,
foreign_keystransaction boundaries, deferred checks, an old WAL reader and an explicit child save/restore control. - Inspect complete typed result tables in event details to compare data before DROP, after DROP and after COMMIT.
- Include portable scenarios and recordings, plus a separate preservation assertion that intentionally fails on the damaging rebuild and passes after restoration. Expected cascade loss remains a matched observation; SQL completion and assertion matching keep their existing meanings.
- Permit read-only, argument-free
PRAGMA foreign_key_check, with regression coverage for violations and rejected arguments. - Use schema-independent
SELECT 1for custom SQL after a successful schedule, including empty imported scenarios. Show the running application version in the header. - Update the README, scenario explanations, architecture, artifact reference, development and verification guides, and workbench screenshot.
These experiments run real SQL against bundled SQLite 3.53.2 in TxnStage-owned disposable databases. They demonstrate SQLite behavior, not a full Drizzle/D1 reproduction or a claim about defects in current ORM releases. The save/restore control covers the example's simple schema; it is not a general migration recipe.
Downloads
Choose Linux x86_64, macOS ARM64, macOS Intel (x86_64) or Windows x86_64. Each archive includes the executable, license, documentation, all twelve built-in scenarios, recordings and the failing preservation-assertion example. Node.js and a system SQLite installation are not required.
Each archive has a matching SHA-256 checksum and an .environment.json file with its SQLite version, source ID, compile options and platform.
Extract the archive and run ./txnstage serve (txnstage.exe serve on Windows). Open the complete local URL printed in the terminal. Ctrl+C stops workers and removes the experiment database. TxnStage cannot open existing user databases.
macOS binaries have no Developer ID signature or notarization. Windows binaries are unsigned. The Linux binary requires glibc 2.39 or newer.
The artifact format remains version 1. Sample recordings retain their original capture metadata; the viewer reports environment differences when opening older captures.
Verification
The release is built from commit 776d1c2c78f37f338aafc0f2ea230d02fdfa5bee. Native tests, frontend checks and headless UI tests passed for all four targets in the release workflow. General CI checks Linux, macOS and Windows.
Before publication, all four archives were checked for SHA-256 integrity, binary architecture, application and SQLite versions, and complete package contents. The downloaded macOS ARM64 executable also passed a standalone smoke check with source assets hidden and PATH empty, including embedded asset serving, worker shutdown and database cleanup.