Skip to content

Releases

TxnStage v0.3.0

Choose a tag to compare

@0then0 0then0 released this 11 Nov 15:40

Process crash and reopen experiments for real SQLite connections, with updated artifact support and public project documentation.

Fixed

  • Use preinstalled Google Chrome for Linux CI browser tests, avoiding APT mirror availability failures while keeping the full UI suite.

  • Pin Linux CI and release builds to Ubuntu 24.04 LTS for a stable browser-dependency and libc baseline.

  • Allow up to 15 seconds for large-recording completion messages in the CPU-throttled UI test, including on slower macOS Intel runners.

  • Restore frontend builds with Vite 8 by migrating editor chunk configuration to Rolldown's code splitting API.

  • Match the Biome configuration schema to version 2.6.4.

Added

  • Typed crash and reopen scenario steps: forcibly terminate one connection's worker process between confirmed statements, then open the same database file with a new worker. Available in scenarios, the CLI, recording replay and the workbench through Crash and Reopen on each connection card.
  • Three experiments for a process crash with an uncommitted transaction, after a confirmed COMMIT, and during a synthetic partially applied migration.
  • Artifact format version 2 for scenarios and recordings that contain crash or reopen steps. Version 1 files are still read, and a version 1 scenario without such steps is still exported and recorded as version 1.
  • Worker generation numbers in ready and lifecycle events, per-connection state in the workbench, and rollback journal size in filesystem samples.
  • Contribution, conduct and security policies, GitHub issue forms and a pull request template.
  • Editor settings matching Rustfmt and Biome, with LF line endings and protection for generated captures.
  • Repository and packaging checks for documentation links, ignored local files and policy files in release archives.

Changed

  • Update bundled SQLite from 3.53.2 to 3.54.1 through rusqlite 0.41.1.
  • Rewrite the README for first-time readers, add a documentation index and a repository layout, and restructure the architecture guide.
  • Workbench: experiments are grouped by topic in the list, each schedule step shows its explanation, Crash is visually secondary to Run, and the "fresh database" notice clears once a step runs.
  • Redraw the project icon as two overlapping transactions on separate connection lanes.
  • Pin workflow actions to commit SHAs, cancel superseded CI runs and require release archive uploads to contain files.
  • Include community policies and the changelog in future release archives.

Downloads and compatibility

Archives are provided for Linux x86_64, macOS ARM64, macOS Intel (x86_64) and Windows x86_64. Each includes the executable, documentation, policies, scenarios and recordings, with a matching SHA-256 file and SQLite environment metadata. Node.js and a system SQLite installation are not required.

Extract the archive and run ./txnstage serve (txnstage.exe serve on Windows). Open the complete local URL printed in the terminal. Experiments use only TxnStage-owned disposable databases.

Crash steps terminate a worker process at a confirmed statement boundary; they do not simulate a power outage, OS crash or storage-device failure. Reopen starts a new worker against the same experiment database. Format version 2 is used for scenarios and recordings with lifecycle steps; format version 1 remains readable and is still used for SQL-only exports. Older executables do not support version 2 lifecycle artifacts.

macOS binaries have no Developer ID signature or notarization; Windows binaries are unsigned. The Linux binary requires glibc 2.39 or newer.

Verification

Source commit: 15ac272751c340a21f0cdbc16647b40b11d6bc1d. Release builds and tests: https://github.com/0then0/txnstage/actions/runs/43049144754. General CI: https://github.com/0then0/txnstage/actions/runs/43049089471.

All changes since v0.2.0.

All four release jobs passed repository checks, frontend checks, native tests and the full UI suite. Archives were verified for SHA-256 integrity, binary architecture, versions and exact package contents. The downloaded macOS ARM64 executable also passed standalone asset serving and cleanup checks, plus all three crash/reopen scenarios.

TxnStage v0.2.0

Choose a tag to compare

@0then0 0then0 released this 24 Oct 19:48

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_keys transaction 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 1 for 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.

All changes since v0.1.1.

TxnStage v0.1.1

Choose a tag to compare

@0then0 0then0 released this 21 Oct 13:44

Patch release improving large-recording performance and adding qualified macOS Intel downloads.

Changes

  • Browse result previews in pages of 20 rows, keeping large tables responsive without changing exported data.
  • Fetch only new events when polling transaction state, avoiding repeated transfers of large result histories.
  • Serialize background and command-triggered state refreshes within each experiment, preserving reset and stale-response protection.
  • Strengthen regression coverage for large recordings, result pagination, incremental history and concurrent refreshes.
  • Isolate short-deadline tests from unrelated database initialization and retain release CI diagnostics on failure.

Downloads

Archives are available for Linux x86_64, macOS ARM64, macOS Intel (x86_64) and Windows x86_64. Each contains the executable, documentation, scenarios and sample recordings. Node.js and a system SQLite installation are not required.

Each archive has a matching SHA-256 checksum and .environment.json file describing its compiled SQLite version, source ID, 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 the server and removes its disposable experiment database.

macOS and Windows executables are unsigned. The Linux binary requires glibc 2.39 or newer. Experiments use TxnStage's own temporary databases; existing user databases cannot be opened.

The artifact format remains version 1. The v0.1.0 tag and release assets are unchanged.

Verification

All four platform jobs passed native, frontend and headless browser tests in the release build. Archives were checked for version, binary architecture, package contents and SHA-256 integrity before publication.

TxnStage v0.1.0

Choose a tag to compare

@0then0 0then0 released this 21 Oct 09:55
1d52414

First public release of TxnStage, a local visual laboratory for concurrent SQLite transactions.

Highlights

  • Run real SQL across two or three independent worker processes on a disposable database.
  • Explore six built-in schedules covering stale snapshots, writer contention, DEFERRED/IMMEDIATE transactions and WAL checkpoints.
  • Inspect typed results, busy callbacks, SQLite error codes, transaction state and an event timeline.
  • Edit and export schedules, inspect recordings without executing SQL, and replay them in a fresh database.
  • Use the workbench in a browser or execute scenarios from the command line. The native executable embeds the frontend and SQLite 3.53.2.

Downloads

Choose the archive for your platform: Linux x86_64, macOS ARM64, or Windows x86_64. Each archive includes the executable, documentation, scenarios and sample recordings. Node.js and a system SQLite installation are not required to run it.

Each archive has a matching .sha256 file and .environment.json file containing the compiled SQLite version, source ID, options and platform.

Extract the archive and run:

./txnstage serve

On Windows, use txnstage.exe serve. Open the complete local URL printed in the terminal. Press Ctrl+C to stop the server and remove its disposable database.

macOS and Windows executables are unsigned. The Linux archive requires glibc 2.39 or newer. Experiments are limited to TxnStage's own temporary databases; existing user databases cannot be opened.

See the included README and documentation for scenario format, resource limits and development instructions.

Platform qualification

The Linux x86_64, macOS ARM64 and Windows x86_64 release jobs passed their native and UI tests.

A macOS Intel archive is not included: its release job twice failed the large-recording UI check because the completion message did not appear within the five-second assertion window after a successful server response. Native tests and the other 15 UI tests passed on that target. This target is not qualified for this release.