1 Release published by 1 person

• v0.0.14 0.0.14 - 2025-02-04

  published Feb 4, 2025

47 Pull requests merged by 14 people

• core: Switch to parking_lot for RwLock

  #887 merged Feb 4, 2025

• github: Fix Python release workflow

  #883 merged Feb 4, 2025

• core: Fix benchmark panic if syscall is interrupted

  #882 merged Feb 4, 2025

• Sqlean Time extension

  #854 merged Feb 4, 2025

• Adding checkpoint result

  #827 merged Feb 4, 2025

• Add Printf Support

  #886 merged Feb 4, 2025

• Support column aliases in GROUP BY, ORDER BY and HAVING

  #864 merged Feb 4, 2025

• Improve in-memory IO performance, remove runtime borrow checking

  #861 merged Feb 4, 2025

• implement json_pretty

  #860 merged Feb 4, 2025

• core: Kill Statement::query() method

  #880 merged Feb 4, 2025

• dont store insn comments unless the query is EXPLAIN

  #875 merged Feb 4, 2025

• Lower ownership requirement for Value

  #838 merged Feb 4, 2025

• Fix logical codegen

  #869 merged Feb 3, 2025

• bindings/go: Add error propagation from core

  #855 merged Feb 3, 2025

• bindings/java: Load native library from jar

  #862 merged Feb 3, 2025

• bindings/java: Change logger dependency

  #863 merged Feb 3, 2025

• core/translate: refactor query planner again to be simpler

  #853 merged Feb 3, 2025

• Fix null cmp codegen

  #856 merged Feb 2, 2025

• Fix null expr codegen

  #857 merged Feb 2, 2025

• Pagecount

  #819 merged Feb 2, 2025

• implement is and is not where constraints

  #847 merged Feb 1, 2025

• Remove labeler 😥

  #852 merged Feb 1, 2025

• Full flake overhaul

  #835 merged Feb 1, 2025

• Simplify bytecode emitters

  #844 merged Feb 1, 2025

• update compat list

  #846 merged Feb 1, 2025

• github: Configure labeler workflow environment

  #848 merged Feb 1, 2025

• Fix table with single column PRIMARY KEY to not create extra btree

  #830 merged Jan 31, 2025

• Pragma list

  #841 merged Jan 31, 2025

• Table info

  #837 merged Jan 31, 2025

• Refactor cursor to support multiple state machines

  #836 merged Jan 31, 2025

• Performance test side by side comparison with rusqlite

  #839 merged Jan 31, 2025

• Make query_pragma use enum instead of &str

  #834 merged Jan 30, 2025

• add compat statement about CreateBTree opcode

  #833 merged Jan 30, 2025

• bindings/go Support blob types in query arguments, free non-gc allocations

  #822 merged Jan 30, 2025

• Strftime compatibility solved

  #792 merged Jan 30, 2025

• Add support for offset in select queries

  #779 merged Jan 30, 2025

• Fix SELECT ABS(-9223372036854775808) causes limbo to panic.

  #818 merged Jan 30, 2025

• Fix SELECT -9223372036854775808 result differs from SQLite

  #814 merged Jan 30, 2025

• json_remove() function implementation

  #828 merged Jan 30, 2025

• Fix labeler.yml

  #825 merged Jan 30, 2025

• json_patch() function implementation

  #821 merged Jan 29, 2025

• bindings/go: Progress on Go driver, first working incremental state

  #796 merged Jan 29, 2025

• bindings/java: Implement methods in JDBC4ResultSet

  #813 merged Jan 29, 2025

• implement sqlite_source_id function

  #811 merged Jan 29, 2025

• update COMPAT matrix for journal_mod pragma

  #809 merged Jan 29, 2025

• bindings/go: Avoid potentially expensive operations on prepare

  #808 merged Jan 29, 2025

• Initial pass on vector extension

  #798 merged Jan 29, 2025

6 Pull requests opened by 6 people

• Finish Virtual tables

  #858 opened Feb 2, 2025

• Small perf optimizations to statement preparation

  #872 opened Feb 3, 2025

• simulator: test the simulator via manual mutation injection

  #874 opened Feb 3, 2025

• Implement `json_set`

  #878 opened Feb 3, 2025

• Fix `Parser` continuing to parse after encountering an error

  #879 opened Feb 3, 2025

• clarify README and future plans

  #890 opened Feb 5, 2025

13 Issues closed by 3 people

• We cannnot use aliased column in group by clause

  #744 closed Feb 4, 2025

• Don't allocate comments while translating statement unless query is an EXPLAIN

  #784 closed Feb 4, 2025

• Nested logical expression fail

  #662 closed Feb 2, 2025

• nonexistent functions in select clause result columns are ignored

  #573 closed Feb 2, 2025

• Rowid is not supported in WHERE clause

  #241 closed Feb 2, 2025

• Offset is not supported on limbo

  #739 closed Feb 2, 2025

• OR behavior seems broken

  #850 closed Feb 2, 2025

• Limbo files have a different count of pages than sqlite

  #824 closed Jan 31, 2025

• Make `query_pragma` use enum instead of `&str`

  #823 closed Jan 30, 2025

• Strftime incompatibility

  #787 closed Jan 30, 2025

• `SELECT ABS(-9223372036854775808)` causes limbo to panic

  #815 closed Jan 30, 2025

• `SELECT -9223372036854775808` result differs from SQLite

  #812 closed Jan 30, 2025

• JSON Parser: Duplicate keys behavior differs from SQLite spec

  #805 closed Jan 30, 2025

10 Issues opened by 5 people

• Internal WAL read-write lock is very expensive

  #889 opened Feb 4, 2025

• Support For printf Function

  #885 opened Feb 4, 2025

• Strict table support

  #884 opened Feb 4, 2025

• Record parsing is too low level

  #881 opened Feb 4, 2025

• floating point numbers get truncated in json

  #877 opened Feb 3, 2025

• `VALUES` statements are not supported

  #866 opened Feb 2, 2025

• Parser does not stop on first syntax error in shell

  #865 opened Feb 2, 2025

• Support persisting in-memory database to disk

  #859 opened Feb 2, 2025

• BETWEEN operator generates different bytecode than SQLite

  #851 opened Feb 1, 2025

• Vector search with DiskANN

  #832 opened Jan 30, 2025

84 Unresolved conversations

Sometimes conversations happen on old items that aren’t yet closed. Here is a list of all the Issues and Pull Requests with unresolved conversations.

• Implement json_quote

  #763 commented on Feb 4, 2025 • 6 new comments

• simulator: add more properties and make the generated queries more complex

  #793 commented on Feb 3, 2025 • 5 new comments

• Add support for OpenEphemeral bytecode

  #768 commented on Feb 4, 2025 • 5 new comments

• Elijah/add web interface

  #759 commented on Feb 2, 2025 • 0 new comments

• Feature: per-connection memory allocator configuration

  #523 commented on Jan 30, 2025 • 0 new comments

• Mobibench fails to run with Limbo

  #522 commented on Jan 30, 2025 • 0 new comments

• Make iterate() lazy in JavaScript API

  #514 commented on Jan 30, 2025 • 0 new comments

• Support predicate pull-up optimization rule for limbo optimizer

  #513 commented on Jan 30, 2025 • 0 new comments

• Async Python Library

  #508 commented on Jan 30, 2025 • 0 new comments

• support for DATE, TIMESTAMP, and TIMESTAMP WITH TIMEZONE

  #500 commented on Jan 30, 2025 • 0 new comments

• Foreign Data Wrappers-like API?

  #489 commented on Jan 30, 2025 • 0 new comments

• Add support for sqlite3_get_table() API

  #479 commented on Jan 30, 2025 • 0 new comments

• Add support for sqlite3_wal_checkpoint_*()

  #478 commented on Jan 30, 2025 • 0 new comments

• Limbo does not enforce primary key uniqueness on PKs that are not rowid aliases

  #472 commented on Jan 30, 2025 • 0 new comments

• Delete Row support needed

  #455 commented on Jan 30, 2025 • 0 new comments

• `Add` is not compatible with sqlite

  #447 commented on Jan 30, 2025 • 0 new comments

• Make Limbo core `no_std`

  #442 commented on Jan 30, 2025 • 0 new comments

• Datetime test has a race condition?

  #439 commented on Jan 30, 2025 • 0 new comments

• TCL test on insert misbehaves

  #434 commented on Jan 30, 2025 • 0 new comments

• big blob (INSERT INTO t VALUES (zeroblob(1024 * 1024 - 1),...) overflow page error

  #406 commented on Jan 30, 2025 • 0 new comments

• Cleanup opcode definitions

  #393 commented on Jan 30, 2025 • 0 new comments

• WebContainer support?

  #380 commented on Jan 30, 2025 • 0 new comments

• Key-value interface?

  #375 commented on Jan 30, 2025 • 0 new comments

• Stub clock

  #586 commented on Feb 4, 2025 • 0 new comments

• Raise error on non-resolution of function

  #576 commented on Jan 31, 2025 • 0 new comments

• Investigate possibility of loading the system ICU libs and data to inherit localization updates

  #622 commented on Feb 5, 2025 • 0 new comments

• Performance regression in `SELECT 1`

  #780 commented on Feb 4, 2025 • 0 new comments

• Switch to deterministic clock

  #603 commented on Feb 4, 2025 • 0 new comments

• Support modifiers for UnixEpoch and JulianDay functions

  #602 commented on Feb 4, 2025 • 0 new comments

• Compatibility tests compilation fail with fatal error: sqlite3.h: No such file or directory

  #579 commented on Feb 3, 2025 • 0 new comments

• Are there any plans to have a package for Golang? (I'd love to help with that too)

  #506 commented on Feb 3, 2025 • 0 new comments

• Switch to IOCP API on Windows for asynchronous I/O

  #41 commented on Feb 3, 2025 • 0 new comments

• Subquery support

  #34 commented on Feb 3, 2025 • 0 new comments

• Clickbench support

  #738 commented on Feb 2, 2025 • 0 new comments

• Add support for Java bindings

  #615 commented on Feb 2, 2025 • 0 new comments

• Stack overflow [Windows]

  #590 commented on Feb 2, 2025 • 0 new comments

• optimizer: use covering indexes

  #364 commented on Feb 1, 2025 • 0 new comments

• [Extensions] support for wasm targets

  #692 commented on Jan 31, 2025 • 0 new comments

• Limbo crashes on colab

  #494 commented on Jan 31, 2025 • 0 new comments

• Wal checkpoint support

  #696 commented on Jan 30, 2025 • 0 new comments

• creating two tables sometimes corrupts database

  #532 commented on Jan 30, 2025 • 0 new comments

• Adding support for changes() & total_changes() as mentioned in COMPAT.md

  #525 commented on Jan 30, 2025 • 0 new comments

• Schema manipulation support

  #126 commented on Jan 30, 2025 • 0 new comments

• Indexing lookup support

  #125 commented on Jan 30, 2025 • 0 new comments

• External sorting for `ORDER BY`

  #91 commented on Jan 30, 2025 • 0 new comments

• `BEGIN CONCURRENT` support

  #86 commented on Jan 30, 2025 • 0 new comments

• SQLite C API improvements

  #85 commented on Jan 30, 2025 • 0 new comments

• Profile-Guided Optimization (PGO) benchmark report

  #78 commented on Jan 30, 2025 • 0 new comments

• Port SQLite TCL tests

  #62 commented on Jan 30, 2025 • 0 new comments

• OpenDAL support for storage?

  #57 commented on Jan 30, 2025 • 0 new comments

• In-memory mode

  #53 commented on Jan 30, 2025 • 0 new comments

• libuv example

  #48 commented on Jan 30, 2025 • 0 new comments

• Checksums?

  #38 commented on Jan 30, 2025 • 0 new comments

• TPC-H support

  #36 commented on Jan 30, 2025 • 0 new comments

• Parse record values lazily in `Column` op?

  #30 commented on Jan 30, 2025 • 0 new comments

• Encryption at rest?

  #21 commented on Jan 30, 2025 • 0 new comments

• VM preemption?

  #20 commented on Jan 30, 2025 • 0 new comments

• Native code generation for prepared SQL statements?

  #9 commented on Jan 30, 2025 • 0 new comments

• SQLite extension support

  #8 commented on Jan 30, 2025 • 0 new comments

• Fuzz testing

  #6 commented on Jan 30, 2025 • 0 new comments

• TPC-H benchmarking

  #4 commented on Jan 30, 2025 • 0 new comments

• Logical logging?

  #2 commented on Jan 30, 2025 • 0 new comments

• Limbo package does not load on WebContainers

  #697 commented on Jan 29, 2025 • 0 new comments

• Sparse database files?

  #374 commented on Jan 30, 2025 • 0 new comments

• Extended in-memory mode

  #373 commented on Jan 30, 2025 • 0 new comments

• FTS5 support

  #346 commented on Jan 30, 2025 • 0 new comments

• Shared page cache support?

  #318 commented on Jan 30, 2025 • 0 new comments

• Schema migrations improvements over SQLite

  #303 commented on Jan 30, 2025 • 0 new comments

• Improve I/O efficiency with WebAssembly on Node

  #271 commented on Jan 30, 2025 • 0 new comments

• Indexing support for write path

  #239 commented on Jan 30, 2025 • 0 new comments

• Preparing a statement is slower than with SQLite

  #220 commented on Jan 30, 2025 • 0 new comments

• Simulator improvements

  #207 commented on Jan 30, 2025 • 0 new comments

• Page readahead

  #203 commented on Jan 30, 2025 • 0 new comments

• Double-quoted String Literals in function

  #196 commented on Jan 30, 2025 • 0 new comments

• `ORDER BY` is much slower compared to SQLite

  #191 commented on Jan 30, 2025 • 0 new comments

• window function support

  #177 commented on Jan 30, 2025 • 0 new comments

• rusqlite benchmark crashes on m1 mac

  #174 commented on Jan 30, 2025 • 0 new comments

• Query planning / query rewriting / join reordering etc.

  #169 commented on Jan 30, 2025 • 0 new comments

• Support `PRAGMA automatic_index`

  #164 commented on Jan 30, 2025 • 0 new comments

• Add `cargo-dist` packaging for `limbo` and `liblimbo_sqlite3.a`

  #162 commented on Jan 30, 2025 • 0 new comments

• Don't output real affinity when translating conditions

  #161 commented on Jan 30, 2025 • 0 new comments

• Scalar function support

  #144 commented on Jan 30, 2025 • 0 new comments

• Make I/O completion explicit

  #135 commented on Jan 30, 2025 • 0 new comments

• CPython support

  #128 commented on Jan 30, 2025 • 0 new comments