v0.0.20

Install limbo_cli 0.0.20

Install prebuilt binaries via shell script

curl --proto '=https' --tlsv1.2 -LsSf https://github.com/tursodatabase/limbo/releases/download/v0.0.20/limbo_cli-installer.sh | sh

Install prebuilt binaries via powershell script

powershell -ExecutionPolicy Bypass -c "irm https://github.com/tursodatabase/limbo/releases/download/v0.0.20/limbo_cli-installer.ps1 | iex"

Download limbo_cli 0.0.20

File	Platform	Checksum
limbo_cli-aarch64-apple-darwin.tar.xz	Apple Silicon macOS	checksum
limbo_cli-x86_64-apple-darwin.tar.xz	Intel macOS	checksum
limbo_cli-x86_64-pc-windows-msvc.zip	x64 Windows	checksum
limbo_cli-x86_64-unknown-linux-gnu.tar.xz	x64 Linux	checksum

Verifying GitHub Artifact Attestations

The artifacts in this release have attestations generated with GitHub Artifact Attestations. These can be verified by using the GitHub CLI:

gh attestation verify <file-path of downloaded artifact> --repo tursodatabase/limbo

You can also download the attestation from GitHub and verify against that directly:

gh attestation verify <file-path of downloaded artifact> --bundle <file-path of downloaded attestation>

Version 0.0.20-pre.2

Release Notes

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)

Install limbo_cli 0.0.20-pre.2

Install prebuilt binaries via shell script

curl --proto '=https' --tlsv1.2 -LsSf https://github.com/tursodatabase/limbo/releases/download/v0.0.20-pre.2/limbo_cli-installer.sh | sh

Install prebuilt binaries via powershell script

powershell -ExecutionPolicy Bypass -c "irm https://github.com/tursodatabase/limbo/releases/download/v0.0.20-pre.2/limbo_cli-installer.ps1 | iex"

Download limbo_cli 0.0.20-pre.2

File	Platform	Checksum
limbo_cli-aarch64-apple-darwin.tar.xz	Apple Silicon macOS	checksum
limbo_cli-x86_64-apple-darwin.tar.xz	Intel macOS	checksum
limbo_cli-x86_64-pc-windows-msvc.zip	x64 Windows	checksum
limbo_cli-x86_64-unknown-linux-gnu.tar.xz	x64 Linux	checksum

Verifying GitHub Artifact Attestations

The artifacts in this release have attestations generated with GitHub Artifact Attestations. These can be verified by using the GitHub CLI:

gh attestation verify <file-path of downloaded artifact> --repo tursodatabase/limbo

You can also download the attestation from GitHub and verify against that directly:

gh attestation verify <file-path of downloaded artifact> --bundle <file-path of downloaded attestation>

Version 0.0.20-pre.1

Release Notes

Added

• 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

• 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

• 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)

Install limbo_cli 0.0.20-pre.1

Install prebuilt binaries via shell script

curl --proto '=https' --tlsv1.2 -LsSf https://github.com/tursodatabase/limbo/releases/download/v0.0.20-pre.1/limbo_cli-installer.sh | sh

Install prebuilt binaries via powershell script

powershell -ExecutionPolicy Bypass -c "irm https://github.com/tursodatabase/limbo/releases/download/v0.0.20-pre.1/limbo_cli-installer.ps1 | iex"

Download limbo_cli 0.0.20-pre.1

File	Platform	Checksum
limbo_cli-aarch64-apple-darwin.tar.xz	Apple Silicon macOS	checksum
limbo_cli-x86_64-apple-darwin.tar.xz	Intel macOS	checksum
limbo_cli-x86_64-pc-windows-msvc.zip	x64 Windows	checksum
limbo_cli-x86_64-unknown-linux-gnu.tar.xz	x64 Linux	checksum

Verifying GitHub Artifact Attestations

The artifacts in this release have attestations generated with GitHub Artifact Attestations. These can be verified by using the GitHub CLI:

gh attestation verify <file-path of downloaded artifact> --repo tursodatabase/limbo

You can also download the attestation from GitHub and verify against that directly:

gh attestation verify <file-path of downloaded artifact> --bundle <file-path of downloaded attestation>

0.0.19 - 2025-04-16

Release Notes

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)

Install limbo_cli 0.0.19

Install prebuilt binaries via shell script

curl --proto '=https' --tlsv1.2 -LsSf https://github.com/tursodatabase/limbo/releases/download/v0.0.19/limbo_cli-installer.sh | sh

Install prebuilt binaries via powershell script

powershell -ExecutionPolicy Bypass -c "irm https://github.com/tursodatabase/limbo/releases/download/v0.0.19/limbo_cli-installer.ps1 | iex"

Download limbo_cli 0.0.19

File	Platform	Checksum
limbo_cli-aarch64-apple-darwin.tar.xz	Apple Silicon macOS	checksum
limbo_cli-x86_64-apple-darwin.tar.xz	Intel macOS	checksum
limbo_cli-x86_64-pc-windows-msvc.zip	x64 Windows	checksum
limbo_cli-x86_64-unknown-linux-gnu.tar.xz	x64 Linux	checksum

Verifying GitHub Artifact Attestations

The artifacts in this release have attestations generated with GitHub Artifact Attestations. These can be verified by using the GitHub CLI:

gh attestation verify <file-path of downloaded artifact> --repo tursodatabase/limbo

You can also download the attestation from GitHub and verify against that directly:

gh attestation verify <file-path of downloaded artifact> --bundle <file-path of downloaded attestation>

v0.0.19-pre.5

Install limbo_cli 0.0.19-pre.5

Install prebuilt binaries via shell script

curl --proto '=https' --tlsv1.2 -LsSf https://github.com/tursodatabase/limbo/releases/download/v0.0.19-pre.5/limbo_cli-installer.sh | sh

Install prebuilt binaries via powershell script

powershell -ExecutionPolicy Bypass -c "irm https://github.com/tursodatabase/limbo/releases/download/v0.0.19-pre.5/limbo_cli-installer.ps1 | iex"

Download limbo_cli 0.0.19-pre.5

File	Platform	Checksum
limbo_cli-aarch64-apple-darwin.tar.xz	Apple Silicon macOS	checksum
limbo_cli-x86_64-apple-darwin.tar.xz	Intel macOS	checksum
limbo_cli-x86_64-pc-windows-msvc.zip	x64 Windows	checksum
limbo_cli-x86_64-unknown-linux-gnu.tar.xz	x64 Linux	checksum

Verifying GitHub Artifact Attestations

The artifacts in this release have attestations generated with GitHub Artifact Attestations. These can be verified by using the GitHub CLI:

gh attestation verify <file-path of downloaded artifact> --repo tursodatabase/limbo

You can also download the attestation from GitHub and verify against that directly:

gh attestation verify <file-path of downloaded artifact> --bundle <file-path of downloaded attestation>

v0.0.19-pre.4

Install limbo_cli 0.0.19-pre.4

Install prebuilt binaries via shell script

curl --proto '=https' --tlsv1.2 -LsSf https://github.com/tursodatabase/limbo/releases/download/v0.0.19-pre.4/limbo_cli-installer.sh | sh

Install prebuilt binaries via powershell script

powershell -c "irm https://github.com/tursodatabase/limbo/releases/download/v0.0.19-pre.4/limbo_cli-installer.ps1 | iex"

Download limbo_cli 0.0.19-pre.4

File	Platform	Checksum
limbo_cli-aarch64-apple-darwin.tar.xz	Apple Silicon macOS	checksum
limbo_cli-x86_64-apple-darwin.tar.xz	Intel macOS	checksum
limbo_cli-x86_64-pc-windows-msvc.zip	x64 Windows	checksum
limbo_cli-x86_64-unknown-linux-gnu.tar.xz	x64 Linux	checksum

Verifying GitHub Artifact Attestations

The artifacts in this release have attestations generated with GitHub Artifact Attestations. These can be verified by using the GitHub CLI:

gh attestation verify <file-path of downloaded artifact> --repo tursodatabase/limbo

You can also download the attestation from GitHub and verify against that directly:

gh attestation verify <file-path of downloaded artifact> --bundle <file-path of downloaded attestation>

v0.0.19-pre.3

Install limbo_cli 0.0.19-pre.3

Install prebuilt binaries via shell script

curl --proto '=https' --tlsv1.2 -LsSf https://github.com/tursodatabase/limbo/releases/download/v0.0.19-pre.3/limbo_cli-installer.sh | sh

Install prebuilt binaries via powershell script

powershell -c "irm https://github.com/tursodatabase/limbo/releases/download/v0.0.19-pre.3/limbo_cli-installer.ps1 | iex"

Download limbo_cli 0.0.19-pre.3

File	Platform	Checksum
limbo_cli-aarch64-apple-darwin.tar.xz	Apple Silicon macOS	checksum
limbo_cli-x86_64-apple-darwin.tar.xz	Intel macOS	checksum
limbo_cli-x86_64-pc-windows-msvc.zip	x64 Windows	checksum
limbo_cli-x86_64-unknown-linux-gnu.tar.xz	x64 Linux	checksum

Verifying GitHub Artifact Attestations

The artifacts in this release have attestations generated with GitHub Artifact Attestations. These can be verified by using the GitHub CLI:

gh attestation verify <file-path of downloaded artifact> --repo tursodatabase/limbo

You can also download the attestation from GitHub and verify against that directly:

gh attestation verify <file-path of downloaded artifact> --bundle <file-path of downloaded attestation>

v0.0.19-pre.2

Install limbo_cli 0.0.19-pre.2

Install prebuilt binaries via shell script

curl --proto '=https' --tlsv1.2 -LsSf https://github.com/tursodatabase/limbo/releases/download/v0.0.19-pre.2/limbo_cli-installer.sh | sh

Install prebuilt binaries via powershell script

powershell -c "irm https://github.com/tursodatabase/limbo/releases/download/v0.0.19-pre.2/limbo_cli-installer.ps1 | iex"

Download limbo_cli 0.0.19-pre.2

File	Platform	Checksum
limbo_cli-aarch64-apple-darwin.tar.xz	Apple Silicon macOS	checksum
limbo_cli-x86_64-apple-darwin.tar.xz	Intel macOS	checksum
limbo_cli-x86_64-pc-windows-msvc.zip	x64 Windows	checksum
limbo_cli-x86_64-unknown-linux-gnu.tar.xz	x64 Linux	checksum

Verifying GitHub Artifact Attestations

The artifacts in this release have attestations generated with GitHub Artifact Attestations. These can be verified by using the GitHub CLI:

gh attestation verify <file-path of downloaded artifact> --repo tursodatabase/limbo

You can also download the attestation from GitHub and verify against that directly:

gh attestation verify <file-path of downloaded artifact> --bundle <file-path of downloaded attestation>

0.0.18 - 2025-04-02

Release Notes

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)

Install limbo_cli 0.0.18

Install prebuilt binaries via shell script

curl --proto '=https' --tlsv1.2 -LsSf https://github.com/tursodatabase/limbo/releases/download/v0.0.18/limbo_cli-installer.sh | sh

Install prebuilt binaries via powershell script

powershell -c "irm https://github.com/tursodatabase/limbo/releases/download/v0.0.18/limbo_cli-installer.ps1 | iex"

Download limbo_cli 0.0.18

File	Platform	Checksum
limbo_cli-aarch64-apple-darwin.tar.xz	Apple Silicon macOS	checksum
limbo_cli-x86_64-apple-darwin.tar.xz	Intel macOS	checksum
limbo_cli-x86_64-pc-windows-msvc.zip	x64 Windows	checksum
limbo_cli-x86_64-unknown-linux-gnu.tar.xz	x64 Linux	checksum

Verifying GitHub Artifact Attestations

The artifacts in this release have attestations generated with GitHub Artifact Attestations. These can be verified by using the GitHub CLI:

gh attestation verify <file-path of downloaded artifact> --repo tursodatabase/limbo

You can also download the attestation from GitHub and verify against that directly:

gh attestation verify <file-path of downloaded artifact> --bundle <file-path of downloaded attestation>

v0.0.18-pre.5

Install limbo_cli 0.0.18-pre.5

Install prebuilt binaries via shell script

curl --proto '=https' --tlsv1.2 -LsSf https://github.com/tursodatabase/limbo/releases/download/v0.0.18-pre.5/limbo_cli-installer.sh | sh

Install prebuilt binaries via powershell script

powershell -c "irm https://github.com/tursodatabase/limbo/releases/download/v0.0.18-pre.5/limbo_cli-installer.ps1 | iex"

Download limbo_cli 0.0.18-pre.5

File	Platform	Checksum
limbo_cli-aarch64-apple-darwin.tar.xz	Apple Silicon macOS	checksum
limbo_cli-x86_64-apple-darwin.tar.xz	Intel macOS	checksum
limbo_cli-x86_64-pc-windows-msvc.zip	x64 Windows	checksum
limbo_cli-x86_64-unknown-linux-gnu.tar.xz	x64 Linux	checksum

Verifying GitHub Artifact Attestations

The artifacts in this release have attestations generated with GitHub Artifact Attestations. These can be verified by using the GitHub CLI:

gh attestation verify <file-path of downloaded artifact> --repo tursodatabase/limbo

You can also download the attestation from GitHub and verify against that directly:

gh attestation verify <file-path of downloaded artifact> --bundle <file-path of downloaded attestation>