Changelog

0.6.0 -- 2026-05-14

Added

add a test for xfer optimization bug in sqlite (Pavan Nambi)
Add regression test case for SQLite xfer optimization bug (Pavan Nambi)
core/mvcc: Add regression test for DESC index scan under concurrent insert (Pekka Enberg)
add proper benchmark names for create index benchmark functions (Pedro Muniz)
bindings/rust: Dynamic auth token support for sync engine (Nikita Sivukhin)
Make WITHOUT ROWID support experimental (Pekka Enberg)
add dbtest paper! (Alperen Keleş)
testing/sqltests: Add regression test for self-referential trigger after ALTER TABLE RENAME (Pekka Enberg)
testing: Add regression test for MVCC update on btree-only row (Pekka Enberg)
testing: Add recovery-heavy MVCC profile in Whopper (Mikaël Francoeur")
testing: Add recovery-heavy MVCC profile in Whopper (Mikaël Francoeur)
sqlite3: implement sqlite3_stricmp and sqlite3_complete (Lucas Schwalm Silva)
route FK NEW-image key reads through ColumnLayout (Mikaël Francoeur)
Add regression tests for pager panic after savepoint rollback with overflow (Jussi Saurio)
Add bind parameter support to Database API (Pekka Enberg)
testing/sqltests: Add regression tests for "index cursor should have a record" bug (Jussi Saurio)
tests/integration: Add regression test for VACUUM INTO panic (Jussi Saurio)
testing: Add regression tests for pragma_table_list() panic (Jussi Saurio)
add tests for table-valued functions (Mikaël Francoeur)
Add savepoint rollback DST coverage and fix rollback cache invalidation (Yassine Elyaakoub)
add a tool to measure stack usage (Pedro Muniz)
Implement PRAGMA foreign_key_list (Mikaël Francoeur)
core: Add initial support of vaccum op (Avinash Sajjanshetty)
concurrent-simulator: Add a coverage runner config (Pekka Enberg)
core/translate: UPDATE FROM support (Pekka Enberg)
core: support non-MVCC WITHOUT ROWID tables (Marc-André Moreau)
ci: add stack size workflow (Pedro Muniz)
bindings/python: Add SQLAlchemy asyncio dialect (Akira Noda)
Add STRUCT and UNION composite types for STRICT tables (Glauber Costa)
Bump activesupport from 7.2.3 to 7.2.3.1 in /examples/react-native (app/dependabot)
Add Go driver sync example to examples (Preston Thorpe)
core/connection: add a small helper to check if db is in-memory (Avinash Sajjanshetty)
add some sqltests (Pavan Nambi)
bindings/python: Add named parameter support (Akira Noda)
docs: add multiprocess access to sql-reference (Preston Thorpe)
fossier: add bot_policy = allow to prevent blocking dependabot (Preston Thorpe)
Bump addressable from 2.8.8 to 2.9.0 in /examples/react-native (app/dependabot)
add checkpoint flag for perf/memory (Pedro Muniz)
core: Implement initial support for multi-process database access (Preston Thorpe)
Introduce BTree constructor and RAII mutation guard (Mikaël Francoeur)
add series blob profile in perf/memory (Pedro Muniz)
Add CREATE DOMAIN / DROP DOMAIN support (Glauber Costa)
Add README for the turso npm package (Glauber Costa)
Add CREATE TABLE AS SELECT support (Glauber Costa)
serverless/javascript: Interactive transaction support (Pekka Enberg)
Fix encryption cipher mapping in promise API and add tests (Glauber Costa)
fix: support bracket-quoted JSON path keys in json_extract (Srinivas A)
Implement Temporary tables (Preston Thorpe)
Add tests that we store canonical schema for attached db (Avinash Sajjanshetty)
cli: sqlite-backed sqltests support for .schema and .tables (Rupesh Harode)
Add npm packaging for Turso CLI (npx turso) (Glauber Costa)
fix: enforce FK constraints on columns added via ALTER TABLE ADD COLUMN (Harin)
Add SQLite TCL conformance tests to CI (Pekka Enberg)
core/translate: Support compound SELECT in WHERE-clause subqueries (Pekka Enberg)
bindings/rust: Allow passing custom IO implementation to Builder (Hugues Morisset)
fix: implement .dbconfig dqs_dml to control double-quoted string fallback (Srinivas A)
bindings/tcl: Add prepared statement cache and Tcl variable binding (Pekka Enberg)
sqlite3: Implement sqlite3_stmt_status (Pedro Muniz)
sqlite3: Implement sqlite3_stmt_readonly (Pedro Muniz)
sqlite3: Implement sqlite3_progress_handler + sqlite3_interrupt (Pedro Muniz)
add top 30 current contributors to the vouch file (Preston Thorpe)
bindings/react-native: Add invalidate hook on iOS (Nikita Sivukhin)
Add new benchmark in core for triggers (Preston Thorpe)
core: Add read-only support for locking_mode pragma (Pekka Enberg)
core/connection: Improve ATTACH to properly initialize fresh databases (Avinash Sajjanshetty)
core: Add unistr_quote(X) scalar function (Edward)
core/translate: Add emit_table_column for transparent virtual column reads (Glauber Costa)
Add TPC-C benchmark (Preston Thorpe)
core: Implement PRAGMA full_column_names and short_column_names (Pekka Enberg)
Add script to clean up old RC versions from PyPI (Pekka Enberg)
Add statement origin tracking (Avinash Sajjanshetty)
Sync add column idempotent replay (Nikita Sivukhin)
bindings/javascript: Add per-connection and per-statement query timeout (Pekka Enberg)
Add more tests for generated columns (Mikaël Francoeur)
serverless: add query timeout support with AbortSignal (Pekka Enberg)
core/translate: Implement ORDER BY NULLS FIRST/LAST (Glauber Costa)
simulator: introduce yield injections 💉 for mvcc at safe resumable boundaries (Avinash Sajjanshetty)
sqlite3: Add Diesel-required C API functions (phase 2: value lifecycle) (João Lucas)
Add .NET support to README.md (Amodh Dhakal)
testing/sqltests: Add named window function test cases (Mikaël Francoeur)
Implement ALTER TABLE for virtual columns (Mikaël Francoeur)
add unistr(X) scalar function (Edward)
core/mvcc: add result to on_checkpoint_end (Pere Diaz Bou)
implement generated columns (Mikaël Francoeur)
Added VACUUM INTO tests with strict tables (Harin").)
Support ROW_NUMBER() (Kumar)
Support ROW_NUMBER() (Kumar Ujjawal").)
Add test to ensure compaction after vaccum into (Edgar Latorre)
sqlite3: support cache=shared for named in-memory URI databases (João Lucas)
Add DEFAULT keyword support in INSERT VALUES expressions (Glauber Costa)
core: implement ORDER BY for compound SELECT statements (Glauber Costa)
Add Linux aarch64 and macOS x86_64 to Python wheel build targets in CI (Kilian Hu)
Drop support for Python 3.9 and add Python 3.14 (Kilian Hu)
test: add integration test for VACUUM INTO on encrypted databases #5851 (Ratnesh Mishra)
Support ROW_NUMBER() (Kumar Ujjawal)
translate: implement INDEXED BY (Jussi Saurio)
perf: Implement Grace algorithm for hash joins to improve disk-spilling performance (Preston Thorpe)
core/regex: Add non text data for pattern matchin in regexp (Vartan Babayan)
sqlite3: implement URI filename parsing in sqlite3_open_v2 (João Lucas)
refactor: Add typed enum for SortComparitorType to replace heap String (Preston Thorpe)
Added VACUUM INTO tests with strict tables (Harin)
sqlite3: add Diesel-required C API functions (phase 1) (João Lucas)
docs: Removed unsupported macOS mold linker instructions (Amodh Dhakal)
add mvcc repl (Mikaël Francoeur)
perf/core/vdbe: add setters to Register to reuse the underlying allocation as much as possible (Jussi Saurio)
Add graph query benchmark with complex multijoins (Jussi Saurio)
fix(sqlite3): prevent sqlite3_initialize abort when tracing subscriber exists (João Lucas)
Add quick output diffing script for AI agents (Jussi Saurio)
translate/triggers: support subqueries in WHEN position (Preston Thorpe)
fix: Support ON CONFLICT definitions for PRIMARY KEY and UNIQUE columns (Jussi Saurio)
core: implement sqlite minmax optimization & unify simple agg handling & fix ordering cost model bug (Jussi Saurio)
Add TLA+ specification for SQLite WAL mode transactions (Pekka Enberg)
Add shuttle tests for MVCC scenarios (Avinash Sajjanshetty)
optimizer: support IN (list / uncorrelated subquery) as driver of scan+seek (Jussi Saurio)
Add instructions on how to run elle locally (Avinash Sajjanshetty)
Rewrite NEW/OLD inside nested trigger subqueries (Kumar Ujjawal)
Add PRAGMA to require UPDATE/DELETE queries to have a WHERE clause (Avinash Sajjanshetty)
docs: add CLI reference (getting started, options, shell commands) (Glauber Costa)
core/translate: Fix sqlite_sequence table initialization (Preston Thorpe)

Updated

core/mvcc: Ensure committed timestamp watermark is monotonic (Avinash Sajjanshetty)
core/mvcc: publish schema roots after checkpoint pager commit (Avinash Sajjanshetty)
concurrent-simulator: give reopen drain its own budget (Pekka Enberg)
Sync engine update pull time (Nikita Sivukhin)
concurrent-simulator: bound reopen drain loop with max_steps (Pekka Enberg)
update discord link in fossier workflow (Preston Thorpe)
core/vacuum: reenable disabled vacuum tests (Avinash Sajjanshetty)
github: Pin nyrkio/change-detection to commit SHA (Pekka Enberg)
github: Pin cargo-bins/cargo-binstall to commit SHA (Pekka Enberg)
github: Pin PThorpe92/fossier to commit SHA (Pekka Enberg)
bindings/rust: expose experimental_index_method on sync Builder (Mark Hinshaw)
core/mvcc: Deduplicate row versions by arc pointer and leave write set in transaction (Mikaël Francoeur)
Stabilize self-reading WHERE subqueries (Kumar Ujjawal)
core/io: improve io_uring IO backend by removing serialization (Preston Thorpe)
core/mvcc: remove clone of write_buf in logical log (Pere Diaz Bou)
bindings/tcl: accumulate rows across statements in db eval (Pekka Enberg)
core/schema: always get db id specific indices (Avinash Sajjanshetty)
core/mvcc: clean up faulted auto-checkpoints (Jussi Saurio)
core/fts: always load pager from db index (Avinash Sajjanshetty)
update production readiness FAQ to reflect current state (Glauber Costa)
core/vdbe: Shift IndexColumn.expr column refs after DROP COLUMN (Mikaël Francoeur)
core/mvcc: few perf improvements in write path (Pere Diaz Bou)
bench: create index on big table with mvcc (Pere Diaz Bou)
build(deps): bump openssl from 0.10.78 to 0.10.79 (app/dependabot)
bindings/javascript: Make Database.prepare() return a promise (Pekka Enberg)
Refresh cached sql when renaming columns (Mikaël Francoeur)
rewrite expression-index keys on RENAME COLUMN (Mikaël Francoeur)
core/vdbe: Prevent BEGIN IMMEDIATE with existing BEGIN CONCURRENT (Mikaël Francoeur)
split translate_expr code into separate files (Pedro Muniz)
core/io: Respect pwrite() and pwritev() size limit (Pekka Enberg)
core/mvcc: skip redundant eq-only seek during range deletes (Mikaël Francoeur)
core/vdbe: Allow users specify vacuum temp dir path (Avinash Sajjanshetty)
build(deps-dev): bump js-yaml from 3.14.1 to 3.14.2 in /testing/conformance/javascript (app/dependabot)
build(deps-dev): bump postcss from 8.5.6 to 8.5.13 in /examples/javascript/database-wasm-vite (app/dependabot)
serverless/javascript: preserve zero lastInsertRowid (Akira Noda)
core/vdbe: propagate yield-completions across nested-statement IO yields (Mikaël Francoeur)
optimizer: Properly use partial indexes for more query plans (Preston Thorpe)
docs: update vacuum and multiprocess status in compat.md (Avinash Sajjanshetty)
iterate schema rows in order in recovery (Mikaël Francoeur)
build(deps-dev): bump postcss from 8.5.6 to 8.5.12 in /examples/javascript/sync-wasm-vite (app/dependabot)
build(deps): bump tar-fs from 2.1.3 to 2.1.4 in /bindings/javascript/perf (app/dependabot)
core/IO: remove unnecessary Mutex on File IO (Preston Thorpe)
deps: upgrade tantivy and make default feature in sdk-kit (Preston Thorpe)
Make file lock FreeBSD compatible (Alexandr Jeliuc)
build(deps): bump tar-fs from 2.1.3 to 2.1.4 in /testing/conformance/javascript (app/dependabot)
Move JavaScript conformance tests (Pekka Enberg)
core/translate: UPDATE OR REPLACE conflict delete should not increment changes() (Ethan Balakumar)
core/mvcc: allow speculative reads in is_btree_invalidating_version (Pere Diaz Bou)
core/translate: Rewrite row payload when ALTER COLUMN changes affinity (Pekka Enberg)
core/storage: Clear stale overflow-read state and return corrupt on mismatch (ongyimeng)
Improve Turso database sync (Nikita Sivukhin)
sim: verify table contents after REOPEN_DATABASE fault (Ben Zaid)
core/io: improve windows IO back-end (Preston Thorpe)
Refactor ProgramState opcode state into single enum + Box commit state machines (Pedro Muniz)
Complete Windows multiprocess WAL port (Marc-André Moreau)
core/translate: reduce stack usage by boxing (Pere Diaz Bou)
core/storage: Reset syncing flag when sync submission fails (Pekka Enberg)
build(deps): bump openssl from 0.10.75 to 0.10.78 (app/dependabot)
Bump pygments from 2.19.1 to 2.20.0 (app/dependabot)
core/connection: consolidate usage of is_memory_like and is_memory_path (Avinash Sajjanshetty)
Bump glob from 10.4.5 to 10.5.0 in /serverless/javascript (app/dependabot)
core/vdbe: Transform root_page in MVCC for open read index (Pere Diaz Bou)
Bump requests from 2.32.5 to 2.33.0 (app/dependabot)
Bump bytes from 1.11.0 to 1.11.1 (app/dependabot)
core/connection: Prevent DETACH on databases with active transactions (Yassine Elyaakoub)
Compute virtual columns in topological order to avoid double-evaluation (Mikaël Francoeur)
never overwrite virtual columns with NULL (Mikaël Francoeur)
Bump json from 2.18.0 to 2.19.2 in /examples/react-native (app/dependabot)
Update rand crate to 0.9.4 (Pekka Enberg)
Compute virtual columns when checking deferred FKs (Mikaël Francoeur)
perf/latency: Remove stale Cargo.lock files (Pekka Enberg)
Honor USING deduplication in outer query refs (Jussi Saurio)
Use correct statement origin for pragma vtab helpers (Jussi Saurio)
Bump rustls-webpki from 0.103.8 to 0.103.13 (app/dependabot)
Bump time from 0.3.41 to 0.3.47 (app/dependabot)
Update drizzle-orm package (Pekka Enberg)
github: Switch macOS runners to Blacksmith (Pekka Enberg)
sqlite3: Expose sqlite3_search_count to TCL test harness (Pekka Enberg)
core/translate: Handle transitive unique constraints on upserts (Mikaël Francoeur)
core/translate: Make BitSet struct generic (Mikaël Francoeur)
bindings/javascript: Replace Promise with proper TableColumn[] type (ericfjl)
Update reqwest crate (Pekka Enberg)
core/translate: Avoid reallocating TableReferences on extend (Pedro Muniz)
bindings/javascript: Make Database.prepare() return a promise (Pekka Enberg)
core: minor refactoring and slop-removal (Preston Thorpe)
Update pytest to 9.0.3 (Pekka Enberg)
Compute and cache generated column dependencies eagerly (Mikaël Francoeur)
Update rand crate to 0.8.6 (Pekka Enberg)
Update rand crate (Pekka Enberg")
Update better-sqlite3 (Pekka Enberg)
Update rich dependency (Pekka Enberg)
Reduce allocations in multi-index analysis optimizer (Pedro Muniz)
Update rand crate (Pekka Enberg)
testing/javascript: regression test for stale query timeout guards (Pekka Enberg)
replace container types with BitSet (Mikaël Francoeur)
core/translate: remove some clones (Pere Diaz Bou)
testing/javascript: Update ava package version (Pekka Enberg)
Update oneshot crate (Pekka Enberg)
replace HashSet with ColumnMask (Mikaël Francoeur)
update fossier config (Preston Thorpe)
Evict stale cursor after btree_destroy during mvcc checkpoint (Harin)
Minor virtual column improvements (Mikaël Francoeur)
compute before image for virtual columns (Mikaël Francoeur)
core/vdbe: refactor vacuum into state machine (Avinash Sajjanshetty)
use key register for virtual column evaluation (Mikaël Francoeur)
replace TableMask with BitSet (Mikaël Francoeur)
ci: restrict PR labeler to main branch (Glauber Costa)
Enforce NOT NULL when updating virtual columns (Mikaël Francoeur)
core/mvcc: Serialize schema rows before data rows in MVCC logical log (Pere Diaz Bou)
Allow VACUUM INTO on attached databases (Vartan Babayan)
build example app in CI (Nikita Sivukhin)
core/translate: Enforce FK constraints on virtual generated columns with UNIQUE INDEX (Mikaël Francoeur)
core/mvcc: Make MVCC encryption less memory hungry with chunking (Avinash Sajjanshetty)
Enable fts in sdk-kit (Preston Thorpe)
cli: includes trigger in .schema like SQLite (Rupesh Harode)
core/mvcc: Pre-fetch record in delete() to avoid IO re-entrancy (Pekka Enberg)
core/translate: Track scope depth in outer query references (Pekka Enberg)
Update tar to 7.5.13 (Pekka Enberg)
bindings/rust: discard local sync server child stdio in tests (Pekka Enberg)
Update vite to 7.3.2 (Pekka Enberg)
Update lz4_flex to 0.11.6 (Pekka Enberg)
Update rollup to 4.60.1 and picomatch to 4.0.4 (Pekka Enberg)
Update lodash to 4.18.1 (Pekka Enberg)
core: Drop DATABASE_MANAGER lock after lookup (Pedro Muniz)
Empty result callbacks pragma (Pekka Enberg)
bindings/tcl: Enable generated columns (Pekka Enberg)
core/translate: Validate NOT NULL constraints on virtual generated columns in integrity_check (Mikaël Francoeur)
parser: Reject "#" as illegal token (Pekka Enberg)
core/vdbe: Trigger performance optimizations (Preston Thorpe)
Improve savepoint verification (Pekka Enberg)
core/mvcc: Recover insert-delete cycles in sqlite_schema table (Mikaël Francoeur)
core: Clean up ephemeral temp files (H0TB0X420)
perf/memory: Memory usage benchmark (Pedro Muniz)
github: Fossier integration for reducing potential AI slop PRs (Preston Thorpe)
core/translate: Apply declared collation of virtual generated columns in WHERE (Glauber Costa)
core: Switch to file ID for database registry mapping (Pekka Enberg)
core/mvcc: Enable encryption with MVCC (Avinash Sajjanshetty)
github: Publish .Net bindings to NuGet (Amodh Dhakal)
c-api: handle null statement ptr in sqlite3_reset (Preston Thorpe)
make OnSerializationComplete Callback return a Result<()> (Pedro Muniz)
Validate version in update-versions.py (Mikaël Francoeur)
core/translate: Allow duplicate table aliases, detect ambiguity at column resolution (Pekka Enberg)
Convert Python bindings to declarative PyO3 module syntax (Kilian Hu)
core/vdbe: Regenerate SQL when altering column with triggers (Preston Thorpe)
core: Represent MonotonicInstant as u128 (Elina)
translate/upsert: use emit_column_or_rowid for DO UPDATE row snapshot (ongyimeng)
core/translate: Allow trigger names their own namespace (Preston Thorpe)
return Result from Logical Log checkpoint callbacks (Pedro Muniz)
testng/sqltests: Update window-over-grouped snapshot after aggregate order change (Pekka Enberg)
core/translate: plan correlated subqueries at correct scope during window restructuring (Flanderzz)
Update COMPAT.md (Pekka Enberg)
Preserve rowid values in VACUUM INTO output (Kumar)
update napi-rs and js deps to latest versions (Nikita Sivukhin)
core/translate: Reject negative and out-of-range ORDER BY column indices (Pekka Enberg)
Strengthen VACUUM INTO coverage for partial and mixed indexes (Kumar Ujjawal)
core/translate: Handle ORDER BY/GROUP BY +N as column index reference (Pekka Enberg)
core/translate: Reject misuse of aggregate functions in ORDER BY (Pekka Enberg)
Upgrade PyO3 to 0.28.2 and maturin to 1.12.6 (Kilian Hu)
Reject outer-scope refs in GROUP BY subquery trees (Kumar Ujjawal)
core: Adapt null handling in json_string_to_db_type (Patrick Pichler)
simulator: gracefully rollback when a dependent txn aborts (Avinash Sajjanshetty)
storage/wal: minor refactoring to prep for multi-process (Preston Thorpe)
Local sync server no checkpoint (Nikita Sivukhin)
disable auto checkpoint for connections in sync engine (Nikita Sivukhin)
core/translate: avoid BETWEEN explosion in partial index (Duy Dang)
Preserve rowid values in VACUUM INTO output (Kumar Ujjawal)
rename testing/runner -> testing/sqltests (Pedro Muniz)
core/translate: prevent dropping columns referenced by triggers (Preston Thorpe)
Rust Bindings: remove unnecessary String allocations using Cow (Fahd Ashour)
Preserve cached expression collations without leaking aggregate/window state (Kumar Ujjawal)
Apply column affinity in WHEN register comparisons (Kumar Ujjawal)
Hide deleted rows from reverse secondary index scans (Kumar Ujjawal)
Reset DISTINCT aggregate state in correlated subqueries (Kumar Ujjawal)
core/stroage: Make buffer pool/slot bitmap lock-free (Preston Thorpe)
deps: replace unmaintained paste with pastey (Ulrich Hornung)
core/translate/perf: avoid redundant Copy instructions for cached aggregate args (Jussi Saurio)
core/translate: allow some datetime functions as expr indexes (Preston Thorpe)
Natural joins fallback to cross join if no common columns (Gaurav Sarma)
Reject unusable hidden-arg constraints in json_each/json_tree (Kumar Ujjawal)
core/translate/perf: GROUP BY - deduplicate column reads and shrink sorter size (Jussi Saurio)
Optimizer spring cleaning (Jussi Saurio)
translate/insert: Halt directly on FK conflict for single INSERT (Preston Thorpe)
core/mvcc: encryption plumbing for MVCC logical log (Avinash Sajjanshetty)
optimizer: rework CTE materialization logic and subquery cost estimation (Jussi Saurio)
core/translate: Rewrite trigger bodies on ALTER TABLE ddl stmts (Preston Thorpe)
Harden sqlite_schema predicates for quoted identifiers (Kumar Ujjawal)
core/mvcc: checkpoint and log serialization callbacks (Pere Diaz Bou)
parser/triggers: Reject RETURNING inside of trigger bodies (Preston Thorpe)
Adjust PR template (Preston Thorpe)
core/translate: Enable CROSS JOINs (Preston Thorpe)
optimizer: restructure access path selection to unify single-index and multi-index paths (Jussi Saurio)
Remove weird test that accepted views referencing attached dbs, but only in tursodb (Jussi Saurio)
core/mvcc: Log begin_ts when a txn is started (Avinash Sajjanshetty)
core/translate: Disallow cross-database view definitions (Flanderzz)
core/translate: Rename in-memory autoindex names on schema changes (Preston Thorpe)
return columns with correct casing (Mikaël Francoeur)
Eliminate sort when composite index satisfies ORDER BY (David Matějka)
perf: only use statement subjournal when it is actually required (Jussi Saurio)
core/mvcc: injectable DurableStorage trait for mvcc storage (Pere Diaz Bou)
Reject unreferenced CTE qualified columns without panic (Kumar Ujjawal)
Arrays (Glauber Costa)
compat: deny bare columns in TRIGGER WHEN clause (Pedro Muniz)
turso-serverless/compat: Serialize concurrent execute() calls with AsyncLock (Pekka Enberg)
core/mvcc: Disable no-op update optimisation (Avinash Sajjanshetty)
core/translate: main_loop refactor (Preston Thorpe)
enable triggers in differential fuzzer (Pedro Muniz)
go: use uintptr to exclude pointers from garbage collection (Piotr Sarna)
Bag of little perf tunings (Jussi Saurio)
core: Optimize prepared statement recompilation check (Jussi Saurio)
Optimize step() (Pekka Enberg)
Remove experimental flag from triggers, enable by default (Preston Thorpe)
Antithesis longer weekend run (Mikaël Francoeur)
optimizer: some finetuning for statsless heuristics + improve EXPLAIN QUERY PLAN (Jussi Saurio)
core/vdbe: Pass &Arc instead of Arc to Program::step() (Pekka Enberg)
Preserve explicit LIMIT 0 in scalar subqueries instead of forcin… (Vartan Babayan)
serverless: Serialize concurrent execute() calls on a connection (Pekka Enberg)
core/mvcc: Remove test_batch_writes test case (Pekka Enberg)
bindings/rust: Use the proper Column decl_type (Preston Thorpe)
Validate sqlite_schema before AUTOINCREMENT schema writes (Kumar Ujjawal)

Fixed

Fix breaking test with a diff yield point (Avinash Sajjanshetty)
Fix MVCC lock leaks (Jussi Saurio)
Switch to debug-level logging (Pekka Enberg)
core/translate: Fix RENAME COLUMN rewriting ORDER BY alias references in triggers (Pekka Enberg)
core/translate: fix UNION ALL dropping result columns when IN subquery present (Preston Thorpe)
core/translate: fix hash joins emitting incorrect cross products (Preston Thorpe)
windows: fix failing tests and disable some (Avinash Sajjanshetty)
core/mvcc: fix stale MVCC checkpoint bounds (Avinash Sajjanshetty)
github: Fix broken Rust workflow (Avinash Sajjanshetty)
core/mvcc: fix MVCC insert preserving stale B-tree cursor residency (Avinash Sajjanshetty)
core/storage: Fix savepoint rollback under cache pressure (Pedro Muniz)
core/storage: Fix WAL savepoint rollback on stale snapshot (Pedro Muniz)
fix/optimizer: resolve indexes per table reference, not by table name (fixes attach) (Jussi Saurio)
fix intendation rust workflow (Pavan Nambi")
fix intendation rust workflow (Pavan Nambi)
docs: fix javascript documentation reference (Josh Lyon)
core: Fix various gencol affinity test failures (Mikaël Francoeur)
Fix DELETE panic for indexed virtual generated columns (Mikaël Francoeur)
fix(update): populate chained virtual gen col registers before index rebuild (Mikaël Francoeur)
core/translate: Fix GROUP BY infinite loop (H)
fix: UPDATE skips rows when an FK cascade trigger mutates the target table mid-statement (Jussi Saurio)
core/translate: Fix panic in window-to-subquery rewrite with multiple window functions (Jussi Saurio)
core/translate: Fix stale indexes on ALTER COLUMN on virtual generated columns (Jussi Saurio)
core/storage: Fix pager panic with AFTER INSERT trigger (Jussi Saurio)
core/vdbe: Fix stale column name in trigger body after column rename (Jussi Saurio)
core: Fix cast numeric (Jean Arhancet)
core/translate: fix missing affinity for IN with compound subquery (Hossam Khero)
core/vdbe: Fix AVG() function precision for large integers (Hossam Khero)
Fix sync checkpoint bug (Nikita Sivukhin)
core/schema: expose corrupt error instead of unwrapping malformed catalog (Preston Thorpe)
Fix race in sdk-kit preventing multiprocess access from bindings (Preston Thorpe)
Fix UPDATE Halloween bug for mutable index scans (Mikaël Francoeur)
core/mvcc: Fix pager read lock panics after BEGIN DEFERRED then BEGIN CONCURRENT (Artur Kantorczyk)
JavaScript conformance test fixes (Pekka Enberg)
core/storage: fix WAL savepoint rollback corruption after cache spill (Ben Zaid)
bindings/go: Fix named parameter binding (Glauber Costa)
translate/refactor: remove resolve_label() footgun (Jussi Saurio)
serverless/javascript: Fix prepare() losing transaction baton (Glauber Costa)
Fix infinite loop on INSERT with two partial indexes (Jussi Saurio)
serverless/javascript: Fix empty blob decoding returning null (Glauber Costa)
parser: Fix parameter column names to match SQLite behavior (Glauber Costa)
serverless/javascript: Fix empty blobs and falsy rowids (Glauber Costa)
Fix INSERT OR IGNORE incorrectly rejecting omitted NOT NULL column (Ethan Balakumar)
core/vdbe: Fix string truncation for substr() and like (Rohith Suresh)
Fix MVCC integrity_check false positives when stale dropped-root bookkeeping overlaps with live schema rootpages (Preston Thorpe)
core/translate: Fix out of bounds caused by spurious covering index (Mikaël Francoeur)
Fix compatibility issues with Toasty (Glauber Costa)
Fix perf_nightly.yml (OpenByte)
core/translate: Fix concat() function error message (Pekka Enberg)
Misc build fixes (Jussi Saurio)
Fix CTE sharing decisions for correlated subqueries (Jussi Saurio)
core/translate: Fix integrity check panic (Mikaël Francoeur)
vdbe: Fix bug blocking pager IO incorrect/duplicate instance (Preston Thorpe)
Fix npm publish workflow asset name mismatch (Glauber Costa)
core/translate: Fix UPDATE rowid with indexed generated column (Mikaël Francoeur)
core/translate: fix UPDATE with FK when virtual generated column precedes non-rowid-alias PK (Mikaël Francoeur)
Expression index and integrity check fixes. (Glauber Costa)
translate: fix incorrect immediate FK violation when REPLACE restores a parent with the same key (Jussi Saurio)
translate: fix deferred FK violation counting (Jussi Saurio)
fix: allow dropping user-created UNIQUE indexes (#6359) (Srinivas A)
Fix trigger change accounting (Kumar Ujjawal)
Fix deferred FK mismatch on savepoint release (Pedro Muniz)
Fix Javascript examples by using await while executing stuff (aryaveersr)
MVCC stale row version fix during Checkpoint (Pedro Muniz)
Fix DELETE with index generated column (Mikaël Francoeur)
cli: Fix ".tables" to include views like in SQLite (Rupesh Harode)
core/translate: Fix GROUP BY out-of-range error message to say "GROUP BY" (Pekka Enberg)
deps: Bump aegis to 0.9.8 to fix build with clang 22 (Preston Thorpe)
fix: unhex(X, Y) ignores separator characters inside the input (Rupesh Harode)
Use dist precise-builds to fix release CI (Mikaël Francoeur)
core/translate: Fix INSERT column-count mismatch error message to match SQLite (Pekka Enberg)
Fix/6078 join limit offset false corruption (H0TB0X420)
Fix lack of reproducibility in builds (Mike Marcacci)
core: resolve compound SELECT ORDER BY against all constituent SELECTs (Pekka Enberg)
parser: match SQLite error messages for parse errors (Pekka Enberg)
core/storage: Fix savepoint rollback for dirty pages (ongyimeng)
fix: mark expression-index columns in col_used_mask during UPDATE planning (Mikaël Francoeur)
sync engine: INFO -> DEBUG, turso_core: DEBUG -> INFO (Nikita Sivukhin)
core/vdbe: fix wasm compatibility by making schema parsing re-entrant (Preston Thorpe)
fix: enforce CHECK constraints on virtual/generated columns (Mikaël Francoeur)
core/pragma: fix treating busy_timeout incorrectly as write transaction (Preston Thorpe)
Fix column quoting issues (Mikaël Francoeur)
Fix Mixed Case AutoIncrement Leaving Stale SQLite Sequence ROws (Zaid Humayun)
Fix: BEFORE UPDATE trigger panics on UPDATE with falsey TEXT literal (Amodh Dhakal)
Fix aggregate bare columns returning stale values when 0 rows match WHERE (Glauber Costa)
core/translate: Fix column names of unaliased expressions (Pekka Enberg)
core/translate: Fix upsert ignored when PK has ON CONFLICT IGNORE (Mikaël Francoeur)
core/translate: Match SQLite error format for ambiguous column names (Pekka Enberg)
Fix CI sccache setup to gracefully handle network failures (Pekka Enberg)
sdk-kit: Fix Database.close() not finalizing statements (Pekka Enberg)
core/translate: Propagate error from function resolution (Pekka Enberg)
bindings/tcl: Fix turso_tcl.c compilation (Pekka Enberg)
bindings/javascript: Fix Database.close() not finalizing statements (Pekka Enberg)
core/translate: Fix AUTOINCREMENT handling of BEFORE INSERT triggers (Preston Thorpe)
Fix unsound ON CONFLICT handling by restructuring it (Jussi Saurio)
core/mvcc: Fix abandoned transactions leaving their effects (Avinash Sajjanshetty)
fix agg functions panic on extreme float values (Alberto Moretti)
core/translate: Prevent CREATE VIEW and CREATE MATERIALIZED VIEW using reserved name prefixes (Vartan Babayan)
core/translate: Fix GROUP BY alias resolution precedence (Alberto Moretti)
fix: strip JSON subtypes at subquery/view boundaries (V. Can Keklik)
MATCH operator on non-FTS tables should error (Gaurav Sarma)
fix obvious mixup with global atomic in buffer pool (Preston Thorpe)
fix: last_insert_rowid() corrupted by INSERTs inside trigger bodies (Preston Thorpe)
core/json: Fix json_array_length(NULL) returns 0 instead of NULL (Artur Kantorczyk)
core/mvcc: Fix speculative delete conflict (Avinash Sajjanshetty)
fix dumb test bug (Jussi Saurio)
core/vdbe: Fix unicode(char(0)) to return NULL (Artur Kantorczyk)
perf/translate: more optimizer bugfixes (Jussi Saurio)
fix(sqlite3): use-after-free in sqlite3_value_blob (João Lucas)
core/translate: Fix subquery evaluation timing (Preston Thorpe)
fix: replace possible NULL value in user provided rowid in BEFORE INSERT triggers (Preston Thorpe)
fix: unescape JSON string escape sequences in JSON_EXTRACT and ->> operator (Mikaël Francoeur)
fix: BEFORE INSERT trigger sees raw values without column type affinity (Preston Thorpe)
fix: Outer statement conflict resolution not propagated to trigger body (Preston Thorpe)
fix: BEFORE UPDATE trigger does not fire when OR IGNORE suppresses violation (Preston Thorpe)
fix: Allow virtual table functions in trigger bodies (Preston Thorpe)
fix: Trigger SQL serialization strips identifier quoting #5868 (Preston Thorpe)
fix: RAISE() rejects non-literal string expressions for error message (Preston Thorpe)
fix: Duplicate trigger names accepted instead of being rejected (Preston Thorpe)
Display consistent error message for i_am_a_dummy pragma (Avinash Sajjanshetty)
Fix CLI creating wrong file when path contains query parameters (Glauber Costa)
core/translate: Two small trigger fixes (Preston Thorpe)
fix: json_group_array/json_group_object return [] / {} on empty input (Abhishek)
fix/mvcc: NullRow in MVCC cursors (Jussi Saurio)
fix: CREATE INDEX corrupting materialized views with sqlite_master data (Martin Mauch)
fix(json): return unquoted strings as plain SQL text (ratnesh mishra)
Fix multiple hash join bugs (Jussi Saurio)
Fix INSERT index vs NOT NULL DEFAULT mismatch (Martin Mauch)
fix: do not allow CREATE TRIGGER that references tables from different databases (Pedro Muniz)
core/pragma: clear dirty pages after changing page_size and fix handling of journal_mode (Preston Thorpe)
Fix window aggregate row value (practicat)
core/translate: Fix panic when PRAGMA query_only receives float literal (Sergio)
Fix view rewrites for rename column with subqueries and attached DBs (Kumar Ujjawal)
core/storage: Fix stale b-tree count cache (Glauber Costa)
Fix simple_count optimization not triggering case-insensitively (Jussi Saurio)
core/vdbe: Fix SUBSTR() with negative offsets for multi-byte UTF-8 strings (ratnesh mishra)
core/translate: Handle list_types=1 pragma with error instead of panic (Aly Abdelmoneim)
fix: Savepoint rollback of DDL causes I/O error instead of rolling back (Preston Thorpe)
Fix GROUP BY COLLATE sort-elision with implicit BINARY indexes (Kumar Ujjawal)
Fix INSERT failing on non-INTEGER PRIMARY KEY when column is omitted (Mikaël Francoeur)

0.5.0 -- 2026-03-04

Added

github/release: Add retry logic to network-dependent install steps (Pekka Enberg")
github/release: Add retry logic to network-dependent install steps (Pekka Enberg)
Add JS and Python concurrent write examples (Avinash Sajjanshetty)
perf/react-native: add c++ getAllRows() helper (Jussi Saurio)
perf: add compiler branching hints (Preston Thorpe)
Add concurrent writes example in Rust (Avinash Sajjanshetty)
Add SQLAlchemy dialect for Python bindings (Orthel Toralen)
mvcc: add test that asserts no ghost commits after Busy errors happen (Jussi Saurio)
core: Support views in MVCC mode (RJ Barman)
add return type checking for Function calls for CHECK constraints (Pedro Muniz)
Add mobibench to gitignore (Preston Thorpe)
Add native TCL extension for in-process SQLite test harness (Ahmad Alhour)
bindings/rust: Add statement and row column inspection APIs (Pekka Enberg)
cli/sync: add read timeout to prevent deadlock on Windows (Orthel Toralen)
add SQL language reference documentation (Glauber Costa)
add stable PRAGMA capture_data_changes_conn name and keep old one around for compatibility (Nikita Sivukhin)
Improve Elle, add rw-register model and chaotic workloads (Avinash Sajjanshetty)
Add Mobibench evaluation: SQLite vs Turso (Pekka Enberg)
core/io: Add POSIX fallback for io_uring ftruncate (Pekka Enberg)
temporarily remove new windows simulation runs (Preston Thorpe)
feat: support encryption keys for attached databases via URI params (Glauber Costa)
Finish implementing RAISE (Preston Thorpe)
autofix: implement FkCheck opcode to prevent RETURNING rows after FK violations (Jussi Saurio)
Support custom types (Glauber Costa)
tests/fuzz: add fuzz_iterations helper and cut CI fuzz iters to 50% (Jussi Saurio)
Add STRICT table support to differential fuzzer (Glauber Costa)
Add support for RAISE() function (Glauber Costa)
Add ATTACH support to simulator (Glauber Costa)
partially implement FULL OUTER + LEFT and RIGHT hash joins (Preston Thorpe)
EXPLAIN QUERY PLAN: fix incorrect join order, add missing annotations, convert some snapshot tests to EQP-only (Jussi Saurio)
bindings/rust: add old multithreaded bug reproducers as mvcc regression tests (Jussi Saurio)
core/mvcc: Implement Hekaton commit dependency tracking (Pere Diaz Bou)
tests: add CTE regression tests for issue #4637 (Jussi Saurio)
add serial test crate to make fuzz_pending_byte_database serial for mvcc and wal (Pedro Muniz)
Add more tests to foreign_keys.sqltest (Jussi Saurio)
tests: add regression tests for expression index UPDATE correctness (Pedro Muniz)
Implement named savepoints (Preston Thorpe)
feat: Add materialized views support to Rust bindings and test runner (Martin Mauch)
Fix STRICT ADD COLUMN default type validation (Kumar Ujjawal)
Fix freelist_count dirty leak and add regression test (Kumar Ujjawal)
core: reimplement PRAGMA integrity_check as VDBE and add sqlite parity corpus (Jussi Saurio)
Restore new antithesis assertions (Mikaël Francoeur)
Use new Antithesis assertions (Mikaël Francoeur")
fix: NEW.rowid_alias in UPDATE Trigger WHEN Clause Evaluates to NULL (Jussi Saurio)
Add MVCC Antithesis stress test configurations (Pekka Enberg)
add tests verifying check constraints are evaluated before ON CONFLICT clauses (Jussi Saurio)
Improve support for attach databases (Glauber Costa)
translate: support row-valued comparison expressions (Jussi Saurio)
fix: add changes support to MVCC and adjust code to always emit it in one place only (Pedro Muniz)
Add regression tests for correlated subqueries using MULTI-INDEX AND plans (Jussi Saurio)
add tests verifying INSERT RETURNING does not skip index updates (Jussi Saurio)
btree: add property tests & make a few functions not panic on corruption (Jussi Saurio)
Use new Antithesis assertions (Mikaël Francoeur")
add regression tests for correlated subqueries registers fix (Pedro Muniz)
Use new Antithesis assertions (Mikaël Francoeur)
Add regression tests for concurrent commit deadlock in VDBE yield-spin loop (Avinash Sajjanshetty)
Add TPC-H benchmark README and plotting scripts (Pekka Enberg)
fix: Panic on ALTER TABLE ADD COLUMN With Invalid Collation Name #5305 (Jussi Saurio)
ci: add license checker to disallow GPL dependencies (Srinivas A)
Add some makefile commands for test runner in repo root (Preston Thorpe)
add exp-index-method to rust backend and for testing (Pavan Nambi)
Add support for FROM-clause subquery materialization and CTE materialization (Jussi Saurio)
Add new antithesis assertions (Mikaël Francoeur)
concurrent-simulator: Add UPDATE and DELETE workloads (Pekka Enberg)
Implement PRAGMA function_list with enum-derived function probing (Glauber Costa)
Add hermitage tests (Avinash Sajjanshetty)
Fix corruption errors caused by stale cursor positioning + add upsert support to simulator (Pavan Nambi)
make transactions supported in compat.md (Glauber Costa)
Add REGEXP operator support (Glauber Costa)
Add test case for MVCC dual cursor transaction isolation (Jussi Saurio)
Implement CHECK constraints (Glauber Costa)
Replace panic/todo/unimplemented with proper errors (Mikaël Francoeur)
testing/runner: Add @skip-if sqlite directive (Preston Thorpe)
Implement multi-index scan access method (Preston Thorpe)
add tests for ORDER BY aggregate not in SELECT with GROUP BY (Mikaël Francoeur)
github: Add workflow to publish crates to crates.io on tags (Pekka Enberg)
javascript: Add support for Statement.reader property (Pekka Enberg)
javascript: Fix implicit connect support (Pekka Enberg)
Add busy timeout and Connector pattern for go bindings (Preston Thorpe)
core/mvcc: add to destroyed_tables when insert+delete in same checkpoint (Pere Diaz Bou)
core/vdbe: fix newrowid Start state change on IO (Pere Diaz Bou)
add duration and fix notebook name (Mikaël Francoeur)
Add support for PRAGMA synchronous=NORMAL (Jussi Saurio)
Use new Antithesis trigger action (Mikaël Francoeur)
core/mvcc: update schema root pages with new allocated btree pages (Pere Diaz Bou)
add --experimental-attach flag to test runner backends (Mikaël Francoeur)
add index knowledge skill (Pedro Muniz)
Implement vacuum_into op (Avinash Sajjanshetty)
fix: only initialize result registers for subqueries that have not been evaluated yet (Pedro Muniz)
fix: add bounds checking to cell_interior_read_left_child_page (Avinash Sajjanshetty)
Add Namespace field for go-sync package (Preston Thorpe)
Add "release-official" compilation profile (Jussi Saurio)
Add support for local encryption in SDKs (Avinash Sajjanshetty)
fix build.rs rebuilding every time due to always getting new timestamp (Jussi Saurio)
add turso test runner to workspace member (Pedro Muniz)
fix dockerfile to add dbhash tool (Pedro Muniz)
add ReadableName strategy for differential fuzzer so that we mostly generate readable identifiers (Pedro Muniz)
implement PRAGMA temp_store optimization (Preston Thorpe)
Add dbhash tool calculate hash of logical db content (Avinash Sajjanshetty)
Add local encryption support for Go (Avinash Sajjanshetty)
mac: introduce PRAGMA fullfsync (Jussi Saurio)
Reintroduce record header caching (Jussi Saurio")
Add new insert/write performance benchmarks (Preston Thorpe)
compat.md: add generated + md reformat (Pere Diaz Bou)
Add support for remote encryption in sync operations (Avinash Sajjanshetty)
core/mvcc: add savepoints to mvcc with begin/end_statment (Pere Diaz Bou)
Add benchmark for hash table/spilling performance (Preston Thorpe)
Reintroduce record header caching (Jussi Saurio"' from Jussi Saurio)
Reintroduce record header caching (Jussi Saurio")
Reintroduce record header caching (Jussi Saurio)
Implement remaining ON CONFLICT ResolveTypes for INSERT and UPDATE statements (Preston Thorpe)
feat(cli): add .read command to execute SQL from a file (i cook code)
add bench feature to run benchmarks in nyrkio (Pedro Muniz)
Implement partial ON CONFLICT support for UPDATE statements (Preston Thorpe)
Support CTE visibility in VALUES+RETURNING subqueries and allow explicit col names (Preston Thorpe)
Add ECS task to run sqlancer nightly along with simulator (Preston Thorpe)
implement simple strategy to restart WAL log if possible (Nikita Sivukhin)
Add VSCode syntax highlighter for .sqltest files (Jussi Saurio)
DEFAULT value handling of NON-NULL columns in ADD COLUMN (Preston Thorpe)
Implement Full Text Search feature (Preston Thorpe)
add codspeed (Pedro Muniz)
core/mvcc: Add support for synchronous off mode (Pekka Enberg)
Add support for subqueries in the WHERE position for DML statements (Preston Thorpe)
Add vibecoded stress-go testing tool (Jussi Saurio)
fix: implement IS TRUE/IS FALSE with correct SQLite semantics (Jussi Saurio)
Add shuttle tests for IO trait (Pedro Muniz)
bindings/rust: support prepare_cached (Pere Diaz Bou)
Add more comprehensive PRAGMA integrity_check, and add PRAGMA quick_check (Jussi Saurio)
tests: add some shuttle tests (Pedro Muniz)
benchmarks: add micro benchmarks with divan (Pedro Muniz)
AGENTS.MD: add some magic words about max-turns (Jussi Saurio)
Add more instructions to AGENTS.MD and use Opus model instead of Claude for github bot (Jussi Saurio)
bindings/dotnet: implement IsDBNull check (Alex)
Implement json_object(*) to create JSON object from all columns (Martin Mauch)
Add some more guidelines to AGENTS.MD (Jussi Saurio)
Add id-token: write permission to claude action for OIDC (Jussi Saurio)
Add claude code github action and CLAUDE.MD file (Jussi Saurio)
antithesis: Add test case for WAL checkpointing (Pekka Enberg)
implement .dbtotxt and dbpage vtab (Pavan Nambi)
bindings/java: Add transaction support (Kim Seon Woo)

Updated

core/mvcc: disable autoincrement for MVCC (Pere Diaz Bou)
testing/stress: Allow --seed parameter for non-deterministic runs (Pekka Enberg)
Update authors in Cargo.toml (Preston Thorpe)
refactor: reorganize emitter.rs into its own module (Preston Thorpe)
core/vector: Avoid simsimd on Windows AArch64 (Marc-André Moreau)
core/storage: Reject non-UTF-8 encoded databases on open (Mikaël Francoeur)
core/mvcc: Atomic timestamps when preparing commit (Avinash Sajjanshetty)
Differential fuzzer: detect more false positive with limit and order by (Pedro Muniz)
core/mvcc: move payload_size to frame header (Avinash Sajjanshetty)
Fast path no-op update in vdbe (Preston Thorpe)
Rename experimental_mvcc to mvcc (Eren Türkoğlu)
Update or replace ordering (Preston Thorpe)
Hash joins: partition spilling improvements (Preston Thorpe)
core/translate: Apply explicit view column aliases (Karthik Koralla)
core/translate: cache GROUP BY compound expressions properly (Jussi Saurio)
core: per-database MVCC transactions for attached databases (Glauber Costa)
Logical log tweaks (Jussi Saurio)
Assert that no two transaction timestamps are ever same (Avinash Sajjanshetty)
Update sqlite_sequence on ALTER TABLE ... RENAME TO (Kumar Ujjawal)
core/mvcc: Increase op count and tx payload size in logical log tx record format (Jussi Saurio)
core/translate: Use usable constraint even if preceded by unusable constraint on same column (Jussi Saurio)
Preserve BLOB-vs-no-affinity semantics in comparison coercion (Kumar Ujjawal)
compat: defer CTE column count check until its used (Pedro Muniz)
Improve SQLite3 tests (Pekka Enberg)
Accept trailing named column constraints in column defs (Kumar Ujjawal)
Enable index method table access for DML stmts (Preston Thorpe)
update unique_sets when renaming a column to prevent schema corruption (Glauber Costa)
Pretty print elle status progress (Avinash Sajjanshetty)
Decorrelate simple EXISTS / NOT EXISTS subqueries as semi/antijoins (Jussi Saurio)
Disable index-method access for DML (Kumar Ujjawal)
Avoid panic in DecrJumpZero on non-integer register (Kumar Ujjawal)
core/io: Track write buffer in completion (Jussi Saurio)
core/schema: Emit table-level UNIQUE constraints in BTreeTable::to_sql() (Jussi Saurio)
Avoid modulo-by-zero in WAL frame API fuzz rollback (Kumar Ujjawal)
enable async io in rust bindings (Pedro Muniz)
Make strict mode non-experimental (Glauber Costa)
Update misleading comment in MVCC (Avinash Sajjanshetty)
core/mvcc: Monotonic lockfree rowid allocation (Jussi Saurio)
core/mvcc: Use hash set to track commit dependencies (Avinash Sajjanshetty)
core/mvcc: check conflict delete btree resident tombstone (Pere Diaz Bou)
Adjust React Native example app instructions (Jussi Saurio)
Update example for VFS extensions in extensions/core/README.md (Preston Thorpe)
Enable partial indexes in MVCC mode (Preston Thorpe)
Enable Expression indexes in MVCC mode (Preston Thorpe)
Gate sqlite_dbpage writes behind --unsafe-testing (Kumar Ujjawal)
Enable FTS for JavaScript SDK (Nikita Sivukhin)
Sqltest cross check integrity (Jussi Saurio)
properly split sql statements for JS runner backend + enable triggers (Pedro Muniz)
Differential fuzzer improvements (Pedro Muniz)
core/translate: Remove spurious Affinity instruction from integrity_check (Pekka Enberg)
Remove some clones from MVCC code (Preston Thorpe)
remove Arc<RwLock<Statement>> from Insn::Program (Pedro Muniz)
ci: split bench into multiple jobs (Jussi Saurio)
Refactor core_tester fuzz module (Preston Thorpe)
Replace panic! and assert! with turso_macros assertions (Mikaël Francoeur)
SQLite compat: restrict ANY affinity special-casing to STRICT tables (Hossam Khero)
Enable MVCC for a bunch of fuzz tests (Preston Thorpe)
JS SDK: remote writes experimental (Nikita Sivukhin)
Reject triggers on virtual tables (Kumar Ujjawal)
serverless: Export Session and SessionConfig types (Nikita Sivukhin)
prevent scalar blob into JSONB (김선우)
install-sqlite: dont fail at get_download_url if sqlite3 already installed (Jussi Saurio)
refactor: stop using connection.with_schema inside translate module (Pedro Muniz)
Reject duplicate CTE names in WITH clause (Kumar Ujjawal)
Comment out flaky vector jaccard test (Preston Thorpe)
mvcc: disable cross-incompatible features (Jussi Saurio)
Random code cleanups to lib.rs (Pekka Enberg)
Reject column-level multi-column FK refs in ALTER TABLE (Kumar Ujjawal)
core: Make version functions non-deterministic (ratnesh mishra)
Experimental SQLRight setup (Mikaël Francoeur)
Reject FILTER clauses in view definitions (Kumar Ujjawal)
test/mvcc: re-enable database reopen logic in MVCC transaction fuzzer (Jussi Saurio)
perf: optimizations for FTS (Preston Thorpe)
CDC v2: transaction IDs and per-statement COMMIT records (Nikita Sivukhin)
Enable using Search for WHERE rowid= predicate instead of full scan (Preston Thorpe)
Reject reserved JSONB element types (Kumar Ujjawal)
core/mvcc: reparse schema on get_index_info (Pere Diaz Bou)
refactor: change translate functions to accept &mut ProgramBuilder (Pedro Muniz)
testing/stress: Remove multi-threading warning (Pekka Enberg)
github: Improve license check (Pekka Enberg)
core/mvcc: check for unique conflicts (Pere Diaz Bou)
Btree dump vtab (Nikita Sivukhin)
Cdc version table (Nikita Sivukhin)
vector8 + vector1bit (Nikita Sivukhin)
stress: Use single Database object (Pekka Enberg)
continue execution if IO was completed immediately (Nikita Sivukhin)
Lower Windows CI test timeout from 60 to 20 minutes (Pekka Enberg)
Multi index operator constraint (Pedro Muniz)
bench: gate nanosecond-level tests behind nanosecond-bench feature (Jussi Saurio)
use full link in JS SDK README so that links will be correct at npm (Nikita Sivukhin)
adjust is_constant check for IN and emit_no_constant_insn to avoid panic in VDBE cursor (Pedro Muniz)
concurrent-simulator: Explore in fast mode (Pekka Enberg)
Rewrite printf for full SQLite compatibility (Glauber Costa)
Pragmas (Glauber Costa)
testing/stress: Re-enable reopen and reconnect in stress tester (Pekka Enberg)
make Numeric the source of truth for number comparisons (Pedro Muniz)
Mvcc garbage collection (Jussi Saurio)
Remove unmaintained dart bindings (Avinash Sajjanshetty)
Convert antithesis from feature to cfg flag (Mikaël Francoeur)
core/storage: Remove unused FxHashSet import in btree.rs (Pekka Enberg)
core/mvcc: check integer primary key conflicts (Pere Diaz Bou)
use blocking IO for local databases for now (Nikita Sivukhin)
Make Github actions even more robust (Pekka Enberg)
bindings/wasm: Switch to notification-based I/O completion (Pekka Enberg)
Clippy more rules (Nikita Sivukhin)
properly handle url callback in react native bindings (Nikita Sivukhin)
Reduce antithesis stdout logging and log sql/tracing to files (Mikaël Francoeur)
Make Github workflows more robust (Pekka Enberg)
Change crate types in Dockerfile to restore Antithesis instrumentation (Mikaël Francoeur)
Whopper elle (Pedro Muniz)
allow url as function in react native bindings (Nikita Sivukhin)
JavaScript serverless driver improvements (Pekka Enberg)
MVCC: enable autocheckpoint at 1000 * 4120 bytes logical log size (Jussi Saurio)
Validate header (Nikita Sivukhin)
avoid unnecessary slow worker tasks in JS (Nikita Sivukhin)
do not cache chunks for .tantivy-meta.lock file (Nikita Sivukhin)
Destroy any custom index methods while dropping parent table (Preston Thorpe)
Stress progress bars (Pedro Muniz)
More snapshot tests (Pedro Muniz)
pin compiler and runner versions for codspeed benchmark (Pedro Muniz)
Move test runner to testing/runner (Pedro Muniz)
remove flaky test (Preston Thorpe)
Updates to COMPAT.MD (Jussi Saurio)
mark attach as experimental (Jussi Saurio)
run test with llvm-cov at linux (Nikita Sivukhin)
sim: generate unique constraints and verify statement rolls back correctly on failure (Pavan Nambi)
Bump urllib3 from 2.5.0 to 2.6.3 (app/dependabot)
Bump crossbeam-channel from 0.5.14 to 0.5.15 (app/dependabot)
JIT query generation in turso_stress (Mikaël Francoeur)
update determinism to match SQLite (Mikaël Francoeur)
core: database open is now async (Nikita Sivukhin)
bump claude code max turns (Pedro Muniz)
return NULL when there is no record in op_column (Pedro Muniz)
strftime should accept any kind of input not only text (Pedro Muniz)
React native example more tests (Nikita Sivukhin)
Document Rust sync API (Mikaël Francoeur)
Tpch snapshot testing (Pedro Muniz)
test runner: Snapshot testing (Pedro Muniz)
agressively black box benchmarks (Pedro Muniz)
Go driver time (Nikita Sivukhin)
CHAR should return \0 for NULL (Pedro Muniz)
core/mvcc: use dual_peek in exists (Pere Diaz Bou)
update npm for trusting publishing features (Nikita Sivukhin)
Separate Connection from a prepared statement to enable proper caching (Preston Thorpe)
substitute HashMap for FxHashMap in core (Pedro Muniz)
adjust agents.md to call tursodb cli correctly (Pedro Muniz)
remove NODE_AUTH_TOKEN (Nikita Sivukhin)
React native (Nikita Sivukhin)
sql_generation: reduce likelihood of index name collisions (Jussi Saurio)
retry on reader contention for TursoRwLock::read (Pedro Muniz)
differential fuzzer + general purpose sql generation (Pedro Muniz)
cleanup: centralize optimizer params and make them loadable from json (Jussi Saurio)
remove accesses_db flag (Nikita Sivukhin)
Migrate more tcl tests (Pedro Muniz)
testing/system: allow specifying rowcounts for gen-bigass-database.py (Jussi Saurio)
tests/fuzz/cte_fuzz: try to prevent pathological queries (Jussi Saurio)
improvements of the whopper (Nikita Sivukhin)
Some Insert performance improvements (Preston Thorpe)
Performance improvements for hash joins (Preston Thorpe)
WAL auto truncation: increase epoch to prevent stale pages reuse (Nikita Sivukhin)
core/mvcc: reparse schema after stream of schema changes (Pere Diaz Bou)
Reduce CLI release build time by ~60% (Jussi Saurio)
cleanup/vdbe: remove unused IndexKeyOwned and remove unused IndexKeyUnpacked::cursor_id (Jussi Saurio)
Refactor: remove encryption key field from Database struct (Avinash Sajjanshetty)
Migrate more TCL tests (Pedro Muniz)
convert agent docs to skills (Pedro Muniz)
Some optimizations for tpc-h queries (Pavan Nambi)
Refactor AggContext to use flat payload representation (Jussi Saurio)
more testing cleanups - move simulators (Pedro Muniz)
more testing cleanups (Pedro Muniz)
react-native: prepare (Nikita Sivukhin)
Move stress to testing/stress (Pedro Muniz)
Move tcl test to testing/system (Pedro Muniz)
ci/bench: increase timeout to 45mins as workaround (Jussi Saurio)
Remove fts/tantivy as default dependency in turso-core (Preston Thorpe)
Move antithesis test to testing/antithesis (Pedro Muniz)
feat/perf: use HashTable machinery for DISTINCT instead of ephemeral btree (Jussi Saurio)
ci: split simulator into separate jobs (Jussi Saurio)
CI: Reduce iterations in cte fuzzer (Preston Thorpe)
ci: longer timeout for cargo nextest on windows (Jussi Saurio)
fuzz/cte: reduce iterations (Jussi Saurio)
docs: split AGENTS.MD into separate agent-guides files (Jussi Saurio)
Js test runner (Jussi Saurio)
refactor/pager: small cleanups (Jussi Saurio)
sim: only run turso integrity check 10% of the time (Jussi Saurio)
Rewrite BETWEEN statements for partial indexes in DML paths (Preston Thorpe)
Create global directive for skipping mvcc in test runner (Preston Thorpe)
stress: run stress with shuttle (Pedro Muniz)
Validate Send + Sync for ProgramState + change registers to hold a Box<[Register]> (Pedro Muniz)
test-runner: rust backend (Pedro Muniz)
test-runner: start migrating TCL tests (Pedro Muniz)
Give Antithesis tests better names (Mikaël Francoeur)
core/vdbe: Allow leading + sign in numeric string parsing (Pere Diaz Bou)
core/vdbe: trim return text with integer and float (Pere Diaz Bou)
Reset ProgramState::once on statement reset (Mikaël Francoeur)
return blob if we concat blobs (Nikita Sivukhin)
Replace GPL-2.0 bloom crate with MIT-licensed fastbloom (Jussi Saurio)
Refactor core/lib.rs Connection impl out to its own file (Preston Thorpe)
Disallow WITHOUT ROWID tables (Jussi Saurio)
core: Use fast monotonic time when possible (Pekka Enberg)
core/vdbe: move mutable fields from Program to ProgramState (Pere Diaz Bou)
replace custom SmallVec with smallvec crate (Ankush)
Open autovacuum databases in readonly mode when experimental flag not set (app/copilot-swe-agent)
remove unused lints, variables and functions (Pedro Muniz)
separate Sync module (Pedro Muniz)
Btree: optimize defragment_page (Khashayar Fereidani)
avoid recursive read locks (Nikita Sivukhin)
Track WAL state in savepoints for proper rollback (Pavan Nambi)
vdbe: Resize deferred_seeks on program state reset (Pekka Enberg)
Reset checkpoint state when PRAGMA wal_checkpoint fails (Jussi Saurio)
Increase test_eval_param_only_once timeout threshold for CI reliability (app/copilot-swe-agent)
stress: switch to WAL mode before SQLite integrity check (Pekka Enberg)
planner: hash-join planning with safe build-side materialization (Preston Thorpe)
core/mvcc: rollback index rows (Pere Diaz Bou)
core/vdbe: check negative root pages with integrity_check (Pere Diaz Bou)
antithesis/stress: run in verbose mode (Jussi Saurio)
docs: change test build instructions (Mason Hall)
btree: get_prev_record and get_next_record automatically invalidate_record (Pedro Muniz)
bindings/dotnet: allow setting TursoParameter.Direction (Alex)
VDBE micro-optimizations for read path (Jussi Saurio)

Fixed

concurrent-simulator: Fix DDL inside BEGIN CONCURRENT transactions (Pekka Enberg)
core/json: Fix stale cursor crash in json_tree correlated subqueries (Pekka Enberg)
Avoid panic on unresolved qualified column in DO UPDATE (Kumar Ujjawal)
Fix unsound schema access when loading extensions (Preston Thorpe)
Fix unresolved IfNot label in scalar count(*) subqueries (Kumar Ujjawal)
core/translate: Fix non-literal defaults in Column instruction (Jussi Saurio)
core/mvcc: Fix header-only write durability (Jussi Saurio)
fix: IN(subquery) data corruption in ungrouped aggregates with NOT NULL columns (Vimal Prakash)
temporarily remove big sqltest to fix all the CI errors (Preston Thorpe)
Fix regression improperly consuming hash join WHERE terms (Preston Thorpe)
fix: UPDATE OR REPLACE does not fire FK CASCADE on implicitly-deleted row (Pedro Muniz)
Fix wal truncate on shutdown even after restart (Kumar Ujjawal)
fix: UPDATE RETURNING correlated subquery uses pre-UPDATE values (Pedro Muniz)
Make MVCC Elle check errors fail CI build (Pekka Enberg)
Overflow fix (Nikita Sivukhin)
fix: Window function with GROUP BY and ORDER BY causes optimizer assertion failure #5552 (Pedro Muniz)
Fix sync replay generator (Nikita Sivukhin)
fix: always reset pager state for attached databases (Pedro Muniz)
Fix three FULL OUTER JOIN bugs (Jussi Saurio)
fix snapshot isolation in MVCC (Preston Thorpe)
fix: clean up db-log and fix WAL extension for attached DBs in simulator (Glauber Costa)
fix: Expression index with correlated EXISTS subquery causes panic #5551 (Pedro Muniz)
Fix --experimental-strict incorrectly enabling custom types (Glauber Costa)
autofix: Aggregate COLLATE leaks to subsequent aggregates in same query (Jussi Saurio)
fix/mvcc: prevent persistent "Database is busy" after failed IO during checkpoint (Jussi Saurio)
autofix: CTE with UNION ALL corrupts first-column literals when any branch has aggregates (Jussi Saurio)
autofix: Triggers during FK CASCADE see pre-delete state of parent table (Jussi Saurio)
autofix: Correlated subquery with explicit JOIN returns wrong results after first row (Jussi Saurio)
autofix: LEFT JOIN incorrectly converted to INNER JOIN when WHERE uses CASE/IIF (Jussi Saurio)
autofix: Row value IN expression crashes with register allocation error (Jussi Saurio)
fix: BEFORE UPDATE trigger corrupts outer cursor position for correlated subqueries (Jussi Saurio)
autofix: DELETE with LIMIT ignores OFFSET clause (Preston Thorpe)
fix: UPSERT ON CONFLICT fails to match expression indexes #5550 (Preston Thorpe)
fix/optimizer: enable multi-index OR scans more widely and fix bad CTE query plans (Jussi Saurio)
Fix REAL affinity to preserve non-numeric text (Kumar Ujjawal)
Fix rowid resolution for views/WITHOUT ROWID (Kumar Ujjawal)
fix: Use pure-rust for macos for aegis to prevent macos compilation issues (Amodh Dhakal)
fix RETURNING, Statement::reset() and Program::abort() (Jussi Saurio)
Fix DEFAULT affinity handling (Jussi Saurio)
Improve I/O error message (Pekka Enberg)
fix: Handle IVM old record capture when REQUIRE_SEEK is set (Martin Mauch)
fix: MVCC cursor ignored left join null flag (Jussi Saurio)
fix: adjust jump_if_null branch offset as incorrectly failed NULL in check constraints in integrity checks (Pedro Muniz)
fix: emit RealAffinity when reading subquery columns from ephemeral indexes (Jussi Saurio)
fix: default generate_series STOP to SQLite Default (4294967295) when omitted (Damian Melia)
fix: mvcc: DDL statement inside BEGIN CONCURRENT returns a confusing error #3380 (Pedro Muniz)
fix: do not do unchecked indexing to non-static page offsets #4736 (Pedro Muniz)
fix: use consistent M_PI constant in degrees/radians for test parity with SQLite (Pedro Muniz)
fix: Register DBSP state index in schema for integrity_check (Martin Mauch)
fix: Panic on correlated subquery in IN clause referencing outer table alias #5213 (Pedro Muniz)
fix(wal): release WAL read lock on rollback to prevent checkpoint busy (Ahmad Alhour)
sqlite3: Fix segfault in sqlite3_free_table() (Pekka Enberg)
fix: OR in Partial Index WHERE Clause Causes Unresolved Label Panic (Jussi Saurio)
fix: No-op UPDATE causes datatype mismatch #5410 (Jussi Saurio)
fix: Expression Index Key Computed From Pre-Affinity Value During UPDATE (Jussi Saurio)
fix: ALTER TABLE RENAME COLUMN Does Not Update Partial Index WHERE Clauses (Jussi Saurio)
fix: Create materialized view in same transaction as source (Martin Mauch)
fix: "Cursor not found" when delete has a correlated subquery #5434 (Jussi Saurio)
fix: INSERT INTO With CTE + Compound SELECT Produces Garbled Data #5425 (Jussi Saurio)
fix: DELETE with correlated subquery sees in-flight deletions #5426 (Jussi Saurio)
fix: Panic When CTE Is Used in UPDATE SET Clause on Keyed Table (Jussi Saurio)
Fix FTS LIMIT 0/-1 handling to avoid Tantivy overflow (Kumar Ujjawal)
fix/correctness: use ephemeral table for UPDATE when expression index refers to updated columns (Mikaël Francoeur)
fix: update changes() and total_changes() inside explicit transactions (Damian Melia)
Fix: Fully enable foreign keys for MVCC (Preston Thorpe)
fix(cli): prevent extra space in multiline readline input (Karthik Koralla)
Fix materialized view re-entrancy bug (Martin Mauch)
fix affinity handling in check constraint evaluation (Jussi Saurio)
fix affinity calculation for index seeks, subqueries and ctes (Jussi Saurio)
fix: COLLATE Specification Lost in Concatenation with CHECK #5171 (Jussi Saurio)
fix: INSERT OR IGNORE + CHECK Failure Does Not Update sqlite_sequence (Jussi Saurio)
fix: Subquery in Trigger Body UPDATE SET Creates Poison Trigger (Jussi Saurio)
fix: WHERE clause returns wrong result for INT64_MAX compared against overflowed float (Jussi Saurio)
Fix prepare panic on comment/whitespace-only SQL (Kumar Ujjawal)
fix: Panic on Scalar Subquery Referencing CTE by Original Name After Alias (Jussi Saurio)
Fix SUM() type for BLOB inputs to return REAL (Kumar Ujjawal)
Unify error codes in LibsqlError for serverless package (Pekka Enberg)
Fix panic with duplicate expressions in window PARTITION BY (Mikaël Francoeur)
Fix panic and wrong results for window function in EXISTS subquery (Mikaël Francoeur)
fix: handle NULL properly in composite index seek/termination (Jussi Saurio)
fix: panic in PRAGMA integrity_check with expression indexes #5117 (Sanjeev)
fix: avoid cursor panic in SUM(TRUE IS TRUE) (Jussi Saurio)
Fix CLI exit code on query failure (Ahmad Alhour)
Fix MVCC trigger recovery rootpage handling (Jussi Saurio)
Fix collation with reordered hash joins (Preston Thorpe)
fix/btree: return error instead of panic if parent is unexpectedly a leaf (Jussi Saurio)
Fix panic on duplicate ORDER BY expressions with GROUP BY (Jussi Saurio)
fix: Align REAL→INTEGER cast with SQLite clamp semantics (Kumar Ujjawal)
fix: INSERT with auto-assigned rowid skips explicit index on IPK column (Jussi Saurio)
Fix affinity conversion of nan/inf text in numeric columns (Kumar Ujjawal)
fix: Correlated Subquery + Window Function in WHERE Hoisted Before Scan Loop (Jussi Saurio)
fix: more recursive read locks detected by shuttle with mvcc (Pedro Muniz)
fix/mvcc: dropped_root_pages tracking must survive restart (Jussi Saurio)
core/mvcc: Fix MVCC checkpoint panic when deleting index keys in inte… (Pekka Enberg)
fix: backward table scan skips rows on deep B-trees (ORDER BY DESC) (Pedro Muniz)
Phantom row fix (Pedro Muniz)
Insert or fix (Pedro Muniz)
fix: Panic on SELECT with 32767+ Columns (No SQLITE_MAX_COLUMN Limit) (Jussi Saurio)
fix: GROUP BY With Constant Expression Causes Infinite Loop #5300 (Jussi Saurio)
fix: propagate affinity for IN Subquery (Pedro Muniz)
fix(optimizer): fix correctness bugs in LEFT->INNER join optimization (Jussi Saurio)
fix/mvcc: fix test_logical_log_header_reserved_bytes_rejected test (Jussi Saurio)
Fix livelock in MVCC commit when pager_commit_lock is contended (Jussi Saurio)
Fix: handle multiplication overflow in time_date (Zohaib)
Fix panic on ROLLBACK TO by replacing assert! with bail_parse_error (codingbot24-s)
fix: Panic on CREATE TABLE with UNIQUE ... ON CONFLICT IGNORE #5221 (Jussi Saurio)
mvcc: define crash recovery / correctness semantics, rewrite logical log (Jussi Saurio)
Fix UPDATE incorrectly changing last_insert_rowid() (Kumar Ujjawal)
Fix panic in sum() with large floating-point values (Jussi Saurio)
fix(core): Handle PRAGMA cache_size overflow (fixes #5250) (ratnesh mishra)
fix: allow CTEs to shadow schema objects (Jussi Saurio)
fix: Panic on INSERT INTO t(nonexistent) SELECT ... FROM t #5226 (Jussi Saurio)
fix: Panic on Unresolved Table Reference in UPSERT DO UPDATE SET #5281 (Jussi Saurio)
core/storage: Fix pager commit completion (Pekka Enberg)
Fix throughput plot colors and hatching to match TPC-H plot (Pekka Enberg)
fix: Panic on 3+ Way MULTI-INDEX AND Query (RowSet State Violation) #… (Jussi Saurio)
fix: u16 Overflow in page_free_array Panics on 65536-Byte Pages #5276 (Jussi Saurio)
fix: handle PRAGMA database_list with argument without panicking (creativcoder)
fix: INSERT ... RETURNING panics with multi-column scalar subquery #5243 (Jussi Saurio)
fix: Panic When IN Subquery Used in LIMIT Expression #5247 (Jussi Saurio)
fix: ALTER TABLE RENAME COLUMN Fails on Case Mismatch #5246 (Jussi Saurio)
fix: read non-aggregate columns during AggStep for mixed expressions (Glauber Costa)
fix: null coroutine registers in ungrouped aggregate empty-result path (Glauber Costa)
fix: json_valid() With Zero Arguments Panics Instead of Returning Error (Jussi Saurio)
fix: LIMIT With i64::MIN Panics Due to Subtract Overflow in DecrJumpZ… (Jussi Saurio)
Fix missing dot in NOT NULL constraint error (Eren Türkoğlu)
fix: Materialized View Panics on Arithmetic With Text Column Values #… (Jussi Saurio)
fix: Panic on Scalar Subquery Referencing Rowid of Derived Table #5249 (Jussi Saurio)
Fix MVCC savepoint rollback leaving stale write set entries (Pekka Enberg)
fix: varint_len returned 10 for values with 58-64 significant bits (Jussi Saurio)
fix: do not apply numeric affinity of converted float is a NaN (Pedro Muniz)
try to fix js ci (Nikita Sivukhin)
fix: QUOTE should emit float in scientific notation (Pedro Muniz)
fix: GROUP BY sort order for extra columns (Pedro Muniz)
fix(core): fix ColumnUsedMask::is_only for overflow indices beyond vector length (Pedro Muniz)
Clear bloomfilters on rewind + hash table fix (Preston Thorpe)
fix: correctly jump to second OR expression if first expression is NULL (Pedro Muniz)
bindings/go: Fix spurious test failures from port conflicts (Pekka Enberg)
Fix changes() value for DELETE (Preston Thorpe)
core/mvcc: Fix transaction end version visibility check (Pere Diaz Bou)
Rn locking fix (Nikita Sivukhin)
fix prevent AUTOINCREMENT on non-INTEGER PKs with mixed-case names (김선우)
fix: cannot use index seek if the constraining expression references the same table being scanned (Pedro Muniz)
fix: evaluate result rows on exists subquery with DISTINCT clause (Pedro Muniz)
Fix multiple index corruption bugs involving INSERT OR <conflict_resolution_mode> (Jussi Saurio)
scripts/release-status.py: Classify issues as bugs by default (Pekka Enberg)
Fix broken build (Pavan Nambi)
Fix segfault in uuid_str/uuid_ts with no arguments (Preston Thorpe)
fix build (Mikaël Francoeur)
Strict fixes (Glauber Costa)
fix: prevent overflow panic in JsonArrayLength with malformed JSONB (Jussi Saurio)
Fix LEFT JOIN with virtual tables producing wrong results (Glauber Costa)
Fix user-defined columns named oid/rowid/rowid resolving to internal rowid (Glauber Costa)
Rn fixes 2 (Nikita Sivukhin)
fix: emit offset after Distinct deduplication (Pedro Muniz)
fix: increase tolerance in vector L2 distance test to match simsimd vs rust precision (Pedro Muniz)
fix/encryption: do not panic if accessing db with missing or incorrect keys (Avinash Sajjanshetty)
fix: overflow handling in cast_real_to_integer (Pedro Muniz)
fix: convert text and blobs into bytes for correct parsing of strings into numbers (Pedro Muniz)
fix: handle_text_sum treat certain text values as approximate (Pedro Muniz)
Fix ruff check errors (Avinash Sajjanshetty)
Fix panic when CTE with indexed subquery is referenced twice (Mikaël Francoeur)
Fix STRICT tables incorrectly rejecting NULL values (Glauber Costa)
fix: allow qualified column references in partial index WHERE clause functions (Jussi Saurio)
Fix deadlock in MVCC mode when loading extensions on file databases (Jussi Saurio)
fix: WHERE clause treats string literals with numeric prefixes correctly (Jussi Saurio)
fix(update): apply affinity before MakeRecord to prevent index corruption (Pedro Muniz)
fix: JSON path UTF-8 char boundary panic (Jussi Saurio)
MVCC: fix checkpoint consistency and durability bugs (Jussi Saurio)
Fix CLI ".open" command to preserve experimental flags (Jussi Saurio)
fix/pager: properly reuse last empty trunk page for page allocation (Jussi Saurio)
Fix Antithesis CI config (Mikaël Francoeur)
Fix missing STRICT keyword in BTreeTable::to_sql() (Glauber Costa)
fix/connection: release wal locks on connection drop to prevent DB from being permalocked (Jussi Saurio)
Fix JavaScript driver error message to match libSQL (Pekka Enberg)
MVCC fixes found using whopper (Jussi Saurio)
Fix bug when empty namespace is provided in go sync driver (Preston Thorpe)
Fix passing namespace in to config in Go sync driver (Preston Thorpe)
fix: -0.0 and 0.0 should have the same hash (Pedro Muniz)
core/mvcc: fix btree row verification (Pere Diaz Bou)
fix: group concat did not convert values to text on output (Pedro Muniz)
Fix datetime modifier UTF-8 slicing panic (Mikaël Francoeur)
fix is_nonnull check for primary key columns (Pedro Muniz)
page cache: fix aggressive spilling logic (Preston Thorpe)
Fix bug in hash join table mask calculations (Jussi Saurio)
Fix broken encryption SDK tests (Avinash Sajjanshetty)
Fix correlated subquery issues (Jussi Saurio)
fix: avoid exponential CTE re-planning during query compilation (Jussi Saurio)
ivm: Fix comparison of Integer <-> Float (Martin Mauch)
Fix cross-link in Claude skills (Ofek Lev)
mvcc: fix for schema conflict on COMMIT (Nikita Sivukhin)
Fix bugs in hash-join materialization subplans (Jussi Saurio)
fix: prevent integer overflow panic in JSONB serialization (Jussi Saurio)
sqlancer dockerfile fix (Jussi Saurio)
fix: infer subquery result list column types (Jussi Saurio)
fix/vdbe: fix QUOTE() - should convert ints&floats to text (Jussi Saurio)
fix/optimizer: fix output cardinality estimation for index seeks (Jussi Saurio)
fix: truncate ORDER BY after rowid when rowid is first (Jussi Saurio)
fix: PRINTF converts non-text format argument to string (Jussi Saurio)
fix: substr returns NULL when provided NULL length (Jussi Saurio)
fix docker builds (Pedro Muniz)
fix: handle EXISTS in expr_vector_size instead of panicing with todo!() (Jussi Saurio)
fix: move subqueries to ephemeral plan when WHERE clause is moved (Jussi Saurio)
fix: eagerly remove ORDER BY if single aggregate, no groups/windows (Jussi Saurio)
fix: IN/NOT IN subqueries return NULL when value not found and subquery contains NULLs (Jussi Saurio)
fix/optimizer/stats: fix incorrectly named distinct_per_prefix field (Jussi Saurio)
fix antithesis dockerfile: download libvoidstar.so in Dockerfile instead of COPY (Jussi Saurio)
Optimizer: fix bugs, improve cost model (Jussi Saurio)
Fix wal checkpoint (Nikita Sivukhin)
Busy snapshot bugfix (Nikita Sivukhin)
fix/translate: revert change that allowed index cursor with stale position to be read (Jussi Saurio)
try_for_float: use Dekker algorithm to avoid precision error (Jussi Saurio)
fix: type affinity comparison for TEXT columns with numeric literals (#4745) (Srinivas A)
fix sync-wasm package to properly handle case when no url is provided (Nikita Sivukhin)
Fix JSON panics and incompatibility issues (Jussi Saurio)
Fix misuse of encryption key in the database manager cache (Avinash Sajjanshetty)
Run cargo clippy --fix --all in turso-test-runner (Preston Thorpe)
Fix ON CONFLICT resolution propagation to trigger statements (Preston Thorpe)
Fix sqlancer-runner image name in GH action build (Preston Thorpe)
Fix misleading turso-test-runner comments regarding mvcc&readonly (Jussi Saurio)
turso-test-runner: fix flakiness with Rust bindings + MVCC combo (Jussi Saurio)
Fix datetime parse_modifier() panicing on multibyte utf-8 (Jussi Saurio)
Ci fixes (Jussi Saurio)
Scalarfunc fuzzer + fixes (Jussi Saurio)
bugfix: fix corruption by setting reserved_bytes if requested (Avinash Sajjanshetty)
fix(vdbe): CHAR() function should handle full Unicode range (Mikaël Francoeur)
do not call unlock_after_restart in case of error during wal truncation - because we already released these locks earlier (Nikita Sivukhin)
WAL: ignore error from auto-checkpoint and fix bug (Nikita Sivukhin)
fix: dont create nested aggregates in cte_fuzz (Jussi Saurio)
properly unlock WriteLock if restart failed and ignore Busy errors when attempt to restart WAL file failed (Nikita Sivukhin)
fix(parser): reject duplicate PRIMARY KEY clauses on a single column (Mikaël Francoeur)
Cte fixes (Jussi Saurio)
fix/connect: read page1 in transaction to prevent illegal WAL read (Jussi Saurio)
fix: dont panic if decryption or checksum verification fails (Jussi Saurio)
fix: fsync DB file before truncating WAL after checkpoint (Jussi Saurio)
Return error instead of panicing when 1. short read occurs 2. page type is invalid (Jussi Saurio)
Checkpoint restart fix (Nikita Sivukhin)
fix: nullif/instr/concat should alloc regs for both args upfront (Jussi Saurio)
core/vdbe/sorter: Propagate write errors instead of corrupting data (Preston Thorpe)
fix(parser): BETWEEN and LIKE operator precedence with IS NOT NULL (Jussi Saurio)
fix: allow CTEs to be referenced multiple times (Jussi Saurio)
fix(parser): reject ?0 parameter with proper error instead of panicking (Jussi Saurio)
more recursive read lock fixes (Pedro Muniz)
fix: allow float literals in ORDER BY clause (Jussi Saurio)
fix: correct operator precedence in replace() argument check (Jussi Saurio)
fix: reject literal-only index expressions and fix JNI panic (Jussi Saurio)
fix: handle CAST without type name for SQLite compatibility (Jussi Saurio)
fix/vdbe: convert BusySnapshot to Busy if conn rolled back (Jussi Saurio)
sdk-kit: Export busy snapshot error to callers (Pekka Enberg)
fix: return NULL instead of panicking in uuid7_timestamp_ms for invalid blobs (Jussi Saurio)
fix: handle parse errors gracefully in LIMIT clause (Jussi Saurio)
fix: prevent panic on multi-byte UTF-8 in datetime functions (Jussi Saurio)
fix: INSERT INTO ... SELECT ... UNION ... inserts all rows (Jussi Saurio)
Fix DEFAULT value handling in integrity check (Jussi Saurio)
Fix stale overflow page read bug and improper re-entrancy handling in integrity_check (Jussi Saurio)
Fix integrity_check NOT NULL validation false positive (Jussi Saurio)
Fix compilation after cross-pollution with unused vars PR and integrity check PR (Jussi Saurio)
fix: use checked_cast_text_to_numeric for Numeric cast in exec_cast (Pedro Muniz)
fix: resolve label in ungrouped aggregation with SELECT DISTINCT (Jussi Saurio)
fix/checkpoint: always read page1 from db file when truncating (Jussi Saurio)
whopper: Handle BusySnapshot error gracefully (Pekka Enberg)
Fix WAL truncate checkpoint discarding uncheckpointed frames (Jussi Saurio)
btree.rs: make #[instrument] conditional on debug_assertions (Jussi Saurio)
Fix path not fsyncing the DB file after truncate checkpoint (Preston Thorpe)
core: make datetime functions faster and fix bugs (Jussi Saurio)
Valueiterator with fixes (Jussi Saurio)
stress: handle I/O error gracefully instead of panicking (Pekka Enberg)
stress: dont panic if get BusySnapshot error (Jussi Saurio)
bindings/rust: return error on out of bounds Row::get access (Jussi Saurio)
vector: increase fuzz error tolerance on windows (Jussi Saurio)
sim: fix yet another apply_snapshot() edge case (Jussi Saurio)

0.4.0 -- 2026-01-05

Added

stress: Add support for BEGIN CONCURRENT transactions (Pekka Enberg)
stress: add semi colon to transaction statements when printing to log file (Pedro Muniz)
Add scripts/corruption-debug-tools (Jussi Saurio)
add more asserts in balance operation (Pedro Muniz)
bindings/java: implement JDBC4 CharacterStream binding methods (Orange banana)
add --db-ref optional arg to run turso-stress against "template" database (Nikita Sivukhin)
support format() function (Fahd Ashour)
feat(extensions): add stddev aggregate function to percentile module (Kelvin)
simulator: add proper handling for deffered transactions in shadow state (Pedro Muniz)
feat: Add support for HAVING without GROUP BY (Nuno Gonçalves)
Implement foreign key actions (Preston Thorpe)
implement pragma cache spill (Preston Thorpe)
Add multiverse debugging instructions (Mikaël Francoeur)
Implement busy handlers/callbacks (Preston Thorpe)
add readonly checks to ensure we do not change the header (Pedro Muniz)
implement state machine for op_journal_mode (Pedro Muniz)
Add io_uring option for IO backend to simulator (Preston Thorpe)
core/storage: implement Cache Spilling (Preston Thorpe)
Add dotnet bindings to Turso (Kopylov Dmitriy)
fix bug in the sync engine wasm implementation (Nikita Sivukhin)
feat(hash-join): add hash matching for equivalent integer and real values (Nuno Gonçalves)
implement state machine for parsing input in CLI (Pedro Muniz)
add rust-analyzer component to toolchain (Pedro Muniz)
Add script to run SQLancer against turso + fix some bugs found by doing so (Jussi Saurio)
Add greedy join ordering for large queries (>12 tables) (Jussi Saurio)
core/mvcc/cursor: add missing reset state in next (Pere Diaz Bou)
Add PR template (Preston Thorpe)
fix: JSON_INSERT now correctly inserts new keys in nested objects (Mikaël Francoeur)
Remove unused parameter in limbo_exec_rows and add ergonomic ExecRows trait for testing (Pedro Muniz)
translate/optimizer: Finish implementing ANALYZE (Preston Thorpe)
core/mvcc/cursor: implement count (Pere Diaz Bou)
support libsql:// protocol as a sync url in python driver (Nikita Sivukhin)
initialize global header on bootstrap (Pedro Muniz)
Rust binding add prepare to transaction (Dave Warnock)
add turso bot config (Pedro Muniz)
feat: adding check for unquoted literals in values() (Rohith Suresh)
Improved Python driver with opt-in asyncio support (Nikita Sivukhin)
tcl,makefile: add tcl test infraestructure for mvcc (Pere Diaz Bou)
core/mvcc: fix bounds check new rowid (Pere Diaz Bou)
Added dot product vector distance (Tejas)
sim: add binary tool that converts plan.sql to rust test file (Jussi Saurio)
Add explanation for concurrent transactions (Pekka Enberg)
testing/fuzz: Add new fuzzer for joins (Preston Thorpe)
add lib-release profile (Nikita Sivukhin)
planner/vdbe: implement Hash Joins as an alternative to Ephemeral Indexes (Preston Thorpe)
Add sync support to the SDK kit (Nikita Sivukhin)
fix/mvcc: always reinitialize index iterator on seek (Jussi Saurio)
translate/vdbe: add bloom filter (Preston Thorpe)
mvcc: implement logical log recovery for indexes + checkpointing of indexes (Jussi Saurio)
Docs: add table of contents to CONTRIBUTING.md (Fahd Ashour)
finish implementing "quote" scalar function for blob types (Preston Thorpe)
add alias to colnames explicitly as column-N (Pavan Nambi)
Add #[turso_macros::test] to automatically create tests that can run MVCC with minimal code changes (Pedro Muniz)
mvcc: introduce stateful "dual cursor" (Jussi Saurio)
introduce program execution state in order to run stmt to completion in case of finalize or reset (Nikita Sivukhin)
mvcc: add some plumbing for index support (Jussi Saurio)
core/mvcc/tests: add fuzz test for mvcc with checkpoint and with CRUD ops (Pere Diaz Bou)
translate/planner: Implement Index creation on arbitrary expressions (Preston Thorpe)
Support table xinfo (Nikita Sivukhin)
core/mvcc/cursor: implement prev and last (Pere Diaz Bou)
Trigger support (Jussi Saurio)
translate/insert: Implement INSERT OR REPLACE (Preston Thorpe)
Add ColDef struct to make schema::Column creation more ergonomic (Preston Thorpe)
Support DELETE ... RETURNING (Jussi Saurio)
Refactor RETURNING to support arbitrary expressions (Jussi Saurio)
bindings/java: implement JDBC4 InputStream binding methods (ASCII/Binary, no-length and long overloads) (Orange banana)
Add RowSet<Add/Read/Test> instructions and rowset implementation (Jussi Saurio)
bindings/java: implement stream binding methods (int, InputStream, int) in JDBC4PreparedStatement (Orange banana)
workflows: Add GITHUB_TOKEN to all Nyrkiö steps (Henrik Ingo)
extensions/vtabs: implement remaining opcodes (Preston Thorpe)
Throw an error when adding generated columns via an alter table (Rohith Suresh)
add some docs for index method (Nikita Sivukhin)
bindings/java: Implement setObject(int, Object) in JDBC4PreparedStatement (Orange banana)

Updated

Minor cleanups in function.rs and refactoring allocations (Preston Thorpe)
WAL: Stop copying page buffers during checkpoint (Preston Thorpe)
test runner: Test Converter (Pedro Muniz)
core/storage: Eliminate buffer copy in begin_write_btree_page() (Pekka Enberg)
Test runner Foundation (Pedro Muniz)
show failure output in the end with cargo nextest (Pedro Muniz)
core/storage: Zero remaining buffer bytes in begin_write_btree_page() (Pekka Enberg)
core/storage: Make PagerInner::buffer use Arc (Pekka Enberg)
Adjust merge script to truncate the PR template (Preston Thorpe)
Improvements to turso_stress (Mikaël Francoeur)
Page management cleanups (Pekka Enberg)
btree: reset AdvanceState after last state transition (Pedro Muniz)
Make BTree and MVCC cursor Send + Sync (Pedro Muniz)
Raise log level polling frequency (Mikaël Francoeur)
btree/pager: performance tuning (Preston Thorpe)
chore/btree: remove unused code (Jussi Saurio)
Modify bench-profile to allow generating better flamegraphs (Jussi Saurio)
all-mvcc: uncomment working tests (Pere Diaz Bou)
perf/sorter: sort pointers instead of records, use arena allocation (Jussi Saurio)
Remove TursoDBFactory (Mikaël Francoeur)
Save sync configuration (Nikita Sivukhin)
Optimized RecordCursor, Remove read_varint_fast (Khashayar Fereidani)
Run statements to completion on reset (Martin Mauch)
adjust tpc-h bench script to more easily compare results (Preston Thorpe)
stress: use multithreaded runtime (Jussi Saurio)
Conflict end txn (Nikita Sivukhin)
Accept SQL query using AsRef<str> instead of &str (Arto Bendiken)
core: remove mutex from ImmutableRecord::cursor (Jussi Saurio)
Enable tokio-unstable in Antithesis image (Mikaël Francoeur)
Prevent dropping columns that contain fk references (Preston Thorpe)
lint/perf: deny eager fallback function calls (ok_or, map_or, unwrap_or) (Jussi Saurio)
reset statement in query() (Mikaël Francoeur)
User rust-gdb instead of gdb (Mikaël Francoeur)
Antithesis observability improvements (Mikaël Francoeur)
Rust bindings sync (Nikita Sivukhin)
Refactor/improve performance of commit path (Preston Thorpe)
Sdk kit rust bindings (Nikita Sivukhin)
Yet another refactor of INSERT translation (Preston Thorpe)
stress: Make SQLite integrity check more explicit (Pekka Enberg)
Sdk kit refactoring (Nikita Sivukhin)
perf/vdbe: reuse&clear ephemeral cursor on repeat invocations (Jussi Saurio)
perf/prepare: various optimizations (Jussi Saurio)
Improve lexer performance by using SIMD (Khashayar Fereidani)
Remove unnecessary Cell and RefCell for better multithreaded safety (Pedro Muniz)
Partial sync experimental (Nikita Sivukhin)
remove unneeded Result in exec unixepoch (Juan V. García)
Lexer/Parser Optimization and refactoring (Khashayar Fereidani)
tcl: run PRAGMA journal_mode=experimental_mvcc with mvcc (Pere Diaz Bou)
SDK tweaks (Nikita Sivukhin)
core/mvcc: set_null_flag(false) when seek is called (Pere Diaz Bou)
Mark triggers as experimental (Jussi Saurio)
Set all testing dbs to WAL journal mode (Preston Thorpe)
Remove run once from Statement (Pedro Muniz)
Use u64::from instead of .into() (Elina)
remove the warning directive to allow environment filter to work (Pedro Muniz)
core/execute: use same code for generating rowid in mvcc as in btree (Pere Diaz Bou)
Improve MVCC DX by dropping --experimental-mvcc flag (Pekka Enberg)
aws/sim: disable io-uring (Jussi Saurio)
Local sync server (Nikita Sivukhin)
Simplify slot bitmap to remove complex unused optimizations (Preston Thorpe)
clean up core tester to use conn.execute and conn.exec_rows for parsing correctly the expected values from select queries (Pedro Muniz)
Connection small refactor (Dave Warnock)
Enable MVCC with PRAGMA journal_mode (Pedro Muniz)
propagate partial sync settings in the web (Nikita Sivukhin)
Consider Order by expressions collation when deciding candidate index for iteration (Pedro Muniz)
Checkpoint cleanup (Jussi Saurio)
use cmath from system libraries only in tests in order to be more portable (Nikita Sivukhin)
No tempfiles on wasm (Nikita Sivukhin)
core: Make Pager thread-safe (Pekka Enberg)
update go mod name as we will serve module through custom proxy (Nikita Sivukhin)
Install sqlite locally to run tests and other scripts (Pedro Muniz)
rename speculative load to prefetch (docs already uses this terminology) (Nikita Sivukhin)
docs: update clippy command in CONTRIBUTING.md to match CI job (Nuno Gonçalves)
stress: Make random seed configurable (Pekka Enberg)
Devcontainer setup (Nikita Sivukhin)
core/mvcc/cursor: return previous max id (Pere Diaz Bou)
Update wording of AI section of PR template (Jussi Saurio)
whopper: Simulate time (Pekka Enberg)
increase lantency check for flaky test in test_read_path.rs (Preston Thorpe)
run get(...) to completion - otherwise INSERT ... RETURNING will be executed incorrectly (Nikita Sivukhin)
ci: run TCL tests for MVCC under CI (Pere Diaz Bou)
Get mutable reference to table in Schema so we can modify it with Arc::make_mut (Pedro Muniz)
also check for None checkpointed_txid_max_old when determining if RowVersion exists in the Db (Pedro Muniz)
Go driver (Nikita Sivukhin)
Minor improvements and refactoring in btree.rs (Preston Thorpe)
revert change in index_scan_compound_key_fuzz (Pedro Muniz)
Make checkpointed_txid_max_old be an Optional<NonZeroU64> (Pedro Muniz)
Remove some useless clones in pager.rs (Preston Thorpe)
upgrade cargo dist to 0.30.2 (Nikita Sivukhin)
Partial sync improvements (Nikita Sivukhin)
Prevent concurrent tx ctrl and write (Nikita Sivukhin)
core/mvcc/cursor: ignore non visible rows on "last" (Pere Diaz Bou)
core/mvcc/tests: un-ignore seek tests (Pere Diaz Bou)
CI: simulator tweaks (Jussi Saurio)
chore: remove experimental_indexes feature flags (Jussi Saurio)
do not propagate the MvStore to opcodes (Pedro Muniz)
Run BEFORE and AFTER update triggers on upserts (Mikaël Francoeur)
Ignore SQLITE_BUSY during auto-checkpoint (Mikaël Francoeur)
Allocate Page 1 in pager on open (Pedro Muniz)
Prevent creating index on rowid pseudo-column (Mikaël Francoeur)
Improve Android compatibility (Martin Mauch)
Simulator Roadmap (Alperen Keleş)
guard subjournal access within single connection (Nikita Sivukhin)
Turso sdk kit version (Nikita Sivukhin)
Automatically Propagate Encryption options (Pedro Muniz)
core/mvcc: state machines for prev, next, exists, rewind, last (Pere Diaz Bou)
btree/balance: assert that if multiple overflow cells, they are adjacent sequential (Jussi Saurio)
simulator: generate more INSERT INTO ... SELECT self-inserts (Mikaël Francoeur)
Arc swap MvStore + centralize MvStore acquisition (Pedro Muniz)
mvcc: do not store index data twice in Row (Jussi Saurio)
Col name in trigger subquery (Rohith Suresh)
Update AEGIS crate version (Avinash Sajjanshetty)
SDK kit (Nikita Sivukhin)
Ensure LIKE is case-sensitive for non-ASCII characters (Tejas)
sim/aws: memory IO 100% of the time, differential 50% of the time (Jussi Saurio)
mvcc: reconstruct index rows on logical log recovery (Jussi Saurio)
More mvcc index stuff (Jussi Saurio)
mvcc: make more MvccLazyCursor ops compatible with indexes (Jussi Saurio)
drop triggers if table drops (Pavan Nambi)
Kill unwrap() calls in MVCC module (Pekka Enberg)
Kill unwrap() in vector module (Pekka Enberg)
Kill unwrap() calls in VDBE module (Pekka Enberg)
Tidied imports in Rust binding example without unwrap (Dave Warnock)
Rust binding example without unwrap (Dave Warnock)
Kill unwrap() calls in JSON module (Pekka Enberg)
use i64 for registers p1,p2,p3,p5 in EXPLAIN output (Mikaël Francoeur)
Kill unwrap() in macros (Pekka Enberg)
Kill unwrap in incremental module (Pekka Enberg)
mvcc: refactor RowID.row_id to be either i64 or a record (Jussi Saurio)
Kill unwrap() calls in extensions (Pekka Enberg)
SQLite C API improvements (Nikita Sivukhin)
simulator: only check all tables if we have any tables to check (Pedro Muniz)
core: Switch to parking_lot::Mutex (Pekka Enberg)
Simulator: refactor and simplify InteractionPlan (Pedro Muniz)
Enable nested self-inserts in simulator (Mikaël Francoeur)
correct order in column creation in join tests (Pavan Nambi)
Nyrkiö: Set all comment-on to false (Henrik Ingo)
Partial sync basic (Nikita Sivukhin)
Use AsValueRef in more functions (Pedro Muniz)
treat parameters as "constant" within a query (Nikita Sivukhin)
Completion: make it Send + Sync (Nikita Sivukhin)
core/mvcc: use btree cursor to navigate rows (Pere Diaz Bou)
core: update aegis (Daeho Ro)
Refactor affinity conversions for reusability (Pedro Muniz)
Create AsValueRef trait to allow us to be agnostic over ownership of Value or ValueRef (Pedro Muniz)
Move value functions to separate file (Pedro Muniz)
Avoid heavy macro (Nikita Sivukhin)
Stop blob json parsing at null terminator (Duy Dang)
core/translate: Remove unused ParamState (Preston Thorpe)
Toy index improvements (Nikita Sivukhin)
use dyn DatabaseStorage instead of DatabaseFile (Nikita Sivukhin)
Prevent DROP TABLE when table is referenced by foreign keys (Joao Faria)
core/vdbe Handle renaming child FK definitions in rename table stmt (Preston Thorpe)
Prevent misuse of subqueries that return multiple columns (Jussi Saurio)
Optimize and refactor schema::Column type (Preston Thorpe)
Clean up Connection::from_uri() by using DatabaseOpts (Rohith Suresh)
Select correct collation sequence for compound select (Pedro Muniz)
core: Disable autovacuum by default (Pekka Enberg)
Make mimalloc dependency optional (Pekka Enberg)
Update Java package version in scripts/update-version.py (Pekka Enberg)

Fixed

stress: Keep going on I/O errors instead of panicking (Pekka Enberg)
fix: lint warnings unused variable/import in release build (Khashayar Fereidani)
integrity check: do not throw errors if pending byte page is never used (Pedro Muniz)
fix(storage): improve error message for truncated database files (Srinivas A)
fix/pager&wal: ensure wal write lock held when rolling back frame_cache (Jussi Saurio)
Enable debug_assertions for antithesis profile (Pekka Enberg)
General improvements, micro-optimizations and bug fix for core/functions (Khashayar Fereidani)
fix dockerfiles (Jussi Saurio)
Fix DROP TABLE to properly handle FK actions and allow for orphaned/NULL FK refs (Preston Thorpe)
core/mvcc/logical_log: off by one error reading logical log encrypted (Pere Diaz Bou)
Fix squeue overflow issue in io_uring (Preston Thorpe)
Affinity fixes (Pedro Muniz)
Read only fixes (Pedro Muniz)
slightly adjust fixed unstable test (Nikita Sivukhin)
CI test setup fixes + fix GroupCompletion bug (Pedro Muniz)
pyturso: fix panic (Nikita Sivukhin)
fix(core/translate): apply affinity conversion to hash join build and probe keys (Nuno Gonçalves)
fix/core: fix transaction issues (Jussi Saurio)
sim: fix apply_snapshot for create table, create index, drop column (Jussi Saurio)
fix stack overflow in long unary expressions ("' from Jussi Saurio)
Fix RTRIM ignoring trailing tabs (Krishna Vishal)
Fix incorrect conversion from TEXT to INTEGER when text is a number followed by a trailing non-breaking space (Krishna Vishal)
fix stack overflow in long unary expressions (")
Sync fixes (Nikita Sivukhin)
fix(core): prevent ALTER COLUMN from resulting in tables with only generated columns (Nuno Gonçalves)
core/storage: fixes for the commit path and io_uring (Preston Thorpe)
aws/sim: fixes and tweaks (Jussi Saurio)
fix succeeded check (Pedro Muniz)
fix/sim: all alter table ops must be recorded and applied in order (Jussi Saurio)
fix coroutine panic: replace ended_coroutine Bitfield with vec (Jussi Saurio)
Fix: update schema if DDL commit succeeded but checkpoint failed (Jussi Saurio)
Fix race condition in WAL frame_cache update with io_uring (Mikaël Francoeur)
fix(json): properly serialize infinite values (Nuno Gonçalves)
fix(core/util): reject integer primary key underflow (Nuno Gonçalves)
fix/core: decouple autocheckpoint result from transaction durability (Jussi Saurio)
Fix StreamingWalReader behavior with checksums of uncommitted frames (Preston Thorpe)
Fix ignored completion in free_page (Preston Thorpe)
Fix more instances of marking pages dirty after modification (Jussi Saurio)
fix/pager: mark freelist trunk page dirty BEFORE modifying it (Jussi Saurio)
fix/sim: modify rows in ALTER TABLE properly (Jussi Saurio)
core: Fix integrity_check pragma code generation (Pekka Enberg)
antithesis: Fix unique constraint exception handling in stress-composer tests (Pekka Enberg)
Fix Github go workflow (Nikita Sivukhin)
sim: fix bug in apply_snapshot (Jussi Saurio)
Sync better error messages (Nikita Sivukhin)
Fix CTE scope propagation for compound SELECTs (Martin Mauch)
Sqlite3 compat fix (Nikita Sivukhin)
Sim transaction fixes (Jussi Saurio)
sim/aws: comment on existing issues instead of skipping duplicates (Jussi Saurio)
Fix complex unique sqlite3 compat (Nikita Sivukhin)
fix/btree: disable move_to_rightmost optimization with triggers (Jussi Saurio)
Fix descending index scan returning rows when seek key is NULL (Jussi Saurio)
Fix external sorter losing rows when chunks need async IO (Jussi Saurio)
sim: stop ignoring sql execution errors (Jussi Saurio)
Fix two bugs with compound selects (Jussi Saurio)
Fix IN operator translation logic (Nikita Sivukhin)
fix/mvcc: seek() must seek from both mv store and btree (Jussi Saurio)
Fix panic in optimizer when usable constraint refs is empty (Preston Thorpe)
optimizer: fix incorrect index_col_pos assigned when multiple constraints ref same join key (Preston Thorpe)
Bloom filter fixes (Preston Thorpe)
fix: escape backslashes in json_object string values (Martin Mauch)
fix/mvcc: use existing schema object in mvcc bootstrap (Jussi Saurio)
Mvcc bugfixes (Jussi Saurio)
Fix vtab memory leak (Nikita Sivukhin)
Fix comparison of large numbers (Mikaël Francoeur)
Fix to Google Books link in CONTRIBUTING (Juan V. García)
core/mvcc: fix exists to use BTreeCursor as fallback (Pere Diaz Bou)
core/io: Improve error handling (Pekka Enberg)
core/index_method: Improve error handling in toy_vector_spare_ivf.rs (Pekka Enberg)
Triggers: fix issues with ALTER TABLE (Jussi Saurio)
Return parse error if NULLS LAST used in ORDER BY (Jussi Saurio)
Fix: Drop internal DBSP table when dropping materialized view (Martin Mauch)
Fix seek not applying correct affinity to seek expr (Pedro Muniz)
Fix EXISTS on LEFT JOIN null rows (Duy Dang)
Fix error handling on provided insert column count mismatch (Jussi Saurio)
core/vdbe: Fix incorrect unreachable condition in op_seek_rowid (Preston Thorpe)
Update and fix nix build (Alexander Hirner)
Fix INSERT UNION ALL (Duy Dang)
Fix LEFT JOIN subqueries reusing stale right-side values (Duy Dang)
Throw an error in case duplicate CTE names are found (Rohith Suresh)
Fix self-insert SUM when table uses INTEGER PRIMARY KEY (Duy Dang)

Changelog

0.3.0 -- 2025-10-30

Added

Implement wasNull tracking in ResultSet getter methods (김민석)
Support subqueries in all positions of a SELECT statement (Jussi Saurio)
Initialize LIMIT after after ORDER BY / GROUP BY initialization (Jussi Saurio)
index_method: implement basic trait and simple toy index (Nikita Sivukhin)
Where clause subquery support (Jussi Saurio)
sqlite3: Add multi-statement support for sqlite3_exec() (Preston Thorpe)
Add DISTINCT support to aggregate operator (Glauber Costa)
docs: Add vector search section to database manual (Pekka Enberg)
Support statement-level rollback via anonymous savepoints (Jussi Saurio)
Add AtomicEnum proc macro to generate atomic wrappers to replace RwLocks (Preston Thorpe)
Fix git directory resolution in simulator to support worktrees (Jussi Saurio)
Add Miri support for turso_stress, with bash scripts to run (Bob Peterson)
tests: Add rowid alias fuzz test case (Pekka Enberg)
core/translate: throw parse error on unsupported GENERATED column constraints (Preston Thorpe)
translate/insert: more refactoring and support INSERT OR IGNORE (Preston Thorpe)
sql_generation: Fix implementation of LTValue and GTValue for Text types (Jussi Saurio)
core/mvcc: implement CursorTrait on MVCC cursor (Pere Diaz Bou)
Add test case for vector() format crash (Pedro Muniz)
Add correct unique constraint test for tcl (Pedro Muniz)
stress: Add busy timeout support with 5 second default (Pekka Enberg)
Add WINDOW functions to COMPAT.md (Jussi Saurio)
core/translate: Add if alias and allow iff to have more arguments (Pavan Nambi)
core/btree: try to introduce trait for cursors (Pere Diaz Bou)
bindings/java: Add support for publishing to Maven Central (Kim Seon Woo)
add Calendar-based timezone conversion support in JDBC4ResultSet (김민석)
Add Nightly versions of benchmarks that run on Nyrkiö runners (Henrik Ingo)
Add support for sqlite_version() star syntax (Glauber Costa)
core/translate: implement basic foreign key constraint support (Preston Thorpe)
Simulator: Add Drop and pave the way for Schema changes (Pedro Muniz)
core/io: remove new_dummy in place of new_yield (Pere Diaz Bou)
Add MVCC checkpoint threshold pragma (bit-aloo)
core/incremental: Implement "is null" and "is not null" tests for view filter (Glauber Costa)
core/mvcc: implement PartialOrd for RowId (Pere Diaz Bou)
core/io: Add completion group API for managing multiple I/O operations (Pekka Enberg)
Add short writes to unreliable-libc (FamHaggs)
add basic examples for database-wasm package (Nikita Sivukhin)
core/wal: introduce transaction_count, same as iChange in sqlite (Pere Diaz Bou)

Updated

antithesis: Upload config image in GitHub Actions workflow (Pekka Enberg)
perf/throughput: Improve reproducibility (Pekka Enberg)
translate: disallow correlated subqueries in HAVING and ORDER BY (Jussi Saurio)
Stmt reset cursors (Nikita Sivukhin)
reset move_to_right_state cached state in case of quick balancing (Nikita Sivukhin)
index_method: fully integrate into query planner (Nikita Sivukhin)
core: Switch to FxHash to improve performance (Pekka Enberg)
bindings/rust: Enable mimalloc as global allocator (Pekka Enberg)
index method syntax extension (Nikita Sivukhin)
Tighten Nyrkio p-value to 0.00001 (Henrik Ingo)
Strict numeric cast for op_must_be_int (bit-aloo)
core/vdbe: Reuse cursor in op_open_write() (Pekka Enberg)
core: Switch RwLock<Arc> to ArcSwap (Pekka Enberg)
Always returns Floats for sum and avg on DBSP aggregations (Glauber Costa)
perf/throughput: Use connection per transaction in rusqlite benchmark (Pekka Enberg)
Return null terminated strings from sqlite3_column_text (Preston Thorpe)
Order by heap sort (Nikita Sivukhin)
core/storage: Cache schema cookie in Pager (Pekka Enberg)
github: Run fuzz tests in a separate workflow (Pekka Enberg)
tests: Separate integration and fuzz tests (Pekka Enberg)
Vector speedup (Nikita Sivukhin)
parser: translate boolean values to literal when parsing column constraints (Preston Thorpe)
core/io: Make random generation deterministically simulated (Pedro Muniz)
core: move BTreeCursor under MVCC cursor (Pere Diaz Bou)
Move completion code to separate file (Pedro Muniz)
avoid unnecessary allocations (Nikita Sivukhin)
Make sure explicit column aliases have binding precedence in orderby (Pavan Nambi)
tests/integration: Reduce collation fuzz test iterations (Pekka Enberg)
Switch random blob creation to get_random (Pedro Muniz)
Shared WAL lock scoping (Pedro Muniz)
Remove tests that alter testing.db from views.test (Preston Thorpe)
tests/integration: Disable rowid alias differential fuzz test case (Pekka Enberg)
core/storage: Reduce logging level (Pekka Enberg)
cli: Improve manual page display (Pavan Nambi)
stress: prevent thread from holding write lock and then stopping (Jussi Saurio)
translate/select: prevent multiple identical non-aliased table references (Preston Thorpe)
Prevent on conflict column definitions on CREATE TABLE or opening DB (Preston Thorpe)
cli: .tables and .indexes to show data from attached tables aswell (Konstantinos Artopoulos)
bindings/rust: propagate the DropBehavior of a dropped tx to next access of DB, instead of panicing (Jussi Saurio)
Replace io_yield_many with completion groups (Pekka Enberg)
core/bree: remove duplicated code in BTreeCursor (Pere Diaz Bou)
core: Unsafe Send and Sync pushdown (Pekka Enberg)
Run SQLite integrity check after stress test run (Pedro Muniz)
Document ThreadSanitizer in CONTRIBUTING.md (Pekka Enberg)
tests/fuzz: Accept SEED env var for all fuzz tests (Preston Thorpe)
Make Rust bindings actually async (Pedro Muniz)
perf/throughput: force sqlite to use fullfsync (Pedro Muniz)
relax check in the vector test (Nikita Sivukhin)
Allow using indexes to iterate rows in UPDATE statements (Jussi Saurio)
Refactor INSERT translation to a modular setup with emitter context (Preston Thorpe)
increment Changes() only once conditionally (Pavan Nambi)
make comparison case sensitive (Pavan Nambi)
bindings/rust: Bump version recommendation to 0.2 (Kyle Kelley)
Run simulator under Miri (Bob Peterson)
Import workspace crates by name and not path (Pedro Muniz)
names shall not be shared between tables,indexs,vtabs,views (Pavan Nambi)
Get aliases to where shall they be used (Pavan Nambi)
remove cfg for MAP_ANONYMOUS (Pedro Muniz)
Simulator: Drop Index (Pedro Muniz)
Restrict joins to max 63 tables and allow arbitrary number of table columns (Jussi Saurio)
Simulator: persist files in sim memory IO for integrity check (Pedro Muniz)
Simulator: ALTER TABLE (Pedro Muniz)
Move all checksum tests behind the feature flag (Avinash Sajjanshetty)
Nyrkiö nightly: Reduce frequency to 1 per 24h (Henrik Ingo)
Vector improvements (Nikita Sivukhin)
Optimize sorter (Jussi Saurio)
Make sqlite_version() compatible with SQLite (Glauber Costa)
optimizer: optimize range scans to use upper and lower bounds more efficiently (Jussi Saurio)
translate: make bind_and_rewrite_expr() reject unbound identifiers if no referenced tables exist (Jussi Saurio)
Simulator: ignore Property::AllTableHaveExpectedContent when counting stats (Pedro Muniz)
When pwritev fails, clear the dirty pages (Pedro Muniz)
mvcc: Disable automatic checkpointing by default (Pekka Enberg)
Integrity check enhancements (Jussi Saurio)
Remove unsafe pointers (RawSlice) from RefValue (Levy A.)
Make table name not repeat in simulator (bit-aloo)
perf/throughput: Delete database before benchmark run (Pekka Enberg)
emit proper column information for explain prepared statements (Nikita Sivukhin)
core/mvcc/logical-log: switch RwLock to parking_lot (Pere Diaz Bou)
Modify Interactions Generation to only generate possible queries (Pedro Muniz)
eliminate the need for another Once in Completion (Pedro Muniz)
Rename Completion methods (Pedro Muniz)
Top level examples (Nikita Sivukhin)
docs: Explain BEGIN CONCURRENT (Pekka Enberg)
MVCC: do checkpoint writes in ascending order of rowid (Jussi Saurio)
core/mvcc: filter out seek results where is not same table_id (Pere Diaz Bou)
Simulator diff print (Pedro Muniz)
Improve simulator cli (bit-aloo)
core/mvcc: automatic logical log checkpointing on commit (Pere Diaz Bou)
remove dyn DatabaseStorage replace it with DatabaseFile (Pedro Muniz)
Actually enforce uniqueness in create unique index (Jussi Saurio)
core/wal: check index header on begin_write_tx (Pere Diaz Bou)
Disallow unexpected interop between WAL mode and MVCC mode (Jussi Saurio)

Fixed

Fix database state going back in time after sync (Nikita Sivukhin)
Fix foreign key constraint enforcement on UNIQUE indexes (Jussi Saurio)
bindings/javascript: Improve open error messages (Pekka Enberg)
core/storage: Fix WAL already enabled issue (Pekka Enberg)
Return better syntax error messages (Diego Reis)
core/vdbe: fix ALTER COLUMN to propagate constraints to other table references (Preston Thorpe)
core/translate: fix ALTER COLUMN to propagate other constraint references (Preston Thorpe")
core/translate: fix ALTER COLUMN to propagate other constraint references (Preston Thorpe)
Fix deferred FK violations check before committing to WAL (Jussi Saurio)
translate/select: Fix rewriting Rowid expression when no btree table exists in joined table refs (Preston Thorpe)
Throw parse error on CHECK constraint in create table (Preston Thorpe)
Fix: rolling back tx on Error should set autocommit to true (Jussi Saurio)
Fix: outer CTEs should be available in subqueries (Jussi Saurio)
Fix change counter incrementation (Jussi Saurio)
Fix another "should have been rewritten" translation panic (Jussi Saurio)
Simulator: fix alter table shadowing to modify index column name (Pedro Muniz)
fix backwards compatible rowid alias behaviour (Pedro Muniz)
Fix typo in manual.md (Yevhen Kostryka)
core/vdbe: Improve IdxDelete error messages with context (Pekka Enberg)
Fix disallow reserved prefixes in ALTER TABLE RENAME TO (xmchx)
Fix incorrectly using an equality constraint twice for index seek (Jussi Saurio)
Fix IN operator NULL handling (Diego Reis)
Cleanup Simulator + Fix Column constraints in sql generation (Pedro Muniz)
Fix rusqlite compatibility claim (Dave Warnock)
Fix re-entrancy of op_destroy (used by DROP TABLE) (Jussi Saurio)
Fix VDBE program abort (Nikita Sivukhin)
Fix attach I/O error with in-memory databases (Preston Thorpe)
core/incremental: Fix re-insertion of data with same key (Glauber Costa)
core/io/unix: Fix short writes in try_pwritev_raw() (FamHaggs)

0.2.0 -- 2025-10-03

Added

docs: Add section on MVCC limitations (Pekka Enberg)
sim: add Profile::SimpleMvcc (Jussi Saurio)
Add encryption internals docs (Avinash Sajjanshetty)
core/storage: Apple platforms support (Charly Delaroche)
Reject unsupported FROM clauses in UPDATE (Mikaël Francoeur)
Add Database::indexes_enabled() (Jussi Saurio)
Add Mold linker setup to CONTRIBUTING.md (Pekka Enberg)
support multiple conflict clauses in upsert (Nikita Sivukhin)
stress: add option to choose how many tables to generate (Pere Diaz Bou)
add manual page about materialized views (Glauber Costa)
support mixed integer and float expressions in the expr_compiler (Glauber Costa)
github: Add 30 minute timeout to all jobs (Pekka Enberg)
Add CAST to fuzzer (Levy A.)
Implement json_tree (Mikaël Francoeur)
translate: disable support for UPDATE ... ORDER BY (Jussi Saurio)
MVCC: support alter table (Jussi Saurio)
mvcc: add blocking checkpoint (Jussi Saurio)
Add built-in manual pages for Turso (Glauber Costa)
Support referring to rowid as rowid or oid (Jussi Saurio)
translate: implement Sequence opcode and fix sort order (Preston Thorpe)
mvcc: add blocking checkpoint lock (Jussi Saurio)
translate/emitter: Implement partial indexes (Preston Thorpe)
Support UNION queries in DBSP-based Materialized Views (Glauber Costa)
Add encryption throughput test (Avinash Sajjanshetty)
Support JOINs in DBSP materialized views (Glauber Costa)
Fix C API compatibility tests and add a minimal CI (Andrea Peruffo)
Introduce instruction VTABLE (Lâm Hoàng Phúc)
core/mvcc: introduce with_header for MVCC header update tracking (Pere Diaz Bou)
Inital support for window functions (Piotr Rżysko)
Implement Min/Max aggregators (Glauber Costa)
Add quoted identifier test cases for ALTER TABLE (Levy A.)
add perf/throughput/rusqlite to workspace (Pedro Muniz)
add perf/throughput/turso to workspace (Pedro Muniz)
Add per page checksums (Avinash Sajjanshetty)
core/throughput: Add per transaction think time support (Pekka Enberg)
Fix simulator docker build chef by adding whopper directory (Preston Thorpe)
Implement the balance_quick algorithm (Jussi Saurio)
benchmark: introduce simple 1 thread concurrent benchmark for mvcc/sq… (Pere Diaz Bou)
perf: Add simple throughput benchmark (Pekka Enberg)
Add BEGIN CONCURRENT support for MVCC mode (Pekka Enberg)
add explicit usize type annotation to range iterator in test (Denizhan Dakılır)
whopper: A new DST with concurrency (Pekka Enberg)
serverless: Add Connection.reconnect() method (Mayank)
Return parse error for unsupported exprs (Jussi Saurio)
translate: return parse error for unsupported join types (Jussi Saurio)
Add scripts that help debug bugs from simulator (Jussi Saurio)
core: Support ceiling modifier in datetime (Ceferino Patino)

Updated

CI: run long fuzz tests and stress on every PR, use 2 threads for stress (Jussi Saurio)
Disallow INDEXED BY / NOT INDEXED in select (Jussi Saurio)
core/mvcc: Rename "-lg" to "-log" (Pekka Enberg)
docs: Document more CLI command line options (Pekka Enberg)
Update man pages for encryption (Avinash Sajjanshetty)
core/mvcc: Return completions from logical log methods (Pedro Muniz)
Improve MCP configuration docs (Jamie Barton)
Enable encryption properly in Rust bindings, whopper, and throughput tests (Avinash Sajjanshetty)
Enable checksums only if its opted in via feature flag (Avinash Sajjanshetty)
Sync engine defered sync (Nikita Sivukhin)
core/vdbe: Avoid cloning Arc on every VDBE step (Pekka Enberg)
mvcc: dont try to end pager tx on connection close (Jussi Saurio)
Allow workflow_dispatch for all CI to allow for re-running jobs (Preston Thorpe)
printf should truncates floats (Pavan Nambi)
simulator: reopen database with mvcc and indexes when necessary (Pedro Muniz)
core/storage: Switch page cache queue to linked list (Pekka Enberg)
Improve throughput benchmarks (Pekka Enberg)
Beta (Pekka Enberg)
make connect() method optional and call it implicitly on first query execution (Nikita Sivukhin)
mvcc: dont use mv store for ephemeral tables (Jussi Saurio)
Simulator: Concurrent transactions (Pedro Muniz)
Measure read/write latencies in encryption benchmarks (Avinash Sajjanshetty)
simplify exec_trim code + only pattern match on whitespace char (Pedro Muniz)
MVCC: Handle table ID / rootpages properly for both checkpointed and non-checkpointed tables (Jussi Saurio)
Make encryption opt in via flag (Avinash Sajjanshetty)
core/mvcc: Optimize exclusive transaction check (Pekka Enberg)
core: change root_page to i64 (Pere Diaz Bou)
core/storage: Remove unused import from encryption.rs (Pekka Enberg)
small improvement of stress testing tool (Nikita Sivukhin)
sum() can throw integer overflow (Duy Dang)
correct span in ParseUnexpectedToken (Lâm Hoàng Phúc)
Remove double-quoted identifier assert (Diego Reis)
substr scalar should also work with non-text values (Diego Reis)
core: Disallow CREATE INDEX when MVCC is enabled (Pekka Enberg)
javascript: Rename "browser" packages to "wasm" (Pekka Enberg)
core/vdbe: Wrap Program::n_change with AtomicI64 (Pekka Enberg)
use explicit null if it set instead of column default value (Nikita Sivukhin)
Improve encryption module (Avinash Sajjanshetty)
Remove vendored parser now that we have our own (Preston Thorpe)
core/storage: Wrap Pager::commit_info with RwLock (Pekka Enberg)
core/storage: Wrap WalFile::{max,min}_frame with AtomicU64 (Pekka Enberg)
core/storage: Wrap WalFile::max_frame_read_lock_index with AtomicUsize (Pekka Enberg)
core/storage: Mark Page as Send and Sync (Pekka Enberg)
Move turso.png image to assets directory (Preston Thorpe)
core/translate: rewrite default column value from identifier to string literal (Preston Thorpe)
core/translate: Persist NOT NULL column constraint to schema table (Preston Thorpe)
Sqlean fuzzy string (Danawan Bimantoro)
Make Sorter Send and Sync (Pekka Enberg)
length shall not count when it sees nullc (Pavan Nambi)
core/storage: Wrap WalFile::syncing with AtomicBool (Pekka Enberg)
Make MVCC code Send and Sync (Pekka Enberg)
core: recover logical log on Database::connect (Pere Diaz Bou)
core/storage: Display page category for rowid integrity check failure (Pekka Enberg)
translate: refactor arguments and centralize parameter context (Preston Thorpe)
translate: disallow creating/dropping internal tables (Jussi Saurio)
Improve DBSP view serialization (Glauber Costa)
Disallow multiple primary keys in table definition (Jussi Saurio)
Display nothing for .schema command when table not found (Preston Thorpe)
Make Connection Send (Pekka Enberg)
core/mvcc/logical-log: refactor get log path in tests (Pere Diaz Bou)
Disallow ORDER BY and LIMIT in a non-compound VALUES() statement (Jussi Saurio)
core: Wrap Connection::mv_tx with RwLock (Pekka Enberg)
Autoincrement (Pavan Nambi)
core/mvcc/logical-log: load logical log from disk (Pere Diaz Bou)
Normalize target table name identifier on table or column rename (Iaroslav Zeigerman)
use a different seed for gen_rng (Pedro Muniz)
core: Wrap Connection::attached_databases with RwLock (Pekka Enberg)
core/mvcc/logical-log: on disk format for logical log (Pere Diaz Bou)
Wrap more Connection fields with atomics (Pekka Enberg)
core/mvcc: Wrap Transaction::database_header with RwLock (Pekka Enberg)
core: Wrap Connection::capture_data_changes in RwLock (Pekka Enberg)
antithesis-tests: Rename "utils.py" to "helper_utils.py" (Pekka Enberg)
Make some Connection fields atomic (Pekka Enberg)
Simulator Runtime generation (Pedro Muniz)
Use SQL over HTTP batch statements for sync push (Nikita Sivukhin)
JavaScript bindings browser tests (Nikita Sivukhin)
core: Wrap Connection::transaction_state with RwLock (Pekka Enberg)
core: Wrap Connection::autocommit in AtomicBool (Pekka Enberg)
use wasm-runtime from NPM instead of patched sources (Nikita Sivukhin)
core: Wrap Connection::database_schemas in RwLock (Pekka Enberg)
core: Wrap Connection::schema in RwLock (Pekka Enberg)
Stop incrementing n_changes for idx delete (Preston Thorpe)
core: Wrap Connection::pager in RwLock (Pekka Enberg)
Disable extension loading at runtime (Preston Thorpe)
mvcc: simplify StateMachine (Jussi Saurio)
core: Wrap Pager::io_ctx in RwLock (Pekka Enberg)
Enable checksum tests if checksum feature is on (Kacper Kołodziej)
Wrap Pager vacuum state in RwLock (Pekka Enberg)
Enhancement to Sim Snapshot isolation code (Pedro Muniz)
core/io: Ensure callbacks are invoked once (Pedro Muniz)
Upgrade dist to 0.30.0 (Pekka Enberg)
Sync improvements (Nikita Sivukhin)
Remove some unnecessary unsafe impls (Pedro Muniz)
Pragma busy timeout (Nikita Sivukhin)
translate/optimize: centralize AST/expr traversal (Preston Thorpe)
prevent alter table with materialized views (Glauber Costa)
core/mvcc: Wrap LogicalLog in RwLock (Pekka Enberg)
mvcc: remove unused code related to is_logical_log() (Jussi Saurio)
Put the unused variable behind a flag as intended (Avinash Sajjanshetty)
whopper: Gracefully handle file size limits in simulator (Avinash Sajjanshetty)
core/storage: Wrap Pager::header_ref_state in RwLock (Pekka Enberg)
core/mvcc: Kill noop storage (Pekka Enberg)
core/mvcc: LogicalLog simple append serializer (Pere Diaz Bou)
core/storage: Wrap Pager::free_page_state with RwLock (Pekka Enberg)
core: Rename Connection::_db to db (Pekka Enberg)
core/storage: Switch Pager::max_page_count to AtomicU32 (Pekka Enberg)
core/storage: Use AtomicU16 for Pager::reserved_space (Pekka Enberg)
remove io.blocks from btree balancing code (Nikita Sivukhin)
core: Use sequential consistency for atomics by default (Pekka Enberg)
core/storage: Use AtomicU32 for Pager::page_size (Pekka Enberg)
Convert more Pager fields towards being Send (Pekka Enberg)
More async (Nikita Sivukhin)
Enable encryption option in Whopper (Avinash Sajjanshetty)
Compat: Translate the 2nd argument of group_concat / string_agg (Iaroslav Zeigerman)
Reduce allocations needed for break_predicate_at_and_boundaries (Lâm Hoàng Phúc)
Simulator Multiple Connections (Pedro Muniz)
translation: rewrite expressions and properly handle quoted identifiers in UPSERT (Preston Thorpe)
Remove serialization of normal write/commit path (Preston Thorpe)
core/vtab: Wrap InternalVirtualTable with RwLock (Pekka Enberg)
Clean up encryption feature flag usage (Avinash Sajjanshetty)
core/storage: Wrap Pager::checkpoint_state in RwLock (Pekka Enberg)
core: Wrap Pager dirty_pages in RwLock (Pekka Enberg)
core: Wrap MvCursor in Arc<RwLock<>> (Pekka Enberg)
core/incremental: Wrap ViewTransactionState in Arc (Pekka Enberg)
core/function: Wrap ExtFunc in Arc (Pekka Enberg)
core/vtab: Mark VTabModuleImpl as Send and Sync (Pekka Enberg)
core/vtab: Use AtomicPtr for table_ptr (Pekka Enberg)
Remove LimboResult enum and InsnFunctionStepResult::Busy variant (Jussi Saurio)
core: Wrap symbol table with RwLock (Pekka Enberg)
core/ext: Switch vtab_modules from Rc to Arc (Pekka Enberg)
core/storage: Clean up unused import warning in encryption.rs (Pekka Enberg)
core: Convert Rc to Arc (Pekka Enberg)
whopper: Handle write-write conflict (Pekka Enberg)
mvcc: handle properly the case where starting pager read tx fails with busy (Jussi Saurio)
core/mvcc: Specify level for tracing (Pekka Enberg)
Switch to GitHub runners for performance workflows (Diego Reis)
Move common dependencies to workspace (Pedro Muniz)
avoid unnecessary cloning when formatting Txn for Display (Avinash Sajjanshetty)
Busy handler (Pedro Muniz)
test/fuzz: improve maintainability/usability of tx isolation test (Jussi Saurio)
mvcc: Complete commit state machine early if write set is empty (Jussi Saurio)
make whopper run with checksums (Avinash Sajjanshetty)
Whopper + MVCC (Pekka Enberg)
Dont grab page cache write lock in a loop (Preston Thorpe)
perf/throughput/turso: Async transactions with concurrent mode (Pekka Enberg)
Handle partial writes in unix IO for pwrite and pwritev (Preston Thorpe)
remove Stmt clone (Lâm Hoàng Phúc)
core/storage: Remove unused import warning (Pekka Enberg)
Handle EXPLAIN QUERY PLAN like SQLite (Lâm Hoàng Phúc)
Update epoch on each checkpoint to prevent using stale pages for backfilling (Preston Thorpe)
MVCC: remove reliance on BTreeCursor::has_record() (Jussi Saurio)
Refactor UPSERT to use wal_expr_mut to walk AST. (Preston Thorpe)
Commit uncommitted whopper lockfile (Jussi Saurio)
core/schema: Optimize get_dependent_materialized_views() when no views (Pekka Enberg)
core/mvcc: Eliminate RwLock wrapping Transaction (Pekka Enberg)
bindings/java: PreparedStatement executeUpdate (zongkx)
handle EXPLAIN like sqlite (Lâm Hoàng Phúc)
Document DEFERRED and IMMEDIATE transaction modes (Pekka Enberg)
Refactor parseschema (Jussi Saurio)
Remove some traces in super hot paths in btree (Preston Thorpe)
Sync package opfs (Nikita Sivukhin)
Ensure that Connection::query() checks whether its schema is up to date (Jussi Saurio)
refactor cli: readline will write to input_buf (Lâm Hoàng Phúc)
check freelist count in integrity check (Jussi Saurio)
Enable the use of indexes in DELETE statements (Jussi Saurio)
core: Rename IO::run_once() to IO::step() (Pekka Enberg)
simulator: Clean up code to use extract_if() (Pavan Nambi)

Fixed

fix sync-engine bug when auth token is provided as dynamic function (Nikita Sivukhin)
Fix COLLATE (Jussi Saurio)
core/translate: fix rowid affinity (Preston Thorpe)
Improve error handling for cyclic views (Duy Dang)
Fix MVCC drop table (Jussi Saurio)
Fix MVCC startup infinite loop when using existing DB (Jussi Saurio)
Fix: JOIN USING should pick columns from left table, not right (Jussi Saurio)
fix/vdbe: reset op_transaction state properly (Jussi Saurio)
Resolve appropriate column name for rowid alias/PK (Preston Thorpe)
fix/mvcc: deserialize table_id as i64 (Jussi Saurio)
Substr fix UTF-8 (Pedro Muniz)
fix/mvcc: set log offset to end of file after recovery finishes (Jussi Saurio)
Fix index bookkeeping in DROP COLUMN (Jussi Saurio)
Fix self-insert with nested subquery (Mikaël Francoeur)
Fix SQLite database file pending byte page (Pedro Muniz)
Index search fixes (Nikita Sivukhin)
Anonymous params fix (Nikita Sivukhin)
core/vdbe: Fix BEGIN after BEGIN CONCURRENT check (Pekka Enberg)
sum should identify if there is num in strings/prefix of strings (Pavan Nambi)
remove UnterminatedBlockComment error (Lâm Hoàng Phúc)
core/printf: Compatibility tests and fixes for printf() (Luiz Gustavo)
Fix materialized views with complex expressions (Glauber Costa)
Fix column fetch in joins (Glauber Costa)
quoting fix (Nikita Sivukhin)
translate/upsert: fix explicit conflict target of non-rowid primary key in UPSERT (Preston Thorpe)
Fix zero limit (Nikita Sivukhin)
Correct spelling issue in ForeignKey ast node (Preston Thorpe)
resolve column alias after rewritting column access in the expression in returning insert clause (Nikita Sivukhin)
Fix materialized views where clause issues (Glauber Costa)
Fix various ALTER TABLE bugs (Jussi Saurio)
Fix offset variable handling (Nikita Sivukhin)
fix encryption config in the sync-client (Nikita Sivukhin)
fix avg aggregation (Nikita Sivukhin)
Fix CREATE INDEX with quoted identifiers (Iaroslav Zeigerman)
Fix ungrouped aggregate with offset clause (Preston Thorpe)
Fix incorrect "column is ambiguous" error with USING clause (Jussi Saurio)
parser: fix incorrect LIMIT/OFFSET parsing of form LIMIT x,y (Jussi Saurio)
Fix .schema command for empty databases (Diego Reis)
Fix JavaScript bindings (Nikita Sivukhin)
Fix result columns binding precedence (Jussi Saurio)
Fix program counter update in sequence test op (Preston Thorpe)
Fix INSERT INTO t DEFAULT VALUES (Jussi Saurio)
fix: CTE alias resolution in planner (Mayank)
Differential testing fixes (Pedro Muniz)
Fix busy handler (Lâm Hoàng Phúc)
DBSP: Return a parse error for a non-equality join (Glauber Costa)
sqlite3: Fix compatibility test error by canonicalizing path (Samuel Marks)
bugfix: clear reserved space for a reused page (Avinash Sajjanshetty)
Fix MVCC concurrency bugs (Jussi Saurio)
Fix math functions compatibility issues (Levy A.)
simulator: Fix shrinking (Pedro Muniz)
Fix some Rust compilation warnings (Samuel Marks)
translate/insert: fix program.result_columns when inserting multiple rows (Preston Thorpe)
stress: Retry sync on error to avoid a panic, take 2 (Pekka Enberg)
translate: couple fixes from testing with Gorm (Preston Thorpe)
Fix is_nonnull returns true on 1 / 0 (Lâm Hoàng Phúc)
Fix 3 different MVCC bugs (Jussi Saurio)
fix re-entrancy issue in Pager::free_page (Jussi Saurio)
stress: Retry sync on error to avoid a panic (Pekka Enberg)
move divider_cell_is_overflow_cell to debug assertions (Pedro Muniz)
Fix SharedWalFile deadlock in multithreaded context (Jussi Saurio)
Fix MVCC update (Jussi Saurio)
Various fixes to sync (Nikita Sivukhin)
mvcc: fix hang when CONCURRENT tx tries to commit and non-CONCURRENT tx is active (Jussi Saurio)
mvcc: fix two sources of panic (Jussi Saurio)
Fix MVCC rollback (Jussi Saurio)
Random fixes for MVCC (Jussi Saurio)
core: Panic on fsync() error by default (Pekka Enberg)
fix(btree): advance cursor after interior node replacement in delete (Jussi Saurio)
core/vdbe: Fix BEGIN CONCURRENT transactions (Pekka Enberg)
Fix incompatible math functions (Levy A.)
fix wasm-runtime package.json (Nikita Sivukhin)
fix CI for apple builds (Nikita Sivukhin)
hack imports of wasm due to the issues in Vite and Next.js build systems (Nikita Sivukhin)
Fix tests for views (Preston Thorpe)
Fixes views (Glauber Costa)
core: Fix reprepare to properly reset statement cursors and registers (Pedro Muniz)
Fix automatic indexes (Jussi Saurio)
Fix tx isolation test semantics after #3023 (Jussi Saurio)
Fix: read transaction cannot be allowed to start with a stale max frame (Jussi Saurio)
Fix value conversion for function parameters (Levy A.)
IO: handle errors properly in io_uring (Preston Thorpe)
core: Fix integer/float comparison (Pavan Nambi)
pager: fix incorrect freelist page count bookkeeping (Jussi Saurio)

0.1.5 -- 2025-09-10

Added

add missing module type for browser package (Nikita Sivukhin)
Implement 2-args json_each (Mikaël Francoeur)
Add OPFS support to JavaScript bindings (Nikita Sivukhin)
test/fuzz: add UPDATE/DELETE fuzz test (Jussi Saurio)
add gen-bigass-database.py (Jussi Saurio)
Add assertion: we read a page with the correct id (Jussi Saurio)
support float without fractional part (Lâm Hoàng Phúc)
expr: use more efficient implementation for binary condition exprs (Jussi Saurio)
Add json_each table-valued function (1-arg only) (Mikaël Francoeur)
Add io_uring support to stress (Pekka Enberg)
Refactor LIMIT/OFFSET handling to support expressions (bit-aloo)
Encryption: add support for other AEGIS and AES-GCM cipher variants (Frank Denis)
introduce package.json for separate *-browser package (both database and sync) (Nikita Sivukhin)
introduce eq/contains/starts_with/ends_with_ignore_ascii_case macros (Lâm Hoàng Phúc)
introduce match_ignore_ascii_case macro (Lâm Hoàng Phúc)
core: Make strict schema support experimental (Pekka Enberg)
core/printf: support for more basic substitution types (Luiz Gustavo)
Return sqlite_version() without being initialized (Preston Thorpe)
Support encryption for raw WAL frames (Gaurav Sarma)
bindings/java: Implement date, time related methods under JDBC4PreparedStatement (Kim Seon Woo)
Support cipher and encryption key URI options (William Souza)
Implement UPSERT (Preston Thorpe)
CLI: implement Line output .mode (Andrey Oskin)
add sqlite integrity check back (Pedro Muniz)
core: Initial pass on synchronous pragma (Pekka Enberg)
Introduce and propagate IOContext as required (Avinash Sajjanshetty)
Add some docs on encryption (Avinash Sajjanshetty)
sqlite3: Implement sqlite3_malloc() and sqlite3_free() (Pekka Enberg)
sqlite3: Implement sqlite3_next_stmt() (Pekka Enberg)
core/translate: Add support (Pekka Enberg)
sqlite3: Implement sqlite3_db_filename() (Pekka Enberg)
flake.nix: add uv dependency to nativeBuildInputs (Ceferino Patino)
sqlite3: Implement sqlite3_bind_parameter_index() (Pekka Enberg)
sqlite3: Implement sqlite3_clear_bindings() (Pekka Enberg)
sqlite3: Implement sqlite3_get_autocommit() (Pekka Enberg)
Add support for AEGIS encryption algorithm (Avinash Sajjanshetty)
bindings/java: Implement batch operations for JDBC4Statement (Kim Seon Woo)
Add syntax highlighting for EXPLAIN and ANALYZE (Alex Miller)
Add basic support for ANALYZE statement (Alex Miller)
correctly implement offset() in parser (Lâm Hoàng Phúc)
Switch to new parser in core (Levy A.)
github: Remove Intel Mac support (Pekka Enberg)
add remove_file method to the IO (Nikita Sivukhin)
Add libc fault injection to Antithesis (Pekka Enberg)
core/mvcc: support for MVCC (Pere Diaz Bou)
SQLite C API improvements: add column type and column decltype (Danawan Bimantoro)
Initial pass to support per page encryption (Avinash Sajjanshetty)

Updated

clean print_query_result (Lâm Hoàng Phúc)
update update-script to properly handle JS workspace (Nikita Sivukhin)
no need QueryStatistics if self.opts.timer is not set (Lâm Hoàng Phúc)
optimizer: convert outer join to inner join if possible (Jussi Saurio)
Handle case where null flag is set in op_column (Jussi Saurio)
remove &1 (Lâm Hoàng Phúc)
reduce cloning Arc<Page> (Lâm Hoàng Phúc)
Evaluate left join seek key condition again after null row (Jussi Saurio)
use mlugg/setup-zig instead of unmaintained action (Kingsword)
Prevent setting of encryption keys if already set (Gaurav Sarma)
Remove RefCell from Cursor (Pedro Muniz)
Page Cache: optimize and use sieve/Gclock hybird algorithm in place of LRU (Preston Thorpe)
core: handle edge cases for read_varint (Sonny)
Persistence for DBSP-based materialized views (Glauber Costa)
io_uring: prevent out of order operations that could interfere with durability (Preston Thorpe)
core: Simplify WalFileShared life cycle (Pekka Enberg)
prevent modification to system tables. (Glauber Costa)
mark completion as done only after callback will be executed (Nikita Sivukhin)
core/mvcc: make commit_txn return on I/O (Pere Diaz Bou)
windows iterator returns no values for shorter slice (Lâm Hoàng Phúc)
Unify resolution of aggregate functions (Piotr Rżysko)
replace some matches with match_ignore_ascii_case macro (Lâm Hoàng Phúc)
Make io_uring sound for connections on multiple threads (Preston Thorpe)
build native package for ARM64 (Nikita Sivukhin)
refactor parser fmt (Lâm Hoàng Phúc)
string sometimes used as identifier quoting (Lâm Hoàng Phúc)
CURRENT_TIMESTAMP can fallback TK_ID (Lâm Hoàng Phúc)
remove turso_sqlite3_parser from turso_parser (Lâm Hoàng Phúc)
Simulate I/O in memory (Pedro)
Simulate I/O in memory (Pedro Muniz)
Refactor encryption to manage authentication tag internally (bit-aloo)
Unify handling of grouped and ungrouped aggregations (Piotr Rżysko)
Evict page from cache if page is unlocked and unloaded (Pedro Muniz)
Use u64 for file offsets in I/O and calculate such offsets in u64 (Preston Thorpe)
Document how to use CDC (Pavan Nambi)
Upgrade Rust version in simulator build Dockerfile (Preston Thorpe)
Parse booleans to integer literals in expressions (Preston Thorpe)
Simulator Profiles (Pedro Muniz)
Change views to use DBSP circuits (Glauber Costa)
core/wal: cache file size (Pere Diaz Bou)
Remove some code duplication in the CLI (Preston Thorpe)
core/translate: parse_table remove unnecessary clone of table name (Pere Diaz Bou)
Update COMPAT.md to remove CREATE INDEX default disabled (Preston Thorpe)
core/translate: remove unneessary agg clones (Pere Diaz Bou)
core/vdbe: Micro-optimize "zero_or_null" opcode (Pekka Enberg)
translate: with_capacity insns (Pere Diaz Bou)
perf: avoid constructing PageType in helper methods (Jussi Saurio)
refactor/perf: remove BTreePageInner (Jussi Saurio)
Improve integrity check (Nikita Sivukhin)
translate/insert: Improve string format performance (Pere Diaz Bou)
core/schema: get_dependent_materialized_views_unnormalized (Pere Diaz Bou)
core/util: emit literal, cow instead of replace (Pere Diaz Bou)
core/translate: sanize_string fast path improvement (Pere Diaz Bou)
core/io: Switch Unix I/O to use libc::pwrite() (Pekka Enberg)
Update README.md for Go documentation (Preston Thorpe)
improve sync engine (Nikita Sivukhin)
Remove Go bindings (Preston Thorpe)
core/storage: Micro-optimize Pager::commit_dirty_pages() (Pekka Enberg)
Rename Go driver to turso to not conflict with sqlite3 (Preston Thorpe)
Refactor: Cell instead of RefCell to store CipherMode in connection (Avinash Sajjanshetty)
Improve documentation of page pinning (Jussi Saurio)
Remove double indirection in the Parser (Pedro Muniz")
Fail CI run if Turso output differs from SQLite in TPC-H queries (Jussi Saurio)
Decouple SQL generation from Simulator crate (Pedro Muniz)
Make fill_cell_payload() safe for async IO and cache spilling (Jussi Saurio)
Remove Windows IO in place of Generic IO (Preston Thorpe)
Improve encryption API (Avinash Sajjanshetty)
Remove double indirection in the Parser (Pedro Muniz)
Update TPC-H running instructions in PERF.md (Alex Miller)
Truncate the WAL on last connection close (Preston Thorpe)
DBSP projection (Pekka Enberg)
Use vectored I/O for appending WAL frames (Preston Thorpe)
Remove unnecessary argument from Pager::end_tx() (Nikita Sivukhin)
refactor/btree: rewrite the find_free_cell() function (Jussi Saurio)
refactor/btree: rewrite the free_cell_range() function (Jussi Saurio)
Remove Result from signature (Mikaël Francoeur)
Remove duplicated attribute in (bit-aloo)
reduce cloning Token in parser (Lâm Hoàng Phúc)
refactor encryption module and make it configurable (Avinash Sajjanshetty)
Replace a couple refcells for types that trivially impl Copy (Preston Thorpe)
wal-api: allow to mix frames insert with SQL execution (Nikita Sivukhin)
move check code into parser (Lâm Hoàng Phúc)
Serialize compat tests and use Mutex::lock() instead of Mutex::try_lock() in UnixIO (Jussi Saurio)
sim: remove "run_once faults" (Jussi Saurio)
should not return a Completion when there is a page cache hit (Pedro Muniz)
github: Reduce Python build matrix (Pekka Enberg)
Page cache truncate (Nikita Sivukhin)
Wal api checkpoint seq (Nikita Sivukhin)
Use more structured approach in translate_insert (Jussi Saurio)
Remove hardcoded flag usage in DBHeader for encryption (Avinash Sajjanshetty)
properly execute pragmas - they may require some IO (Nikita Sivukhin)
Wal checkpoint upper bound (Nikita Sivukhin)
Improve WAL checkpointing performance (Preston Thorpe)
core/mvcc: store txid in conn and reset transaction state on commit (Pere Diaz Bou)
core/mvcc: start first rowid at 1 (Pere Diaz Bou)
refactor/vdbe: move insert-related seeking to VDBE from BTreeCursor (Jussi Saurio)

Fixed

Fix clear_page_cache method and rollback (Preston Thorpe)
Fix read_entire_wal_dumb: incrementally build the frame cache (Preston Thorpe)
Fix merge script to prompt if tests are still in progress (Preston Thorpe)
SQL generation fixes (Pekka Enberg)
Fix affinity handling in MakeRecord (Pekka Enberg)
Fix infinite loop when IO failure happens on allocating first page (Preston Thorpe)
Fix crash in Next opcode if cursor stack has no pages (Jussi Saurio)
cli: Fix dump compatibility in "PRAGMA foreign_keys" (Pekka Enberg)
Small fixes (Nikita Sivukhin)
Avoid allocating and then immediately fallbacking errors in affinity (Jussi Saurio)
Fix float formatting and comparison + Blob concat (Levy A.)
Fix infinite loop when query starts comment token ("--") (Lâm Hoàng Phúc)
Fix sqlite3 test cases (Pekka Enberg)
Fix non-determinism in simulator (Pedro Muniz)
Fix column count in ImmutableRow (Glauber Costa)
Fix memory leak in page cache during balancing (Preston Thorpe)
Fix sim-schema command (Pedro Muniz)
Propagate decryption error from the callback (Avinash Sajjanshetty)
Fix sorter column deduplication (Piotr Rżysko)
Fix missing functions after revert (Pedro Muniz)
ci: fix merge-pr issue to escape command-line backticks (Ceferino Patino)
Fix several issues with integrity_check (Jussi Saurio)
core/io: Fix build on Android and iOS (Pekka Enberg)
WAL txn: fix reads from DB file (Nikita Sivukhin)
Fix blob type handling in JavaScript (Pekka Enberg)
Fix: all indexes need to be updated if the rowid changes (Jussi Saurio)
Fix: in UPDATE, insert rowid into index instead of NULL (Jussi Saurio)
Fix: normalize table name in DELETE (Jussi Saurio)

0.1.4 -- 2025-08-20

Added

bindings/rust: Add method (Pekka Enberg)
Add helper to convert io::clock::Instant to useable format (Preston Thorpe)
bindings/javascript: Add TypeScript declarations to package (Pekka Enberg)
add missing closing tag (Glauber Costa)
add metrics and implement the .stats command (Glauber Costa)
Add bench-sqlite script and makefile command (Preston Thorpe)
Fix simulator docker build by adding new sync directory (Preston Thorpe)
core/mvcc: schema_did_change support and find last valid version (Pere Diaz Bou)
Add list databases and open database commands to the MCP server (Glauber Costa)
Add documentation and rename functions (Mikaël Francoeur)
Add io_yield macros to reduce boilerplate (Preston Thorpe)
Add --keep-files flag to allow for inspection of files for successful simulator runs (Preston Thorpe)
core/printf: support for the %i operand (Luiz Gustavo)
Add parser to Dockerfiles for cargo chef (Jussi Saurio)
Add framework for testing extensions in TCL (Piotr Rżysko)
Fix WAL initialization to last committed frame (Nikita Sivukhin)
sim: add Property::TableHasExpectedContent (Jussi Saurio)
Properly implement CLI command (Preston Thorpe)
docs: add Claude Code MCP integration guide (Braden Wong)
Add assertion for expected write amount in writev callback (Preston Thorpe)
sim: add Property::ReadYourUpdatesBack (Jussi Saurio)
Add support for unlikely(X) (bit-aloo)
Implement normal views (Glauber Costa)
turso-sync: support checkpoint (Nikita Sivukhin)
bindings/javascript: Add async connect() function (Pekka Enberg)
Direct schema mutation – add RenameColumn instruction (Levy A.)
Implement Aggregations for DBSP views (Glauber Costa)
stop silently ignoring unsupported features in incremental view where clauses (Jussi Saurio)
turso-sync: support updates and schema changes (Nikita Sivukhin)
turso-cdc: add updates column for cdc table (Nikita Sivukhin)
docs: improve README initialization section clarity (Braden Wong)
Add support for Full checkpoint mode in the WAL (Preston Thorpe)
Add support for PRAGMA freelist_count (bit-aloo)
Initial pass on incremental view maintenance with DBSP (Glauber Costa)
SQLite C API improvements: add bind_text and bind_blob (Danawan Bimantoro)
perf/clickbench: enable rest of queries since we support DISTINCT and REGEXP_REPLACE (Jussi Saurio)
Add table name to the delete bytecode (Glauber Costa)
Initial pass on incremental view maintenance with DBSP (Glauber Costa)
docs: fix CLI command and add homebrew install instructions for MacOS (Mattia)
Reimplement LimboRwLock in the WAL (Preston Thorpe)
BufferPool: add arena backed pool to support fixed opcodes and coalescing (Preston Thorpe)
translate: return parse errors for unsupported features instead of silently ignoring (Jussi Saurio)
Add query only pragma (bit-aloo)
Direct schema mutation – add instruction (Levy A.)
Add .clone CLI command to copy database files (Preston Thorpe)
PageContent: make read_x/write_x methods private and add dedicated methods (Jussi Saurio)
SQLite C API improvements: add basic bind and column functions (Danawan Bimantoro)
javascript: Implement Statement.iterate() (Pekka Enberg)
Fix panic on loading extension on brand new connection (Preston Thorpe)
implement the MaxPgCount opcode (Glauber Costa)
Direct schema mutation – add instruction (Levy A.)
Add regexp capture (bit-aloo)
Add load_insn macro for compiler hint in vdbe::execute hot path (Preston Thorpe)
test/fuzz: add ALTER TABLE column ops to tx isolation fuzz test (Jussi Saurio)
core/mvcc: implement exists (Pere Diaz Bou)
tests/fuzz_transactions: add tests for fuzzing transactions with MVCC (Pere Diaz Bou)
perf/btree: implement fast algorithm for defragment_page (Jussi Saurio)
bindings/rust: add with_mvcc option, open with path too! (Pere Diaz Bou)
core/mvcc: implement seeking operations with rowid (Pere Diaz Bou)
bindings/rust: add with_mvcc option (Pere Diaz Bou)
Add bitmap to track pages in arenas (Preston Thorpe)
Direct schema mutation – add instruction (Levy A.)
core/mvcc: fix new rowid on restart (Pere Diaz Bou)
Implement JavaScript bindings with minimal Rust core (Pekka Enberg)
test/fuzz/transactions: add "PRAGMA wal_checkpoint" to txn isolation fuzz test (Jussi Saurio)
Support the OFFSET clause for Compound select (meteorgan)
Introduce some state machines in preparation for IO Completions refactor (Pedro Muniz)
Add cli Dockerfile (Pere Diaz Bou)
Implement the Cast opcode (Glauber Costa)
Support VALUES clauses for compound select (meteorgan)
fix: add packages to sim/antithesis dockerfiles for cargo-chef (Jussi Saurio)
Add vector_concat and vector_slice support (bit-aloo)
bindings/rust: Add Connection::execute_batch() (Rohith Suresh)
bindings/java: Throw UnsupportedOperationException for unimplemented … (Pekka Enberg)
turso-sync package: initial commit (Nikita Sivukhin)

Updated

JavaScript improvements (Pekka Enberg)
bindings/javascript: Rename to (Pekka Enberg)
Small pager cleanups (Jussi Saurio)
Do not begin or end transactions in nested statement (Jussi Saurio)
make the MCP server instructions more visible on the README (Glauber Costa)
FaultyQuery enabled by default (Pedro Muniz)
hide our age (Glauber Costa)
make sure our responses are compliant with MCP (Glauber Costa)
Move sync code to own directory (Pekka Enberg)
Refactor: use regular save/restore context mechanism for delete balancing (Jussi Saurio)
Improve handling of inserts with column names (Wallys Ferreira)
emit SetCookie when creating a view (Glauber Costa)
unify halts (Glauber Costa)
Update stale in memory wal header after restarting log (Preston Thorpe)
sync-engine: Use SQL over HTTP instead of WAL push (Nikita Sivukhin)
Convert SQLite parser in Rust by hand (Lâm Hoàng Phúc)
Ensure we fsync the db file in all paths that we checkpoint (Preston Thorpe)
Revive async io extension PR (Preston Thorpe)
sim: reduce frequency of compound selects and complex joins (Jussi Saurio)
Use BufferPool owned by Database instead of a static global (Jussi Saurio)
sync-engine: avoid unnecessary WAL push (Nikita Sivukhin)
use virtual root page for sqlite_schema (Mikaël Francoeur)
io_uring: Gracefully handle submission queue overflow (Preston Thorpe)
Disable unused variables in cargo clippy for CI (Pedro Muniz)
Refactor: atomic ordering (Preston Thorpe)
Document the I/O model (Pedro Muniz)
disable checkpoint: adjust semantic (Nikita Sivukhin)
SDK: enable indices everywhere (Nikita Sivukhin)
Manual updates (Pekka Enberg)
Wait for I/O completions (Pedro Muniz)
IO Cleanups to use and (Pedro Muniz)
move our dbsp-based views to materialized views (Glauber Costa)
More State machines (Pedro Muniz)
Rename page -> slot for arenas + buffer pool (Preston Thorpe)
Unify JavaScript package README files (Pekka Enberg)
simple README with warning (Nikita Sivukhin)
core/wal: Minor checkpointing cleanups and optimizations (Preston Thorpe)
perf/btree: optimize op_column (Jussi Saurio)
Update PERF.md with mobibench instructions (Preston Thorpe)
Handle single, double and unquoted strings in values clause (Mikaël Francoeur)
Use rusqlite 0.37 with bundled SQLite everywhere (Jussi Saurio)
Feat/pragma module list (Lucas Forato)
remove turso-sync as now we have turso-sync-engine (Nikita Sivukhin)
Sorter IO Completions (Pedro Muniz)
Simulator should delete files after a successful run (Pedro Muniz)
turso-sync: js package (Nikita Sivukhin)
global allocator should not be set for library, only for executables (Pedro Muniz)
Evaluate WHERE conditions after LEFT JOIN (Piotr Rżysko)
Btree cache usable space (Jussi Saurio)
Rename JavaScript package to (Pekka Enberg)
perf: a few small insert optimizations (Jussi Saurio)
javascript: Organize test cases better (Pekka Enberg)
only allow multiples of 64 for performance in arena bitmap (Preston Thorpe)
btree: Use correct byte offsets for page 1 in defragmentation (Jussi Saurio)
bench/insert: use PRAGMA synchronous=full (Jussi Saurio)
JavaScript improvements (Pekka Enberg)
turso-sync: rewrite (Nikita Sivukhin)
bench/insert: use locking_mode EXCLUSIVE and journal_mode=WAL for sqlite (Jussi Saurio)
IO More State Machine (Pedro Muniz)
refactor/btree: cleanup write/delete/balancing states (Jussi Saurio)
cdc: emit entries for schema changes (Nikita Sivukhin)
Coll seq (Glauber Costa)
Remove RefCell from Buffer in IO trait methods and PageContents (Preston Thorpe)
Remove Clone impl for Buffer and PageContent (Preston Thorpe)
More state machine + Return IO in places where completions are created (Pedro Muniz)
cleanup: remove unused page uptodate flag (Jussi Saurio)
Relax I/O configuration attribute to cover all Unixes (Pedro Muniz)
Update defragment page to defragment in-place (João Severo)
Integrate virtual tables with optimizer (Piotr Rżysko)
Reprepare Statements when Schema changes (Pedro Muniz)
More State Machines in preparation for tracking IO Completions (Pedro Muniz)
coalesce any adjacent buffers from writev calls into fewer iovecs (Preston Thorpe)
extend raw WAL API with few more methods (Nikita Sivukhin)
Use pwrite for single buffer pwritev call in unix IO (Preston Thorpe)
hide dangerous methods behind conn_raw_api feature (Nikita Sivukhin)
preserve files in IO memory backend (Nikita Sivukhin)
Improve SQLite3 TCL test suite (Pekka Enberg)
Make completions idempotent (Preston Thorpe)
perf/btree: skip seek in move_to_rightmost() if we are already on rightmost page (Jussi Saurio)
perf/pager: dont clear page cache on commit (Jussi Saurio)
Rename liblimbo_sqlite3 to libturso_sqlite3 (Pekka Enberg)
core: Fold HeaderRef to pager module (Pekka Enberg)
perf/vdbe: remove eager cloning in op_comparison (Jussi Saurio)
Update cargo-dist to the latest official version (Hiroaki Yutani)
bindings/rust: Enhance API by removing verbosity (Diego Reis)
use state machine for NoConflict opcode (Mikaël Francoeur)
state_machine: remove State associated type (Pere Diaz Bou)
Single quotes inside a string literal have to be doubled in (Diego Reis)
core/mvcc: Move commit_txn() to generic state machinery (Pere Diaz Bou)
bindings/javascript: Reduce VM/native crossing overhead (Pekka Enberg)
Enable indexes by default (Jussi Saurio)
perf/btree: improve performance of rowid() function (Jussi Saurio)
core/mvcc: Persist changes through pager on commit (Pere Diaz Bou)
Open a temporary on-disk file for ephemeral tables (Jussi Saurio)
Force Sqlite to parse schema on connection benchmark (Levy A.)
more compat police (Glauber Costa)
Bury limbo-wasm (Diego Reis)
IN queries (Glauber Costa)
IN queries (Glauber Costa)
vdbe: Disallow checkpointing in transaction (Jussi Saurio)
Serverless JavaScript driver improvements (Pekka Enberg)
Direct DatabaseHeader reads and writes – with_header and with_header_mut (Levy A.)
refactor/btree: simplify get_next_record()/get_prev_record() (Jussi Saurio)
Accumulate/batch vectored writes when backfilling during checkpoint (Preston Thorpe)
remove non-existent opcode (Glauber Costa)
skip invalid inputs in cosine distance prop test (bit-aloo)
core/mvcc: Switch to parking_lot RwLock (Pekka Enberg)
Rewrite the WAL (Preston Thorpe)
turso-sync: bidirectional sync for local db (Nikita Sivukhin)
Change more function signatures to return Completions (Pedro Muniz)
Clean up conversion between InsnFunctionStepResult and StepResult (Diego Reis)
core/mvcc: simplify mvcc cursor types (Pere Diaz Bou)
bindings/javascript: Run tests serially (Diego Reis)
Javascript testing cleanups (Pekka Enberg)
Javascript API improvements (Pekka Enberg)
Change function signatures to return IO Completions (Pedro Muniz)

Fixed

Fix page locked panic (Pedro Muniz)
Remove assertions from Completion::complete() and Completion::error() (Jussi Saurio)
Completion Error (Pedro Muniz)
fix/sim: prevent sim from trying to create an existing table or index (Jussi Saurio)
Fail simulator on parse errors (Jussi Saurio)
fix pragma table_info for views (Glauber Costa)
Fix two issues in simulator (Jussi Saurio)
Fix distinct order by (Jussi Saurio)
Fix UPDATE: Do not use an index for iteration if that index is going to be updated (Jussi Saurio)
Fix non-4096 page sizes (Jussi Saurio)
fix: Handle fresh INSERTs in materialized view incremental maintenance (Glauber Costa)
Fix: do computations on usable_space as usize, not as u16 (Jussi Saurio)
Sync engine fixes (Nikita Sivukhin)
Fix tables renaming to existing index and rename indexed columns on (Levy A.)
Fix max_frame determination and comments in WAL checkpointing (Preston Thorpe)
turso-sync: fix schema bug (Nikita Sivukhin)
Fix: Rename clickbench output file limbo/turso (Henrik Ingo)
Reprepare fix on write statement (Pedro Muniz)
Fix view processing in the VDBE (Jussi Saurio)
Fix performance regression in prepare (Piotr Rżysko)
Fix JavaScript bindings packaging (Nikita Sivukhin)
bench/insert: fix expected return value from pragma (Jussi Saurio)
Fix segfault on schema update for virtual tables (Preston Thorpe)
core/btree: fix re-entrancy bug in insert_into_page() (Jussi Saurio)
Fix performance regression (Jussi Saurio)
fix/wal: remove start_pages_in_frames_hack to prevent checkpoint data loss (Jussi Saurio)
fix/core/translate: ALTER TABLE DROP COLUMN: ensure schema cookie is updated even when target table is empty (Jussi Saurio)
io_uring: setup plumbing for Fixed opcodes (Preston Thorpe)
JavaScript serverless driver fixes (Pekka Enberg)
Fix vector deserialization alignment and blob/text empty mismatch (bit-aloo)
fix/wal: reset ongoing checkpoint state when checkpoint fails (Jussi Saurio)
Fix parser error for repetition in row values (Diego Reis)
fix/wal: only rollback WAL if txn was write + fix start state for WalFile (Jussi Saurio)
fix/bindings/rust: return errors instead of swallowing them and returning None (Jussi Saurio)
fix/wal: make db_changed check detect cases where max frame happens to be the same (Jussi Saurio)
fix/wal: reset page cache when another connection checkpointed in between (Jussi Saurio)
Fix merge script to prevent incorrectly marking merged contributor PRs as closed (Preston Thorpe)
Fix concat_ws to match sqlite behavior (bit-aloo)
bindings/rust: return errors instead of vibecoded numbers (Jussi Saurio)

0.1.3 -- 2025-07-29

Added

bindings/rust: Add WAL API support (Nikita Sivukhin)
Implement the Returning statement for inserts and updates (Glauber Costa)
implement the pragma encoding (Glauber Costa)
support doubly qualified identifiers (Glauber Costa)
mark detach as supported (Glauber Costa)
Support ATTACH (read only) (Glauber Costa)
serverless: Add DatabasError type (Pekka Enberg)
btree/balance: support case where immediate parent page of unbalanced child page also overflows (Jussi Saurio)
serverless: Add Statement.run() method (Pekka Enberg)
make add dirty to change flag and also add page to the dirty list (Nikita Sivukhin)
types: less noisy Debug implementation for ImmutableRecord (Jussi Saurio)
Safe AtomicUsize wrapper for db_state: add DbState and AtomicDbState (Levy A.)
Add Github workflow for Turso serverless package (Pekka Enberg)
Add Rickrolling Turso blog post to contrib (Avinash Sajjanshetty)
Add @tursodatabase/serverless package (Pekka Enberg)
Implement pragma database_list (Glauber Costa)
fix/test: fix and unignore incorrectly implemented test (Jussi Saurio)
implement Debug for Database (Glauber Costa)
implement pragma application_id (Glauber Costa)
implement write side of pragma schema_version (Glauber Costa)
Simplify blocking operations – add io.block(fn) for IO trait implementors (Levy A.)
bindings/rust: Initial support for transactions API (Diego Reis)
claude sonnet forgot to run clippy when implementing mcp server (Jussi Saurio)
bindings/js: support iterator, and more kinds of params (Mikaël Francoeur)
Add a native MCP server (Glauber Costa)
sim: add order by to some queries (Jussi Saurio)
Core: Introduce external sorting (Iaroslav Zeigerman)
forgot to set the state to NewTrunk if we have more leaf pages than free entries (Pedro Muniz)
Implement IO latency correctly in simulator (Pedro Muniz)
page cache: temporarily increase default size until WAL spill is implemented (Jussi Saurio)
compat: add integrity_check (Pere Diaz Bou)
sim: provide additional context in assertion failures (Jussi Saurio)
btree: add some assertions related to #2106 (Jussi Saurio)
bench: add insert benchmark (batch sizes: 1,10,100) (Jussi Saurio)
Support page_size pragma setting (meteorgan)

Updated

bindings/javascript: Generate native npm packages at publish (Pekka Enberg)
Replace custom wasm bindings with napi-rs (Diego Reis)
core: Enforce shared database object per database file (Pekka Enberg)
btree/pager: Improve update performance by reusing freelist pages in allocate_page() (Jussi Saurio)
VDBE/op_column: use references to cursor payload instead of cloning (Jussi Saurio)
io/unix: wrap file with Mutex (Pere Diaz Bou)
core: Clone everything in schema (Pere Diaz Bou)
core/translate: Handle Expr::Id in CREATE INDEX (Kristofer)
Thread-safe WindowsFile (Levy A.)
io_uring: use Arc pointer for user data of entries (Preston Thorpe)
Stop checkpointing the entire WAL after every write when wal frame size > threshold (Preston Thorpe)
compat police (Glauber Costa)
remove upsert statement from COMPAT.md (Glauber Costa)
Update limbo -> turso in manual.md (stano)
bindings/javascript: Switch to napi v3 (Diego Reis)
Simplify sum() aggregation logic (bit-aloo)
Ignore WAL frames after bad checksum (Pere Diaz Bou)
parser: Distinguish quoted identifiers and unify Id into Name enum (bit-aloo)
btree: clear overflow pages when insert overwrites a cell (= UPDATE) (Jussi Saurio)
Append WAL frames one by one (Pere Diaz Bou)
pager: Clear stale page cache if database changed (Jussi Saurio)
sim/aws: ignore child process exits with code 137 (Jussi Saurio)
WAL insert API: force schema re-parse if necessary after WAL sync session end (Nikita Sivukhin)
WAL insert: mark pages as dirty (Nikita Sivukhin)
emit SetCookie after DropTable (Glauber Costa)
Bail early for read-only virtual tables (Preston Thorpe)
measure only the time it takes to open the actual connection (Glauber Costa)
Explicit rowid insert (Nikita Sivukhin)
Deserialize keys only once when sorting immutable records (Iaroslav Zeigerman)
WAL insert API (Nikita Sivukhin)
Pager: clear overflow cells when freeing page (Jussi Saurio)
make readonly a property of the database (Glauber Costa)
use default hasher for the sake of determinism (Nikita Sivukhin)
Load static extensions once and store on Database instead of once per connection (Preston Thorpe)
wal: write txn fail in case max_frame change midway (Pere Diaz Bou)
Improve Antithesis tests (Pekka Enberg)
core/lib: init_pager lock shared wal until filled (Pere Diaz Bou)
test/stress&sim: enable indexes by default (Jussi Saurio)
Usable space unwrap (Pedro Muniz)
BTreeTable::to_sql: wrap special column names in brackets (Nils Koch)
Avoid redundant decoding of record headers when reading sorted chunk files (Iaroslav Zeigerman)
compat: change page_size pragma and RowData opcode to yes (meteorgan)
Explain the Turso challenge (Glauber Costa)
gh workflow for dart (test, precompile, publish), only test is activated (Andika Tanuwijaya)
bindings/rust: Return number of rows changed from Connection::execute() (Rohith Suresh)
bindings/java: Make TursoDB and TursoDB factory thread-safe (Mikaël Francoeur)
use wasm32-wasip1 target instead of wasm32-wasi (Nils Koch)
improve handling of double quotes (Glauber Costa)
Remove find_cell, allow overwrite of index interior cell (Jussi Saurio)
sim: change --disable-create-index flag to --enable-create-index (default false) (Jussi Saurio)
Reanimate MVCC (Pekka Enberg)
Replace verbose IO Completion methods with helpers (Preston Thorpe)
Use pread and pwrite in run_once (Ihor Andrianov)
make_from_btree should wait for IO to complete (Pedro Muniz)
chore: update rust to version 1.88.0 (Nils Koch)
refactor/btree&vdbe: fold index key info (sort order, collations) into a single struct (Jussi Saurio)
core: Copy-on-write for in-memory schema (Levy A.)
simulator: Disable INSERT INTO .. SELECT for being slow (Pekka Enberg)
Async IO: registration of file descriptors (Preston Thorpe)
Clean up AST unparsing, remove ToSqlString (Levy A.)
rename operation_xxx to change_xxx to make naming more consistent (Nikita Sivukhin)
Separate user-callable cacheflush from internal cacheflush logic (Diego Reis)
make unixepoch to return i64 (Nikita Sivukhin)
sim: ignore fsync faults (Jussi Saurio)
Updates to the simulator (Alperen Keleş)
small refactor: rename "amount" to "extra_amount" (Nikita Sivukhin)
refactor: Changes CursorResult to IOResult (Diego Reis)
btree: unify table&index seek page boundary handling (Jussi Saurio)
Treat table-valued functions as tables (Piotr Rżysko)

Fixed

perf: fix logic error in is_simple_count() (Jussi Saurio)
Fix writing wal header for async IO (Preston Thorpe)
bindings/javascript: Fix tracing and SqliteError message not populated (Levy A.)
Fix sum() to follow the SQLite semantics (FamHaggs)
Fix error handling when binding column references while translating the UPDATE statement (Iaroslav Zeigerman)
Fix schema reparse logic (Nikita Sivukhin)
Fix page_count pragma (meteorgan)
sqlite3: Improve SQLite error handling and fix C-string safety (Ceferino Patino)
fix: SUM returns correct float for mixed numeric/non-numeric types & return value on empty set (Axel Tobieson Rova)
silence clippy errors with features disabled (Glauber Costa)
fix raw read frame WAL API (Nikita Sivukhin)
Work around CREATE TABLE whitespace issue (Jussi Saurio)
Fix issues in alter table tests and fix a small error in BTreeTable::to_sql (Jussi Saurio)
Fix duplicate SET statement compatibility with SQLite (Ihor Andrianov)
test/clickbench: fix clickbench (Jussi Saurio)
fix/sim: actually enable indexes by default (Jussi Saurio)
fix/btree/balance: interior cell insertion can leave page overfull (Jussi Saurio)
Fix error: Stable 1.88.0 is not available in Nix flake (Levy A.)
Fix column order for multi-row insertion (Nikita Sivukhin)
doc: fix intra-repo links for contribution guide and license, and expand binding links (bit-aloo)
fix opcodes missing a database register (Glauber Costa)
sorter: fix sorter panic on SortedChunkIOState::WaitingForRead (Jussi Saurio)
Fix parent page stack location after interior node replacement (Jussi Saurio)
Fix rollback for TxErrors (Diego Reis)
make most instrumentation levels to be Debug or Trace instead (Pedro Muniz)
Property FaultyQuery should fail if we encounter an error that is not expected (Pedro Muniz)
translate/create index: fix wrong collations (Jussi Saurio)
bind/java: Fix Linux x86 build release (Diego Reis)
fix/btree: fix insert_into_cell() logic (Jussi Saurio)
cli: fix not being able to redirect traces to a file from inline query (Jussi Saurio)
bind/javascript: Fix presentation mode disabling logic (Diego Reis)
btree: fix post-balancing seek bug in delete path (Jussi Saurio)
btree: fix trying to go upwards when we are already at the end of the entire btree (Jussi Saurio)
btree: fix interior cell replacement in btrees with depth >=3 (Jussi Saurio)
extensions/vtab: fix i32 being passed as i64 across FFI boundary (Jussi Saurio)
Fix CSV import in the shell (Jussi Saurio)
fix record header size calculations and incorrect assumptions (Jussi Saurio)
bindings/js: fix more tests (Mikaël Francoeur)

0.1.2 -- 2025-07-15

Added

Add fuzz to CI checks (Levy A.)
Add async header accessor functionality (Zaid Humayun)
core/vector: Euclidean distance support for vector search (KarinaMilet)
Fix: OP_NewRowId to generate semi random rowid when largest rowid is i64::MAX (Krishna Vishal)
vdbe: fix some issues with min() and max() and add ignored fuzz test (Jussi Saurio)
github: Update to newest Nyrkiö Github action (Henrik Ingo)
Add Nyrkiö to partners section in README (Henrik Ingo)
Support except operator for Compound select (meteorgan)
btree: fix incorrect comparison implementation in key_exists_in_index() (Jussi Saurio)
bindings/java: Implement required methods to run on JetBrains Datagrip (Kim Seon Woo)
add interactive transaction to property insert-values-select (Pere Diaz Bou)
add pere to antithesis (Pere Diaz Bou)
cli: Add support for .headers command (Pekka Enberg)
stress: add a way to run stress with indexes enabled (Jussi Saurio)
sim: add feature flags (indexes,mvcc) to CLI args (Jussi Saurio)
Add multi select test in JDBC4StatementTest (Kim Seon Woo)
bindings/dart initial implementation (Andika Tanuwijaya)
bindings/javascript: Implement Database.open (Lucas Forato)
add libsql_disable_wal_checkpoint (Pedro Muniz)
Add a threshold for large page cache values (Krishna Vishal)
Rollback schema support (Pere Diaz Bou)
add a README for the rust bindings (Glauber Costa)
add a basic readme for the typescript binding (Glauber Costa)
add a benchmark for connection time versus number of tables (Glauber Costa)
Add opening new connection from a sqlite compatible URI, read-only connections (Preston Thorpe)
Simplify PseudoCursor implementation (Levy A.)
bind/js: add tests for expand (Mikaël Francoeur)

Updated

Gopher is biologically closer to beavers than hamsters (David Shekunts)
build: Update cargo-dist to 0.28.6 (Pekka Enberg)
cli: Fail import command if table does not exists (Pekka Enberg)
Assert I/O read and write sizes (Pere Diaz Bou)
do not check rowid alias for null (Nikita Sivukhin)
CDC functions (Nikita Sivukhin)
Ignore double quotes around table names (Zaid Humayun)
Efficient Record Comparison and Incremental Record Parsing (Krishna Vishal)
parse_schema_rows optimizations (Levy A.)
Simulator - only output color on terminal (Mikaël Francoeur)
Btree: more balance docs (Jussi Saurio)
btree: Improve balance non root docs (Jussi Saurio)
properly set last_checksum after recovering wal (Pere Diaz Bou)
btree/chore: remove unnecessary parameters to .cell_get() (Jussi Saurio)
core/btree: Make cell field names consistent (Jussi Saurio)
Enforce TCL 8.6+ in compatibility tests (Mikaël Francoeur)
Minor refactoring of btree (meteorgan)
bindings/python: Start transaction implicitly in execute() (Pekka Enberg)
sqlite3_ondisk: generalize left-child-pointer reading function to both index/table btrees (Jussi Saurio)
sim: post summary to slack (Jussi Saurio)
stress clippy (Jussi Saurio)
Synchronize WAL checkpointing (Pere Diaz Bou)
Reachable assertions in Antithesis Python Test for better logging (Pedro Muniz")
bindings/python: close connection only when reference count is one (Pere Diaz Bou)
parser: use YYSTACKDEPTH (Lâm Hoàng Phúc)
CI: remove duplicate fuzz run (Jussi Saurio)
Use binary search in find_cell() (Ihor Andrianov)
Use str_to_f64 on float conversion (Levy A.)
parser: replace KEYWORDS with matching (Lâm Hoàng Phúc)
Reachable assertions in Antithesis Python Test for better logging (Pedro Muniz)
treat ImmutableRecord as Value::Blob (Nikita Sivukhin)
remove experimental_flag from script + remove -q flag default flag from TestTursoShell (Pedro Muniz)
Change data capture (Nikita Sivukhin)
Import subset of SQLite TCL tests (Pekka Enberg)
bindings/java: Merge JavaScript test suites (Mikaël Francoeur)
Import JavaScript bindings test suite from libSQL (Mikaël Francoeur)
bindings/java: Rename to Turso (Diego Reis)
Antithesis schema rollback tests (Pekka Enberg)
Disable adaptive colors when output_mode is list (meteorgan)
core/storage: Switch to turso_assert in btree.rs (Pekka Enberg)
core: Disable ROLLBACK statement (Pekka Enberg")
Rust binding improvements (Pedro Muniz")
from_uri was not passing mvcc and indexes flag to database creation for memory path (Pedro Muniz)
Turso, not Limbo, in pyproject.toml (Simon Willison)
Rename Limbo -> Turso in python tests (Preston Thorpe)
clarify discord situation (Glauber Costa)
automatically select terminal colors for pretty mode (Glauber Costa)
remote query_mode from ProgramBuilderOpts and from function arguments (Nikita Sivukhin)
limbo -> turso (Glauber Costa)
Rust binding improvements (Pedro Muniz)

Fixed

test/fuzz: fix rowid_seek_fuzz not being a proper fuzz test (Jussi Saurio)
b-tree: fix bug in case when no matching rows was found in seek in the leaf page (Nikita Sivukhin)
Fix clippy errors for Rust 1.88.0 (Nils Koch)
sim: return LimboError::Busy when busy, instead of looping forever (Jussi Saurio)
btree/balance/validation: fix divider cell insert validation (Jussi Saurio)
btree/balance/validation: fix use-after-free in rightmost ptr validation (Jussi Saurio)
core/translate: Fix "misuse of aggregate function" error message (Pekka Enberg)
core/translate: Return error if SELECT needs tables and there are none (Mikaël Francoeur)
antithesis: Fix transaction management (Pekka Enberg)
core: Fix resolve_function() error messages (Pekka Enberg)
VDBE: fix op_insert re-entrancy (Jussi Saurio)
VDBE: fix op_idx_insert re-entrancy (Jussi Saurio)
bindings/javascript: Improve error handling compatibility with better-sqlite3 (Mikaël Francoeur)
uv run ruff format && uv run ruff check --fix (Jussi Saurio)
vdbe: fix compilation (Pere Diaz Bou)
core/translate: Fix aggregate star error handling in prepare_one_sele… (Pekka Enberg)
Fix infinite loops, rollback problems, and other bugs found by I/O fault injection (Pedro Muniz)
core/translate: Unify no such table error messages (Pekka Enberg)
Fix ScalarFunc::Glob to handle NULL and other value types (Krishna Vishal)
fix: buffer pool is not thread safe problem (KaguraMilet)
Fix index update when INTEGER PRIMARY KEY (rowid alias) (Adrian-Ryan Acala)
Fix Python test import naming (Pedro Muniz)
Fix boxed memory leaks (Ihor Andrianov)
bindings/javascript: Formatting and typos (Mikaël Francoeur)

0.1.1 -- 2025-06-30

Fixed

JavaScript packaging (Pekka Enberg)

Updated

simulator: FsyncNoWait + Faulty Query (Pedro Muniz)

0.1.0 -- 2025-06-30

Added

bindings/rust: Add feature flag to enable indexes (Pekka Enberg)
core: Add Antithesis-aware turso_assert (Pekka Enberg)
Fix database header contents on initialization (Pere Diaz Bou)
Support insersect operator for compound select (meteorgan)
Simulator: add latency to File IO (Pedro Muniz)
write page1 on database initialization (Pere Diaz Bou)
Rollback simple support (Pere Diaz Bou)
core/db&pager: fix locking for initializing empty database (Jussi Saurio)
sim: add Fault::ReopenDatabase (Jussi Saurio)
Fix database header initialization (Diego Reis)
Add Pedro to email recipients for antithesis (Pedro Muniz)
bindings/rust: Implement Debug for Connection (Charlie)
Fix: add uv sync to all packages for pytest github action (Pedro Muniz)
Implement RowData opcode (meteorgan)
Support indent for Goto opcode when executing explain (meteorgan)

Updated

core: Disable ROLLBACK statement (Pekka Enberg)
WAL record db_size frame on commit last frame (Pere Diaz Bou)
Eliminate core extension dependencies (Pekka Enberg)
Move completion extension dependency to CLI (Pekka Enberg)
Rename limbo crate to turso (Pekka Enberg)
Rename limbo_sqlite3_parser crate to turso_sqlite3_parser (Pekka Enberg)
Rename limbo_ext crate to turso_ext (Pekka Enberg)
Rename limbo_macros to turso_macros (Pekka Enberg)
stress: Log reopen and reconnect (Pekka Enberg)
Rename limbo_core crate to turso_core (Pekka Enberg)
github: Run simulator on pull requests (Pekka Enberg)
bindings/rust: Named params (Andika Tanuwijaya)
Rename Limbo to Turso in the README and other files (Glauber Costa)
Remove dependency on test extension pkg (Preston Thorpe)
Cache reserved_space and page_size values at Pager init to prevent doing redundant IO (Krishna Vishal)
cli: Rename CLI to Turso (Pekka Enberg)
bindings/javascript: Rename package to @tursodatabase/turso (Pekka Enberg)
bindings/python: Rename package to pyturso (Pekka Enberg)
Rename Limbo to Turso Database (Pekka Enberg)
Bring back TPC-H benchmarks (Pekka Enberg)
Switch to runtime flag for enabling indexes (Pekka Enberg)
stress: reopen db / reconnect to db every now and then (Jussi Saurio)
Bring back some merge conflicts code (Pedro Muniz)
simulator: integrity check per query (Pedro Muniz)
stress: Improve progress reporting (Pekka Enberg)
Improve extension compatibility testing (Piotr Rżysko)
Ephemeral Table in Update (Pedro Muniz)
Use UV more in python related scripts and actions (Pedro Muniz)
Copy instrumented image and symbols in Dockerfile.antithesis (eric-dinh-antithesis)
op_transaction end_read_tx in case of begin_write_tx is busy (Pere Diaz Bou)
antithesis-tests: Make test drivers robust when database is locked (Pekka Enberg)

Fixed

tests/integration: Fix write path test on Windows (Pekka Enberg)
Fix deleting previous rowid when rowid is in the Set Clause (Pedro Muniz)
Fix executing multiple statements (Pere Diaz Bou)
Fix evaluation of ISNULL/NOTNULL in OR expressions (Piotr Rżysko)
bindings/javascript: Fix StepResult:IO handling (Pekka Enberg)
fix: use uv run instead of uvx for Pytest (Pedro Muniz)
sim: when loading bug, dont panic if there are no runs (Jussi Saurio)
sim: fix singlequote escaping and unescaping (Jussi Saurio)
Fix btree balance and seek after overwritten cell overflows (Jussi Saurio)
chore: fix clippy warnings (Nils Koch)
Fix CI errors (Piotr Rżysko)
Fix infinite aggregation loop when sorting is not required (Piotr Rżysko)
Fix DELETE not emitting constant WhereTerms (Pedro Muniz)
Fix handling of non-aggregate expressions (Piotr Rżysko)
Fix fuzz issue #1763 by using the log2 & log10 functions where applicable (Luca Muscat)

0.0.22 -- 2025-06-19

Added

Implement pragma wal_checkpoint() (Pedro Muniz)
Add abbreviated alias for .quit and .exit (Krishna Vishal)
Add manual WAL sync before checkpoint in con.close, fix async bug in checkpoint (Preston Thorpe)
Complete ALTER TABLE implementation (Levy A.)
Add affinity-based type coercion for seek and comparison operation (Krishna Vishal)
bindings/javascript: Add pragma() support (Anton Harniakou)
Add sleep between write tests to avoid database locking issues (Pedro Muniz)
bindings/java: Implement JDBC4DatabaseMetadata getTables (Kim Seon Woo)
bindings/javascript: Add source property to Statement (Anton Harniakou)
Support sqlite_master schema table name alias (Anton Harniakou)
js-bindings/implement .name property (Anton Harniakou)
bindings/java: Add support for Linux build (Diego Reis)
bindings/javascript: Add database property to Statement (Anton Harniakou)
simulator: add CREATE INDEX to interactions (Jussi Saurio)
Add support for pragma table-valued functions (Piotr Rżysko)
bindings/javascript: Add proper exec() method and raw() mode (Diego Reis)
Add simulator-docker-runner for running limbo-sim in a loop on AWS (Jussi Saurio)
simulator: add option to disable BugBase (Jussi Saurio)
simulator: switch to tracing, run io.run_once and add update queries (Pere Diaz Bou)
Fix: aggregate regs must be initialized as NULL at the start (Jussi Saurio)
add stress test with 1 thread 10k iterations to ci (Pere Diaz Bou)

Updated

antithesis: Build Python package from sources (Pekka Enberg)
overwrite sqlite3 in install_sqlite (Pere Diaz Bou)
stress: Run integrity check for every iteration (Pekka Enberg)
core: Clean up integrity_check() (Pekka Enberg)
Simple integrity check on btree (Pere Diaz Bou)
Make SQLite bindings thread-safe (Pekka Enberg)
Switch Connection to use Arc instead of Rc (Pekka Enberg)
Drop unused code in op_column (meteorgan)
NOT NULL constraint (Anton Harniakou)
Simulator Ast Generation + Simulator Unary Operator + Refactor to use limbo_core::Value in Simulator for massive code reuse (Pedro Muniz)
Refactor compound select (meteorgan)
Disable index usage in DELETE because it does not work safely (Jussi Saurio)
Simulator: Better Shrinking (Pedro Muniz)
Simulator integrity_check (Pedro Muniz)
Remove leftover info trace (Jussi Saurio)
Namespace functions that operate on Value (Pedro Muniz)
Remove plan.to_sql_string() from optimize_plan() as it panics on TODOs (Jussi Saurio)
Minor: use use_eq_ignore_ascii_case in some places (Anton Harniakou)
Remove the FromValue trait (Anton Harniakou)
bindings/javascript: Refactor presentation mode and enhance test suite (Diego Reis)
Beginnings of AUTOVACUUM (Zaid Humayun)
Reverse Parse Limbo ast and Plans (Pedro Muniz)
simulator: log the interaction about to be executed with INFO (Jussi Saurio)
stress: Use temporary file unless one explicitly specified (Jussi Saurio)
Write database header via normal pager route (meteorgan)
simulator: options to disable certain query types (Pedro Muniz)
Make cursor seek reentrant (Pedro Muniz)
Pass input string to translate function (Pedro Muniz)
Small tracing enhancement (Pedro Muniz)
Adjust write cursors for delete to avoid opening more than once. (Pedro Muniz)
Convert u64 rowid to i64 (Pere Diaz Bou)
Use tempfile in constraint test (Jussi Saurio)
Remove frame id from key (Pere Diaz Bou)
clear page cache on transaction failure (Pere Diaz Bou)

Fixed

Fix incorrect lossy conversion of Value::Blob to a utf-8 String (Luca Muscat)
Fix update queries to set n_changes (Kim Seon Woo)
bindings/rust: Fix Rows::next() I/O dispatcher handling (Pekka Enberg)
cli: fix panic of queries with less than 7 chars (Nils Koch)
Return parse error instead of corrupt error for no such table (Pedro Muniz)
simulator: disable all ansi encodings for debug print log file (Pedro Muniz)
Fix large inserts to unique indexes hanging (Jussi Saurio)
betters instrumentation for btree related operations + cleaner debug for RefValue (Pedro Muniz)
sim/aws: fix vibecoding errors in logic (Jussi Saurio)
Fix incorrect handling of OR clauses in HAVING (Jussi Saurio)
fix: Incorrect placeholder label in where clause translation (Pedro Muniz)
Fix rowid to_sql_string (Pedro Muniz)
Fix incorrect usage of indexes with non-contiguous columns (Jussi Saurio)
BTree traversal refactor and bugfixes (Pere Diaz Bou)
LimboRwLock write and read lock fixes (Pere Diaz Bou)
fix: make keyword_token safe by validating UTF-8 input (ankit)
Fix UPDATE straight up not working on non-unique indexes (Jussi Saurio)
Fix: ensure PRAGMA cache_size changes persist only for current session (meteorgan)
sim/aws: fix sim timeout handling (Jussi Saurio)
Fix WAL frame checksum mismatch (Diego Reis)
Set maximum open simulator-created issues (Jussi Saurio)
Fix cursors not being opened for indexes in DELETE (Jussi Saurio)
Fix: allow DeferredSeek on more than one cursor per program (Jussi Saurio)
Fix stress test to ignore unique constraint violation (krishna sindhur)
Fix ProgramBuilder::cursor_ref not having unique keys (Jussi Saurio)
Fix serialize() unreachable panic (Krishna Vishal)
Btree: fix cursor record state not being updated in insert_into_page() (Jussi Saurio)

0.0.21 - 2025-05-28

Added

Add Schema reference to Resolver - needed for adhoc subquery planning (Jussi Saurio)
Use the SetCookie opcode to implement user_version pragma (meteorgan)
Add libsql_wal_get_frame() API (Pekka Enberg)
Fix bug: op_vopen should replace cursor slot, not add new one (Jussi Saurio)
bind/js: Add support for bind() method and reduce boilerplate (Diego Reis)
Add PThorpe92 to codeowners file for extensions + go bindings (Preston Thorpe)
Refactor: add stable internal_id property to TableReference (Jussi Saurio)
refactor: introduce walk_expr() and walk_expr_mut() to reduce repetitive pattern matching (Jussi Saurio)
Add some comments for values statement (meteorgan)
fix bindings/wasm wal file creation by implementing generate_random_number (오웬)
core/pragma: Add support for update user_version (Diego Reis)
Support values statement and values in select (meteorgan)
Initial Support for Nested Translation (Pedro Muniz)
bindings/rust: Add pragma methods (Diego Reis)
Add collation column to Index struct (Jussi Saurio)
Add support for DISTINCT aggregate functions (Jussi Saurio)
bindings/javascript: Add Statement.iterate() method (Diego Reis)
(btree): Implement support for handling offset-based payload access with overflow support (Krishna Vishal)
Add labeler workflow and reorganize macros (Preston Thorpe)
Update Nyrkiö change detection to newest version (Henrik Ingo)
perf/ci: add basic tpc-h benchmark (Jussi Saurio)
Add libsql_wal_frame_count() API (Pekka Enberg)
Restructure optimizer to support join reordering (Jussi Saurio)
Add rustfmt to rust-toolchain.toml (Pekka Enberg)

Updated

Make WhereTerm::consumed a Cell (Jussi Saurio)
Use lifetimes in walk_expr() to guarantee that child expr has same lifetime as parent expr (Jussi Saurio)
Small VDBE insn tweaks (Jussi Saurio)
Reset idx delete state after successful finish (Pere Diaz Bou)
feature: INSERT INTO <table> SELECT (Pedro Muniz)
Small cleanups to pager/wal/vdbe - mostly naming (Jussi Saurio)
bindings/javascript: API enhancements (Diego Reis)
github: Migrate workflows to Blacksmith runners (blacksmith-sh[bot])
UNION (Jussi Saurio)
xConnect for virtual tables to query core db connection (Preston Thorpe)
Reconstruct WAL frame cache when WAL is opened (Jussi Saurio)
set non-shared cache by default (Pere Diaz Bou)
TPC-H with criterion and nyrkio (Pedro Muniz)
UNION ALL (Jussi Saurio)
Drop Table OpCodes Use Ephemeral Table As Scratch Table (Zaid Humayun)
sqlite3-parser: Remove scanner trace-logging (Pekka Enberg)
sqlite3: Switch to tracing logger (Pekka Enberg)
CSV virtual table extension (Piotr Rżysko)
remove detection of comments in the middle of query in cli (Pedro Muniz)
btree: Remove assumption that all btrees have a rowid (Jussi Saurio)
Output rust backtrace in python tests (Preston Thorpe)
Optimization: lift common subexpressions from OR terms (Jussi Saurio)
refactor: replace Operation::Subquery with Table::FromClauseSubquery (Jussi Saurio)
Feature: Collate (Pedro Muniz)
Update README.md (Yusheng Guo)
Mark WHERE terms as consumed instead of deleting them (Jussi Saurio)
Cli config 2 (Pedro Muniz)
pager: bump default page cache size from 10 to 2000 pages (Jussi Saurio)
long fuzz tests ci on btree changes (Pere Diaz Bou)
Document how to run cargo test on Ubuntu (Zaid Humayun)
test page_free_array (Pere Diaz Bou)
Rename OwnedValue -> Value (Pekka Enberg)
Improve SQLite3 C API tests (Pekka Enberg)
github: Disable setup-node yarn cache (Pekka Enberg)
Update Unique constraint for Primary Keys and Indexes (Pedro Muniz)

Fixed

Fix LIMIT handling (Jussi Saurio)
Fix off-by-one error in max_frame after WAL load (Jussi Saurio)
btree: fix infinite looping in backwards iteration of btree table (Jussi Saurio)
Fix labeler labeling everything as Extensions-Other (Jussi Saurio)
Fix bug in op_decr_jump_zero() (Jussi Saurio)
Page cache fixes (Pere Diaz Bou)
cli/fix: Apply default config for app (Diego Reis)
Fix labeler (Jussi Saurio)
Improve debug build validation speed (Pere Diaz Bou)
optimizer: fix order by removal logic (Jussi Saurio)
Fix updating single value (Pedro Muniz)
Autoindex fix (Pedro Muniz)
use temporary db in sqlite3 wal tests to fix later tests failing (Preston Thorpe)
fix labeler correct file name extension use .yml instead of .yaml (Mohamed A. Salah)
Fix autoindex of primary key marked as unique (Pere Diaz Bou)
Fix: unique contraint in auto index creation (Pedro Muniz)

0.0.20 - 2025-05-14

Added

Support isnull and notnull expr (meteorgan)
Add drop index (Anton Harniakou)
bindings/wasm: add types property for typescript setting (오병진)
Implement transaction support in Go adapter (Jonathan Ness)
Initial implementation of ALTER TABLE RENAME (Levy A.)
Add time.Time and bool data types support in Go adapter (Jonathan Ness)
Add tests for INSERT with specified column-name list (Anton Harniakou)
GROUP BY: refactor logic to support cases where no sorting is needed (Jussi Saurio)
Add embedded library support to Go adapter (Jonathan Ness)
Add time.Time support to Go driver parameter binding (Jonathan Ness)
Show explanation for the NewRowid opcode (Anton Harniakou)
Add notion of join ordering to plan (Jussi Saurio)
Add static feature to Cargo.toml to support extensions written inside core (Pedro Muniz)
implement Clone for Arc types (Pete Hayman)
Add PRAGMA schema_version (Anton Harniakou)
Support literal-value current_time, current_date and current_timestamp (meteorgan)
Add state machine for op_idx_delete + DeleteState simplification (Pere Diaz Bou)
Add the .indexes command (Anton Harniakou)
Optimization: only initialize Rustyline if we are in a tty (Pedro Muniz)
Add Antithesis Tests (eric-dinh-antithesis)
core/types: remove duplicate serialtype implementation (Jussi Saurio)
bindings/rust: Add Statement.columns() support (Timo Kösters)
docs: add Rust to "Getting Started" section (Timo Kösters)
Support xBestIndex in vtab API (Preston Thorpe)
Feat: add support for descending indexes (Jussi Saurio)

Updated

github: Ensure rustmft is installed (Pekka Enberg)
btree: Coalesce free blocks in page_free_array() (Mohamed Hossam)
Count optimization (Pedro Muniz)
bindings/java: Remove disabled annotation for UPDATE and DELETE (Kim Seon Woo)
Refactor numeric literal (meteorgan)
EXPLAIN should show a comment for the Insert opcode (Anton Harniakou)
bindings/javascript: Improve compatibility with better-sqlite (Diego Reis)
bindings/go: Upgrade ebitengine/purego to allow for use with go 1.23.9 (Preston Thorpe)
Adjust vtab schema creation to display the underlying columns (Preston Thorpe)
Read only mode (Pedro Muniz)
Test that DROP TABLE also deletes the related indices (Anton Harniakou)
reset statement before executing in rust binding (Pedro Muniz)
Bump assorted dependencies (Preston Thorpe)
Eliminate a superfluous read transaction when doing PRAGMA user_version (Anton Harniakou)
update index on updated indexed columns (Pere Diaz Bou)
Save history on exit (Piotr Rżysko)
btree/tablebtree_move_to: micro-optimizations (Jussi Saurio)
refactor database open_file and open (meteorgan)
Give name to hard-coded page_size values (Anton Harniakou)
Performance: hoist entire expressions out of hot loops if they are constant (Jussi Saurio)
Feature: Composite Primary key constraint (Pedro Muniz)
types: refactor serialtype again to make it faster (Jussi Saurio)
replace vec with array in btree balancing (Lâm Hoàng Phúc)
Pragma page size reading (Anton Harniakou)
perf/btree: use binary search for Index seek operations (Jussi Saurio)
expr.is_nonnull(): return true if col.primary_key || col.notnull (Jussi Saurio)
Numeric Types Overhaul (Levy A.)
Python script to compare vfs performance (Preston Thorpe)
Create an automatic ephemeral index when a nested table scan would otherwise be selected (Jussi Saurio)
Bump julian_day_converter to 0.4.5 (meteorgan)
btree: avoid reading entire cell when only rowid needed (Jussi Saurio)
btree: use binary search in seek/move_to for table btrees (Jussi Saurio)
Feat: Covering indexes (Jussi Saurio)
allow index entry delete (Pere Diaz Bou)

Fixed

testing/py: rename debug_print() to run_debug() (Jussi Saurio)
Fix handling of empty strings in prepared statements (Diego Reis)
CREATE VIRTUAL TABLE fixes (Piotr Rżysko)
Bindings/Go: Fix symbols for FFI calls (Preston Thorpe)
Fix bound parameters on insert statements with out of order column indexes (Preston Thorpe)
Fix memory leak caused by unclosed virtual table cursors (Piotr Rżysko)
Fix panic on async io due to reading locked page (Preston Thorpe)
Fix bug: we cant remove order by terms from the head of the list (Jussi Saurio)
Fix setting default value for primary key on UPDATE (Pere Diaz Bou)
Fix: allow page_size=65536 (meteorgan)
Fix page_count pragma (meteorgan)
Fix broken fuzz target due to old name (Levy A.)
Emit IdxDelete instruction and some fixes on seek after deletion (Pere Diaz Bou)
Bugfix: Explain command should display syntax errors in CLI (Anton Harniakou)
Fix incorrect between expression documentation (Pedro Muniz)
Fix bug: left join null flag not being cleared (Jussi Saurio)
Fix out of bounds access on parse_numeric_str (Levy A.)
Fix post balance validation (Pere Diaz Bou)

0.0.19 - 2025-04-16

Added

Add BeginSubrtn, NotFound and Affinity bytecodes (Diego Reis)
Add Ansi Colors to tcl test runner (Pedro Muniz)
support modifiers for julianday() (meteorgan)
Implement Once and OpenAutoindex opcodes (Jussi Saurio)
Add support for OpenEphemeral bytecode (Diego Reis)
simulator: Add Bug Database(BugBase) (Alperen Keleş)
feat: Add timediff data and time function (Sachin Kumar Singh)
core/btree: Add PageContent::new() helper (Pekka Enberg)
Add support to load log file with stress test (Pere Diaz Bou)
Support UPDATE for virtual tables (Preston Thorpe)
Add .timer command to print SQL execution statistics (Pere Diaz Bou)
Strict table support (Ihor Andrianov)
Support backwards index scan and seeks + utilize indexes in removing ORDER BY (Jussi Saurio)
Add deterministic Clock (Avinash Sajjanshetty)
Support offset clause in Update queries (Preston Thorpe)
Support Create Index (Preston Thorpe)
Support insert default values syntax (Preston Thorpe)
Add support for default values in INSERT statements (Diego Reis)

Updated

Test: write tests for file backed db (Pedro Muniz)
btree: move some blocks of code to more reasonable places (Jussi Saurio)
Parse hex integers 2 (Anton Harniakou)
More index utils (Jussi Saurio)
Index utils (Jussi Saurio)
Feature: VDestroy for Dropping Virtual Tables (Pedro Muniz)
Feat balance shallower (Lâm Hoàng Phúc)
Parse hexidecimal integers (Anton Harniakou)
Code clean-ups (Diego Reis)
Return null when parameter is unbound (Levy A.)
Enhance robusteness of optimization for Binary expressions (Diego Reis)
Check that index seek key members are not null (Jussi Saurio)
Better diagnostics (Pedro Muniz)
simulator: provide high level commands on top of a single runner (Alperen Keleş)
build(deps-dev): bump vite from 6.0.7 to 6.2.6 in /bindings/wasm/test-limbo-pkg (dependabot[bot])
btree: remove IterationState (Jussi Saurio)
build(deps): bump pyo3 from 0.24.0 to 0.24.1 (dependabot[bot])
Multi column indexes + index seek refactor (Jussi Saurio)
Emit ANSI codes only when tracing is outputting to terminal (Preston Thorpe)
B-Tree code cleanups (Pekka Enberg)
btree index selection on rightmost pointer in balance_non_root (Pere Diaz Bou)
io/linux: make syscallio the default (io_uring is really slow) (Jussi Saurio)
Stress improvements (Pekka Enberg)
VDBE code cleanups (Pekka Enberg)
Memory tests to track large blob insertions (Pedro Muniz)
Setup tracing to allow output during test runs (Preston Thorpe)
allow insertion of multiple overflow cells (Pere Diaz Bou)
Properly handle insertion of indexed columns (Preston Thorpe)
VTabs: Proper handling of re-opened db files without the relevant extensions loaded (Preston Thorpe)
Account divider cell in size while distributing cells (Pere Diaz Bou)
Format infinite float as "Inf"/"-Inf" (jachewz)
update sqlite download version to 2025 + remove www. (Pere Diaz Bou)
Improve validation of btree balancing (Pere Diaz Bou)
Aggregation without group by produces incorrect results for scalars (Ihor Andrianov)
Dot command completion (Pedro Muniz)
Allow reading altered tables by defaulting to null in Column insn (Preston Thorpe)
docs(readme): update discord link (Jamie Barton)
More VDBE cleanups (Pekka Enberg)
Request load page on insert_into_page (Pere Diaz Bou)
core/vdbe: Rename execute_insn_* to op_* (Pekka Enberg)
Remove RWLock from Shared wal state (Pere Diaz Bou)
VDBE with indirect function dispatch (Pere Diaz Bou)

Fixed

Fix truncation of error output in tests (Pedro Muniz)
Fix Unary Negate Operation on Blobs (Pedro Muniz)
Fix incompatibility AND Operation (Pedro Muniz)
Fix: comment out incorrect assert in fuzz (Pedro Muniz)
Fix two issues with indexes (Jussi Saurio)
Fuzz fix some operations (Pedro Muniz)
simulator: updates to bug base, refactors (Alperen Keleş)
Fix overwrite cell with size less than cell size (Pere Diaz Bou)
Fix EXPLAIN to be case insensitive (Pedro Muniz)
core: Fix syscall VFS on Linux (Pekka Enberg)
Index insert fixes (Pere Diaz Bou)
Decrease page count on balancing fixes (Pere Diaz Bou)
Remainder fixes (jachewz)
Fix virtual table translation issues (Preston Thorpe)
Fix overflow position in write_page() (Lâm Hoàng Phúc)

0.0.18 - 2025-04-02

Added

Jsonb support update (Ihor Andrianov)
Add BTree balancing after delete (Krishna Vishal)
Introduce Register struct (Pere Diaz Bou)
Introduce immutable record (Pere Diaz Bou)
Introduce libFuzzer (Levy A.)
WAL frame checksum support (Daniel Boll)
Initial JavaScript bindings with napi-rs (Pekka Enberg)
Initial pass at UPDATE support (Preston Thorpe)
Add commit() and placeholding insert to Python binding (Diego Reis)

Updated

Create plan for Update queries (Preston Thorpe)
Validate cells inside a page after each operation (Pere Diaz Bou)
Refactor Cli Repl Commands to use clap (Pedro Muniz)
Allow balance_root to balance with interior pages (Pere Diaz Bou)
Let remainder (%) accept textual arguments (Anton Harniakou)
JSON code cleanups (Pekka Enberg)
Allocation improvements with ImmutableRecord, OwnedRecord and read_record (Pere Diaz Bou)
JavaScript binding improvements (Pekka Enberg)
Kill test environment (Pekka Enberg)
Remove public unlock method from SpinLock to prevent unsafe aliasing (Krishna Vishal)
Handle limit zero case in query plan emitter (Preston Thorpe)
Reduce MVCC cursor memory consumption (Ihor Andrianov)
Unary + is a noop (Levy A.)
JSON cache (Ihor Andrianov)
Bump rusqlite to 0.34 (Pere Diaz Bou)
core: Rename FileStorage to DatabaseFile (Pekka Enberg)
Improve Python bindings (Diego Reis)
Schema translation cleanups (Pekka Enberg)
Various JSON improvements (Ihor Andrianov)
Enable pretty mode in shell by default (Pekka Enberg)
Improve CLI color scheme (Pekka Enberg)
Impl Copy on some types in the pager to prevent explicit clones (Preston Thorpe)
Syntax highlighting and hinting (Pedro Muniz)
chore: gitignore files with an extension *.db (Anton Harniakou)
Organize extension library and feature gate VFS (Preston Thorpe)
fragment bench functions (Pere Diaz Bou)

Fixed

Remove unnecessary balance code that crashes (Pere Diaz Bou)
Fix propagation of divider cell balancing interior page (Pere Diaz Bou)
Fuzz test btree fix seeking. (Pere Diaz Bou)
Fix IdxCmp insn comparisons (Jussi Saurio)
Fixes probably all floating point math issues and floating point display issues. (Ihor Andrianov)
Make BTreeCell/read_payload not allocate any data + overflow fixes (Pere Diaz Bou)
Fix compute_shl negate with overflow (Krishna Vishal)
Fix a typo in README.md (Tshepang Mbambo)
Fix platform specific FFI C pointer type casts (Preston Thorpe)
core: Fix Destroy opcode root page handling (Pekka Enberg)
Fix SELECT 0.0 = 0 returning false (lgualtieri75)
bindings/python: Fix flaky tests (Diego Reis)
Fix io_uring WAL write corruption by ensuring buffer lifetime (Daniel Boll)

0.0.17 - 2025-03-19

Added

BEGIN DEFERRED support (Diego Reis)
Experimental MVCC integration (Pekka Enberg)
DROP TABLE support (Zaid Humayun)
Initial pass on Virtual FileSystem extension module (Preston Thorpe)
JSONB support (Ihor Andrianov)
Shell command completion (Pedro Muniz)

Updated

Fixed

Fixes and improvements to Rust bindings (yirt grek and 南宫茜)
Transaction management fixes (Pere Diaz Bou and Diego Reis)
JSON function fixes (Ihor Andrianov)

0.0.16 - 2025-03-05

Added

Virtual table support (Preston Thorpe)
Improvements to Java bindings (Kim Seon Woo)
Improvements to Rust bindings (Pekka Enberg)
Add sqlean ipaddr extension (EmNudge)
Add "dump" and "load" to the help menu (EmNudge)
Initial Antithesis testing tool (Pekka Enberg)

Fixed

SQLite B-Tree balancing algorithm (Pere Diaz Bou)
B-Tree improves and fixes (Pere Diaz Bou and Perston Thorpe)
Display blobs as blob literals in .dump (from Mohamed Hossam)
Fix wrong count() result if the column specified contains a NULL (lgualtieri75)
Fix casting text to integer to match SQLite' (Preston Thorpe)
Improve SELECT 1 performance to be on par with SQLite (Pekka Enberg)
Fix offset_sec normalization in extensions/time (meteorgan)
Handle parsing URI according to SQLite specification (Preston Thorpe)
Escape character is ignored in LIKE function (lgualtieri75)
Fix cast_text_to_number compatibility (Pedro Muniz)
Modify the LIKE function to work with all types (Mohamed Hossam)

0.0.15 - 2025-02-18

Added

Core:

Initial pass on virtual tables (Preston Thorpe)
Import MVCC code to the source tree -- not enabled (Pekka Enberg, Piotr Sarna, Avinash Sajjanshetty)
Implement json_set (Marcus Nilsson)
Initial support for WITH clauses (common table expressions) (Jussi Saurio)
BEGIN IMMEDIATE + COMMIT support (Pekka Enberg)
BEGIN EXCLUSIVE support (Pekka Enberg)
Add Printf Support (Zaid Humayun)
Add support for delete row (Krishna Vishal)
Implement json_quote (Pedro Muniz)
Add read implementation of user_version pragma with ReadCookie opcode (Jonathan Webb)
Json path refine (Ihor Andrianov)
cli: Basic dump support (Glauber Costa)
Support numeric column references in GROUP BY (Jussi Saurio)
Implement the legacy_file_format pragma (Glauber Costa)
Added IdxLE and IdxLT opcodes (Omolola Olamide)

*Java bindings:

Improve JDBC support with, for example, prepared statements (Kim Seon Woo)
Rename package name tech.turso (Kim Seon Woo)

Extensions:

Sqlean Crypto extension (Diego Reis)
Sqlean Time extension (Pedro Muniz)
Add support for regexp_replace() (lgualtieri75)

Simulator:

Add NoREC testing property (Alperen Keleş)
Add --differential mode against SQLite (Alperen Keleş)

Fixed

Core:

Fix 24/48 bit width serial types parsing (Nikita Sivukhin)
Fix substr (Nikita Sivukhin)
Fix math binary (Nikita Sivukhin)
Fix and predicate (Nikita Sivukhin)
Fix IdxGt, IdxGe, IdxLt, and IdxLe instructions (Jussi Saurio)
Fix not evaling constant conditions when no tables in query (Jussi Saurio)
Fix remainder panic on zero right-hand-side (Jussi Saurio)
Fix invalid text columns generated by dump (Kingsley Yung)
Fix incorrect CAST text->numeric if valid prefix is 1 char long (Jussi Saurio)
Improve SQL statement prepare performance (Jussi Saurio)
Fix VCC write conflict handling (Jussi Saurio)
Fix various bugs in B-Tree handling (Nikita Sivukhin)
Fix case and emit (Nikita Sivukhin)
Fix coalesce (Nikita Sivukhin)
Fix cast (Nikita Sivukhin)
Fix string funcs (Nikita Sivukhin)
Fix floating point truncation in JSON #877 (lgualtieri75)
Fix bug with SELECT referring to a mixed-case alias (Jussi Saurio)

0.0.14 - 2025-02-04

Added

Core:

Improve changes() and total_changes() functions and add tests (Ben Li)
Add support for json_object function (Jorge Hermo)
Implemented json_valid function (Harin)
Implement Not (Vrishabh)
Initial support for wal_checkpoint pragma (Sonny)
Implement Or and And bytecodes (Diego Reis)
Implement strftime function (Pedro Muniz)
implement sqlite_source_id function (Glauber Costa)
json_patch() function implementation (Ihor Andrianov)
json_remove() function implementation (Ihor Andrianov)
Implement isnull / not null for filter expressions (Glauber Costa)
Add support for offset in select queries (Ben Li)
Support returning column names from prepared statement (Preston Thorpe)
Implement Concat opcode (Harin)
Table info (Glauber Costa)
Pragma list (Glauber Costa)
Implement Noop bytecode (Pedro Muniz)
implement is and is not where constraints (Glauber Costa)
Pagecount (Glauber Costa)
Support column aliases in GROUP BY, ORDER BY and HAVING (Jussi Saurio)
Implement json_pretty (Pedro Muniz)

Extensions:

Initial pass on vector extension (Pekka Enberg)
Enable static linking for 'built-in' extensions (Preston Thorpe)

Go Bindings:

Initial support for Go database/sql driver (Preston Thorpe)
Avoid potentially expensive operations on prepare' (Glauber Costa)

Java Bindings:

Implement JDBC ResultSet (Kim Seon Woo)
Implement LimboConnection close() (Kim Seon Woo)
Implement close() for LimboStatement and LimboResultSet (Kim Seon Woo)
Implement methods in JDBC4ResultSet (Kim Seon Woo)
Load native library from Jar (Kim Seon Woo)
Change logger dependency (Kim Seon Woo)
Log driver loading error (Pekka Enberg)

Simulator:

Implement --load and --watch flags (Alperen Keleş)

Build system and CI:

Add Nyrkiö change point detection to 'cargo bench' workflow (Henrik Ingo)

Fixed

Fix select X'1'; causes limbo to go in infinite loop (Krishna Vishal)
Fix rowid search codegen (Nikita Sivukhin)
Fix logical codegen (Nikita Sivukhin)
Fix parser panic when duplicate column names are given to CREATE TABLE (Krishna Vishal)
Fix panic when double quoted strings are used for column names. (Krishna Vishal)
Fix SELECT -9223372036854775808 result differs from SQLite (Krishna Vishal)
Fix SELECT ABS(-9223372036854775808) causes limbo to panic. (Krishna Vishal)
Fix memory leaks, make extension types more efficient (Preston Thorpe)
Fix table with single column PRIMARY KEY to not create extra btree (Krishna Vishal)
Fix null cmp codegen (Nikita Sivukhin)
Fix null expr codegen (Nikita Sivukhin)
Fix rowid generation (Nikita Sivukhin)
Fix shr instruction (Nikita Sivukhin)
Fix strftime function compatibility problems (Pedro Muniz)
Dont fsync the WAL on read queries (Jussi Saurio)

0.0.13 - 2025-01-19

Added

Initial support for native Limbo extensions (Preston Thorpe)
npm packaging for node and web (Elijah Morgan)
Add support for rowid keyword' (Kould)
Add support for shift left, shift right, is and is not operators (Vrishabh)
Add regexp extension (Vrishabh)
Add counterexample minimization to simulator (Alperen Keleş)
Initial support for binding values to prepared statements (Levy A.)

Updated

Java binding improvements (Kim Seon Woo)
Reduce liblimbo_sqlite3.a size' (Pekka Enberg)

Fixed

Fix panics on invalid aggregate function arguments (Krishna Vishal)
Fix null compare operations not giving null (Vrishabh)
Run all statements from SQL argument in CLI (Vrishabh)
Fix MustBeInt opcode semantics (Vrishabh)
Fix recursive binary operation logic (Jussi Saurio)
Fix SQL comment parsing in Limbo shell (Diego Reis and Clyde)

0.0.12 - 2025-01-14

Added

Core:

Improve JSON function support (Kacper Madej, Peter Sooley)
Support nested parenthesized conditional expressions (Preston Thorpe)
Add support for changes() and total_changes() functions (Lemon-Peppermint)
Auto-create index in CREATE TABLE when necessary (Jussi Saurio)
Add partial support for datetime() function (Preston Thorpe)
SQL parser performance improvements (Jussi Saurio)

Shell:

Show pretty parse errors in the shell (Samyak Sarnayak)
Add CSV import support to shell (Vrishabh)
Selectable IO backend with --io={syscall,io-uring} argument (Jorge López Tello)

Bindings:

Initial version of Java bindings (Kim Seon Woo)
Initial version of Rust bindings (Pekka Enberg)
Add OPFS support to Wasm bindings (Elijah Morgan)
Support uncorrelated FROM clause subqueries (Jussi Saurio)
In-memory support to sqlite3_open() (Pekka Enberg)

Fixed

Make iterate() lazy in JavaScript bindings (Diego Reis)
Fix integer overflow output to be same as sqlite3 (Vrishabh)
Fix 8-bit serial type to encoding (Preston Thorpe)
Query plan optimizer bug fixes (Jussi Saurio)
B-Tree balancing fixes (Pere Diaz Bou)
Fix index seek wrong on SeekOp::LT`SeekOp::GT` (Kould)
Fix arithmetic operations for text values' from Vrishabh
Fix quote escape in SQL literals (Vrishabh)

0.0.11 - 2024-12-31

Added

Add in-memory mode to Python bindings (Jean Arhancet)
Add json_array_length function (Peter Sooley)
Add support for the UUID extension (Preston Thorpe)

Changed

Enable sqpoll by default in io_uring (Preston Thorpe)
Simulator improvements (Alperen Keleş)

Fixed

Fix escaping issues with like and glob functions (Vrishabh)
Fix sqlite_version() out of bound panics' (Diego Reis)
Fix on-disk file format bugs (Jussi Saurio)

0.0.10 - 2024-12-18

Added

In-memory mode (Preston Thorpe)
More CLI improvements (Preston Thorpe)
Add support for replace() function (Alperen Keleş)
Unary operator improvements (Jean Arhancet)
Add support for unex(x, y) function (Kacper Kołodziej)

Fixed

Fix primary key handling when there's rowid and PK is not alias (Jussi Saurio)

0.0.9 - 2024-12-12

Added

Improve CLI (Preston Thorpe)
Add support for iif() function (Alex Miller)
Add support for last_insert_rowid() function (Krishna Vishal)
Add support JOIN USING and NATURAL JOIN (Jussi Saurio)
Add support for more scalar functions (Kacper Kołodziej)
Add support for HAVING clause (Jussi Saurio)
Add get() and iterate() to JavaScript/Wasm API (Jean Arhancet)

0.0.8 - 2024-11-20

Added

Python package build and example usage (Pekka Enberg)

0.0.7 - 2024-11-20

Added

Minor improvements to JavaScript API (Pekka Enberg)
CAST support (Jussi Saurio)

Fixed

Fix issues found in-btree code with the DST (Pere Diaz Bou)

0.0.6 - 2024-11-18

Fixed

Fix database truncation caused by limbo-wasm opening file in wrong mode (Pere Diaz Bou)

0.0.5 - 2024-11-18

Added

CREATE TABLE support (Pere Diaz Bou)
Add Add Database.prepare() and Statement.all() to Wasm bindings (Pekka Enberg)
WAL improvements (Pere Diaz Bou)
Primary key index scans and single-column secondary index scans (Jussi Saurio)
GROUP BY support (Jussi Saurio)
Overflow page support (Pere Diaz Bou)
Improvements to Python bindings (Jean Arhancet and Lauri Virtanen)
Improve scalar function support (Lauri Virtanen)

Fixed

Panic in codegen with COUNT(*) (Jussi Saurio)
Fix LIKE to be case insensitive (RJ Barman)

0.0.4 - 2024-08-22

Query planner rewrite (Jussi Saurio)
Initial pass on Python bindings (Jean Arhancet)
Improve scalar function support (Kim Seon Woo and Jean Arhancet)

Added

Partial support for json() function (Jean Arhancet)

0.0.3 - 2024-08-01

Added

Initial pass on the write path. Note that the write path is not transactional yet. (Pere Diaz Bou)
More scalar functions: unicode() (Ethan Niser)
Optimize point queries with integer keys (Jussi Saurio)

Fixed

ORDER BY support for nullable sorting columns and qualified identifiers (Jussi Saurio)
Fix .schema command crash in the CLI (#212 (Jussi Saurio)

0.0.2 - 2024-07-24

Added

Partial LEFT JOIN support.
Partial ORDER BY support.
Partial scalar function support.

Fixed

Lock database file with POSIX filesystem advisory lock when database is opened to prevent concurrent processes from corrupting a file. Please note that the locking scheme differs from SQLite, which uses POSIX advisory locks for every transaction. We're defaulting to locking on open because it's faster. (Issue #94)

Changed

Install to ~/.limbo/ instead of CARGO_HOME.

0.0.1 - 2024-07-17

Added

Partial SELECT statement support, including WHERE, LIKE, LIMIT, CROSS JOIN, and INNER JOIN.
Aggregate function support.
EXPLAIN statement support.
Partial PRAGMA statement support, including cache_size.
Asynchronous I/O support with Linux io_uring using direct I/O and Darwin kqueue.
Initial pass on command line shell with following commands:

FilesExpand file tree

CHANGELOG.md

Latest commit

History

CHANGELOG.md

File metadata and controls

Changelog

0.6.0 -- 2026-05-14

Added

Updated

Fixed

0.5.0 -- 2026-03-04

Added

Updated

Fixed

0.4.0 -- 2026-01-05

Added

Updated

Fixed

Changelog

0.3.0 -- 2025-10-30

Added

Updated

Fixed

0.2.0 -- 2025-10-03

Added

Updated

Fixed

0.1.5 -- 2025-09-10

Added

Updated

Fixed

0.1.4 -- 2025-08-20

Added

Updated

Fixed

0.1.3 -- 2025-07-29

Added

Updated

Fixed

0.1.2 -- 2025-07-15

Added

Updated

Fixed

0.1.1 -- 2025-06-30

Fixed

Updated

0.1.0 -- 2025-06-30

Added

Updated

Fixed

0.0.22 -- 2025-06-19

Added

Updated

Fixed

0.0.21 - 2025-05-28

Added

Updated

Fixed

0.0.20 - 2025-05-14

Added

Updated

Fixed

0.0.19 - 2025-04-16

Added

Updated

Fixed

0.0.18 - 2025-04-02

Added

Updated

Fixed

0.0.17 - 2025-03-19

Added

Updated

Fixed

0.0.16 - 2025-03-05

Added

Fixed

0.0.15 - 2025-02-18

Added