Changelog

Every release of @delali/sirannon-db, with the features and fixes each version shipped.

Synced from the Sirannon repository on 29 August 2026. The source of truth lives in CHANGELOG.md on GitHub.

0.3.3 (2026-08-26)

Fixes

  • ts: add missing TSDoc comments (7e3b642)

Thank You

  • assetcorp

0.3.2 (2026-08-26)

Fixes

  • ts: enhance TSDoc comments across various modules (5dfb443)

Thank You

  • assetcorp

0.3.1 (2026-08-26)

Features

  • ci: add republish option and update version description (1aa08d5)
  • ts: implement stallTimeoutMs for database copy operations (cd24a0b)
  • ts: add cluster status parsing and request credential handling functions (53aeb9a)
  • ts: add browser-only mode for SQLite app with SQL console integration (078c755)
  • ts: enhance live query and subscription error handling with onError callbacks (ed173fd)
  • ts: introduce beforeSnapshot hook for snapshot access control and enhance hook management in core and server (ab4a931)
  • ts: improve subscription management (3612886)
  • ts: implement console height management and resizable SQL console component (6e4a9f0)

Fixes

  • spec: enhance DDL validation to reject statements targeting reserved prefixes (477964b)
  • ts: update default server host and port values in ServerOptions interface (33a1d8e)

Thank You

  • assetcorp

0.3.0 (2026-08-23)

Features

  • add sirannon_stream_alive function and improve stream management with consumer tracking (5c541fb)
  • backup: introduce BackupChain and related interfaces (a3e70ba)
  • benchmarks: introduce BENCH_SCHEMA_TIMEOUT_MS for schema reset limits (25365d1)
  • ci: add Zig setup and build step for streaming extension (fab2604)
  • ci: improve Zig setup, build steps, and new backup job (2e88f30)
  • docs: update backup documentation (966b57e)
  • native: add cross-platform SQLite streaming extension support for macOS, Linux, and Windows (5b3528d)
  • native: add platform-specific README (c6a17e1)
  • spec: define extension loading process and requirements in SQLiteDriver and Core specifications (fcf963d)
  • spec: improve backup functionality with stepped copy capabilities and detailed error handling (1655f66)
  • spec: improve backup and change capture specs (f6f0bb0)
  • spec: enhance backup cycle options with replication group support and preferred node resolution (05613b0)
  • spec: add server backup capabilities (a0cd995)
  • spec: add timeout handling and error clarifications (58c1b21)
  • tests: improve streaming backup tests with Node.js version checks and URI parsing support (4c1d074)
  • ts: improve SyncController with webSocketProtocols and onStatusChange options (5079d56)
  • ts: add cluster status reporting functions and update documentation (378b661)
  • ts: rebuild examples (fb9f5e6)
  • ts: update Dockerfile to include Python and build tools for examples (04be4d1)
  • ts: add Sirannon distributed-entitlements example with manifest and assets (1614e93)
  • ts: implement backup capabilities and destination handling (a8c15e8)
  • ts: improve memory destination handling (aca2372)
  • ts: improve backup chain validation (11c67c9)
  • ts: add streaming backup support and improve database copy capabilities (d27d1c3)
  • ts: add destination timeout feature for backup operations and enhance streaming support (9fc299c)
  • ts: implement backup restore with progress reporting and options for batch size (3df8b56)
  • ts: implement backup cycle enhancements with replication group support, preferred node selection, and log management (34c7c46)
  • ts: add writePieceIfAbsent function to BackupDestination for conditional piece storage and enhance backup cycle logic with improved chain handling (e26bf40)
  • ts: enhance backup cycle reporting with uncaptured log bytes (fc30ee2)
  • ts: add server backup capabilities (0ec6b79)
  • ts: improve backup reporting with file metrics and add new interfaces for backup file reports (1bfba36)
  • ts: add improved reporting mechanisms (79bef0f)

Fixes

  • avoid console errors (0471e61)
  • improve sirannon stream management with stopped taker tracking and function renaming (8c6856e)
  • enhance backup restore process by ensuring write-ahead log is folded into database before removal (88c5973)
  • docs: clarify VFS extension description in ADR 0007 (1a215dd)
  • docs: correct number of C files in backup ADR 0007 (d72ccad)
  • spec: clarify backup error handling (87d27c4)
  • ts: address tab locking issue (110c6f0)
  • ts: load SQLite extensions through each runtime's own call (3066d8f)
  • ts: reject relative paths in extension loading and enhance connection handling (172504b)
  • ts: address issues with database lifecycle management and backup processes (87f5bb6)
  • ts: clear optionalDependencies in package.json for better package management (5b66069)
  • ts: address backup destination timeout issues (e5bb04a)
  • ts: ensure proper handling of database logs during backup restore process to prevent data loss (25e4218)
  • ts: refine preferred node selection logic and enhance log measurement error handling (2313587)
  • ts: clarify onSkip reporting details and enhance log tracking during skipped turns (2374645)
  • ts: address timeout handling and error codes (87505ae)

Thank You

  • assetcorp

0.2.2 (2026-08-04)

Fixes

  • ts: address subscription filters and WebSocket options bug (63a6995)

Thank You

  • assetcorp

0.2.1 (2026-08-04)

Features

  • restrict id-token write permissions to specific workflows (a643982)
  • ts: add expo and bun SQLite drivers with API documentation (9127b19)

Thank You

  • assetcorp

0.2.0 (2026-08-02)

Features

  • spec: add queryWithPosition method and transaction boundary details to core specifications (b35e698)
  • spec: add rowId to ChangeEvent for improved change identification (ad6269e)
  • spec: enhance core specification with live query support and update error handling details (ab54a5a)
  • spec: enhance WebSocket upgrade handling with subprotocol negotiation and error codes (5cac654)
  • ts: implement registry-wide migration support (97acb23)
  • ts: improve migration handling with support for function-based sources and bundled SQL files (7871945)
  • ts: add stream verification support in replication protocol with batch digest handling (3116870)
  • ts: implement coordinator authority and lifecycle management for replication engine (706e46a)
  • ts: improve SyncJoiner to validate column names and structure in sync batches (4f4643f)
  • ts: add file-based rollback and lazy down migration support (e314d7d)
  • ts: implement migration checksum verification and improve system catalog with checksum handling (798f694)
  • ts: add baseline support and comprehensive testing (958ddb2)
  • ts: make system catalog improvements (18ff275)
  • ts: improve migration error handling and add concurrency support (23664c9)
  • ts: implement hybrid logical clock (HLC) for causal event ordering and enhance replication conflict resolution (7812668)
  • ts: introduce device cursor management and enhance sync capabilities with new database runtime and change application features (eca4fb2)
  • ts: implement new sync controller, topology-aware transport, and cluster routing management (199c300)
  • ts: add snapshot loading with progress tracking and schema management (ab76a0e)
  • ts: refactor HTTP request handling and improve snapshot loading (f638666)
  • ts: implement migration synchronization (497dc15)
  • ts: improve sync capabilities with server capability verification and HTTP request handling (668724c)
  • ts: add support for multiple table subscriptions (afd761e)
  • ts: add delete precedence and resync handling (bb29d23)
  • ts: add type checking for consumers and integrate into CI workflow (cf0ae0e)
  • ts: introduce onSnapshotComplete callback and enhance snapshot handling in SyncController (718b365)
  • ts: implement TopologyAwareClient and improve client structure for improved routing (5772579)
  • ts: implement live query in Database class (1b6785d)
  • ts: eimplement live query support and connection management (3098cd9)
  • ts: add support for live queries and improve server capabilities in the client (f9b8b1b)
  • ts: implement read concern support and improved error handling (2e65f4f)
  • ts: add read concern validation and options handling (5f18419)
  • ts: add read concern support and add related tests (4670b28)
  • ts: implement staged stream support in sync controller and related components (7dfde8a)
  • ts: revamp examples (e47131f)
  • ts: implement in-sync set reconciliation and enhance sync recovery mechanisms (3c584ef)
  • ts: improve gRPC transport with reconnection logic and timeout adjustments (2f8f991)
  • ts: enhance cluster node status reporting and coordinator connection handling (5806f8a)
  • ts: define NodeHealth structure and integrate it into cluster health reporting (f10f1ed)
  • ts: implement node health reporting in replication engine and update related status handling (4bec707)
  • ts: extend cluster health reporting with healthReason and update related components (10bbe99)
  • ts: add tests for applied position reporting in replication engine (1f0f180)
  • ts: add ReplicationAck handling for node connection states in replication process (604c941)
  • ts: improve WebSocket authentication with header support and subprotocol negotiation (534da0d)
  • ts: refine WebSocket transport handling with improved header and subprotocol validation (17576b0)
  • ts: improve sync controller and pull stream with header support for WebSocket upgrades (0ee012d)

Fixes

  • ts: improve error handling in sync controller and pull stream for better recovery (5161c53)
  • ts: update LiveDatabase interface to use 'unknown' (c9c53fd)

Thank You

  • assetcorp

0.1.8 (2026-07-20)

Features

  • benchmarks: add engine cgroup support and improve CPU usage tracking in benchmarks (d6bbcee)
  • benchmarks: add prepare retry and request timeout configurations (fc03813)
  • benchmarks: introduce WorkloadStallError for improved deadline handling in workload execution (d7db185)

Fixes

  • ts: ensure proper cancellation handling for worker requests and improve timeout management (4c383a6)

Thank You

  • assetcorp

0.1.7 (2026-07-20)

Features

  • introduce cloud benchmarking toolkit with support for multiple providers and automated result handling (a98b3fc)
  • add benchmark harness for Sirannon vs PostgreSQL comparison with Docker support and detailed reporting (cf2cd86)
  • add smoke preset for quick benchmarking and update README with usage instructions (5f0e865)
  • enhance cloud benchmarking with new profile options and update documentation (87495aa)
  • add timezone support for backup scheduling, including daylight saving time handling and validation for unknown timezones (8eb7677)
  • implement bulk load feature with configurable durability and synchronous levels, improving performance for batch operations (3d8e494)
  • improve bulk load functionality with checkpointing (fa8f4ba)
  • add batch and load methods to transport layers, enhancing bulk operation capabilities with configurable durability and request timeout (c1faf3a)
  • introduce timeout configurations and deadline handling in benchmark scripts and drivers to enhance stability and performance (f2dffc9)
  • improvr subscription with optional reset handling and backpressure management (200976f)
  • enhance WebSocket transport with epoch handling and introduce ForbiddenSqlError for reserved table access (87a1a62)
  • refine internal table access control by distinguishing between read and write operations for reserved identifiers (8522ffc)
  • implement encoding and decoding for tagged values in WebSocket transport, enhancing support for BigInt and binary data in change events (e916cfb)
  • implement value encoding for BigInt and BLOB types across transports (765517b)
  • improve FieldMergeResolver and ConvergenceOracle to handle BigInt and BLOB types without throwing errors, and improve data comparison using canonicalisation for checksum (2d669dc)
  • add queryForWire method for efficient single-pass reading of encoded rows, enhancing performance for BigInt and BLOB types across database operations (827dab9)
  • improve bulk load functionality with optional checkpoint control (115cdba)
  • implement loadAll method for efficient bulk loading with batching and durability control (38fd3df)
  • reimplement the benchmarks agianst running in docker (824d1d2)
  • enhance error handling and connection retries in measureCdcLatency function (a3350b1)
  • implement soak phase in benchmarks to evaluate sustained performance over extended periods (4791de7)
  • add VM_MAX_HOURS variable for self-delete backstop in cloud benchmarks (7872fe7)
  • benchmark: rewrite benchmark harness in node since sirannon runs note and node-pg is also available for postgress (97f488c)
  • ts: introduce writer worker for offloading disk writes (56944a7)
  • ts: add writerWorker option to Sirannon for configurable write handling (4b54609)
  • ts: implement GroupCommitter for batching concurrent writes in a single transaction (e7d5a54)
  • ts: add DatabaseCdcController for change data capture and enhance transaction handling (717ac6c)
  • ts: introduce DatabaseObserver for improved query observability and metrics tracking (2b2fe3b)
  • ts: implement pass classification and verdict determination for load testing (4a20c89)
  • ts: enhance WebSocketTransport to support transactions and improve transaction handling in tests (dd9804e)
  • ts: add support for writer worker offloading in SQLite drivers and enhance CI with browser bundle validation (6445470)
  • ts: introduce bundle checking and backup engine support in SQLite drivers (3b9f722)

Fixes

  • properly parse env vars (8891bcf)
  • update README and common script to clarify VM teardown behavior on exit (bc908f1)
  • replace Math.max with custom maxOf function to handle large sample arrays without stack overflow in latency measurements (96f0695)
  • address issues with batch import durability and clean up code (6a40c6e)
  • address issues with memory leaks (1c86df9)
  • ts: reject maxBodyBytes/backpressure above uWS 32-bit limit (66e2413)
  • ts: address worker crash issue (d89eb4e)

Thank You

  • assetcorp

0.1.6 (2026-07-05)

Features

  • ts: add totalTables field to SyncBatch and related structures for improved sync progress tracking (4be33e4)

Thank You

  • assetcorp

0.1.5 (2026-06-20)

Features

  • implement coordinator-backed automatic failover and enhance replication specifications (3c24e28)
  • docs: update README and TypeScript documentation to reflect new features in distributed replication, including conflict resolution, coordinator-backed failover, and enhanced security measures (e5f523c)
  • spec: introduce specifications for Sirannon's driver, core, replication, transport, server, client, and error handling modules (69bef40)
  • tests: add end-to-end chaos replication tests with mTLS and improve node storage handling (63e1b9e)
  • ts: add pool size sweep benchmark and improve existing benchmarks (8ba32b1)
  • ts: improve benchmarks documentation with new chart types and reference results; remove outdated CSV files (5f016a0)
  • ts: propagate read and write concerns through query hooks (3c0176b)
  • ts: extend change tracker for replication workloads (04960f4)
  • ts: add replication engine with Raft, log, and conflict resolution (80efba5)
  • ts: add memory and websocket replication transports (dd19768)
  • ts: add topology-aware Sirannon client (2856a01)
  • ts: expose replication status on readiness endpoint (38fded6)
  • ts: implement forward authorization in replication engine and enhance WebSocket transport with authentication (9984661)
  • ts: add recordColumnVersions method to track column changes in replication log (c73d50a)
  • ts: improve replication and transport layers with new features and error handling improvements (dad6693)
  • ts: add safety checks for SQL statements in ReplicationEngine and enhance DDL validation in log module (3a66bfa)
  • ts: implement convergence and fault policy mechanisms in simulated transport layer (58f56c2)
  • ts: enhance replication engine with acknowledgment timeout and in-flight batch tracking (465a44e)
  • ts: implement initial sync functionality in ReplicationEngine with enhanced sync state management and error handling (e45265e)
  • ts: enhance replication and transport layers with improved error handling, transport configuration, and type safety (1585b5c)
  • ts: improve ChangeTracker and ReplicationEngine (7c82874)
  • ts: use gRPC transport in place of websockets (701fbf4)
  • ts: add TLS identity validation and peer resolution in gRPC transport (a17a1fa)
  • ts: enhance ChangeTracker and ReplicationEngine with DDL handling and trigger management (2ab0236)
  • ts: add soak testing configuration and related tests (1ea4240)
  • ts: add etcd3 coordinator support and enhance replication client with read concern handling (965270c)
  • ts: enhance replication coordinator with compatibility checks and automatic failover requirements (6c42888)
  • ts: add failover testing framework and configurations for enhanced replication resilience (a96cd27)
  • ts: enhance failover node process with durability point checks and admission logic for in-sync set (fa00e93)
  • ts: implement execution target resolution for server and enhance HTTP/WS handlers for query execution (eb62ce9)
  • ts: add advanceToLatest method to ChangeTracker and update WSHandler to utilize it for improved change tracking (3d874d5)
  • ts: enhance activity and product management with normalization functions and improved event handling (e96d314)
  • ts: update web-client example with new fulfillment operations, improved server setup, and enhanced package dependencies (f7a858a)
  • ts: enhance security model in web-client example with WebSocket authentication and protocol validation (9d7cfdd)
  • ts: implement CDC event handling improvements and enhance BLOB decoding in change tracker (7622f04)
  • ts: add distributed entitlements example with Docker setup, gRPC replication, and enhanced UI components (0af9981)
  • ts: implement cluster routing fingerprinting and subscription migration for topology-aware transport (843a606)
  • ts: enhance distributed entitlements UI with new components and improved styling (327cd38)
  • ts: improve ui (fa8660b)
  • ts: implement majority write availability checks and enhance UI components for distributed entitlements (7229cc8)

Fixes

  • address all codrabbit reported issues (960e7f5)
  • ts: update bulk-insert benchmark to cap at 10K rows and improve documentation on performance metrics (d33d5a9)
  • ts: address security and reliability issues (6a25549)
  • ts: include options parameter in query method for improved database querying (22328f8)
  • ts: update lastSentSeq handling in ReplicationEngine to ensure accurate batch processing (e30e808)
  • ts: update connected peer check to use isConnected property for accurate transport status (e07029f)
  • ts: address issues with old raft replication (1edf150)
  • ts: address all security and reliability issues reported by coderabbitai (99e131f)
  • ts: address issues (74a8350)
  • ts: update SQL logic for duplicate outcomes (b94522b)
  • ts: address selection retry after coordinator primary change (bb6ba6d)

Thank You

  • assetcorp

0.1.4 (2026-03-20)

Features

  • ts: add pluggable SQLite driver adapter system (58dc122)
  • ts: improve wa-sqlite driver and tsup build config (8577ace)
  • ts: update benchmarks for pluggable driver and async API (4322c04)
  • ts: add example projects for each runtime (e10109a)
  • ts: overhaul web client for product inventory management with real-time updates (534ed8f)

Fixes

  • ts: idle check improvement for LifecycleManager (7a58903)
  • ts: validate extension path for control characters and improve path resolution in Database class (832abeb)
  • ts: address SQLite transaction hanlding in expo (adcf792)
  • ts: address flushAsync function in WSHandler tests for better message handling (f08cb87)
  • ts: address isseus with error handling in SirannonServer to manage unexpected errors during request processing (5c86b3e)
  • ts: move beforeConnect hook invocation to ensure it executes before database creation in Sirannon (b05cc60)
  • ts: fix backup path validation to prevent directory traversal and control characters in migration paths (94d4429)
  • ts: enforce read-only checks in Database methods and handle shutdown errors in Sirannon (dc58216)

Thank You

  • assetcorp

0.1.3 (2026-03-16)

Features

  • ts: implement core database modules with CDC, hooks, metrics, and connection pooling (f36acb1)
  • ts: improve connection pool and database error handling (03f2d0a)
  • ts: implement health and HTTP server endpoints for sirannon-db (136087a)
  • ts: implement Sirannon client and database proxy with HTTP and WebSocket transport support (2e93539)
  • ts: add backup and migration management features with corresponding tests (8b05527)
  • ts: enhance Database and ConnectionPool with extension loading, CDC support, and integration tests (be21f3f)
  • ts: add benchmarking suite for Sirannon with Postgres integration, including various benchmark scenarios and results reporting (8bf6d06)
  • ts: introduce Docker-based benchmarking suite for Sirannon, including end-to-end and engine-level benchmarks with detailed results reporting (e09d60a)
  • ts: expand benchmarking suite with concurrent read and mixed benchmarks, enhance configuration options, and improve statistical analysis features (a9bf2e3)
  • ts: update benchmarks to use batch processing, also improve statistical calculations, and Postgres connection handling (999e540)
  • ts: enhance benchmark engine with improved POST request handling and dynamic timeout estimation (b5e0270)
  • ts: update benchmarking suite to include concurrency scaling tests, replace outdated benchmarks, and enhance configuration for improved performance (aa683ca)
  • ts: improve migration system with file-based migrations and rollbacks (f100fe9)
  • ts: add statistical analysis features and CSV output for results (943d89a)
  • ts: improve benchmarking configuration and add CSV escaping utility with comprehensive tests (507c1ff)
  • ts: improve test coverage for backup and subscription management (1febd79)
  • ts: add new benchmark results and visualizations for micro-batch update, point select, and TPC-C lite workloads (7a34fa3)

Fixes

  • ts: improve RNG output precision (c8d5f2a)
  • ts: refine CORS handling in server and improve test coverage for origin matching (ec9b2b9)

Thank You

  • assetcorp