libsql

libsql copied to clipboard

It would be more ergonomic for many developers, me included, to have a test suite based on the Rust toolchain. We can start with a basic set of tests which...

psarna

Drop .fossil-settings

5

We don't use Fossil nor plan to, so drop the config.

penberg

btree: virtualize page allocation methods

5

This commit abstracts away page allocation methods, originally based on a simple freelist persisted at offset 32 with its size stored at offset 36 in the page header. The new...

psarna

Adapt read and write paths to async I/O

3

SQLite already exposes an interface quite friendly to asynchronous I/O, because `sqlite3_step` function used to proceed with `sqlite3_stmt` (https://www.sqlite.org/c3ref/stmt.html) state machine is capable of returning `SQLITE_BUSY` or other error types...

psarna

Push free page management down to the VFS layer

10

SQLite uses a freelist to manage free pages. This is a major source of INSERT contention when using an optimistic lock-free storage layer, like [mvSQLite](https://github.com/losfair/mvsqlite). Ideally we should push free...

losfair

Described by @xfbs in https://github.com/libsql/libsql/discussions/8#discussioncomment-3798887 The idea is to allow people to code more complex check expressions in any language compilable to WebAssembly and have an interface which makes it...

psarna

WebAssembly modules are seldom coded by hand. Instead, Rust, C++, AssemblyScript and any other language compilable to Wasm is used for that purpose. In order to facilitate creating user-defined functions...

psarna

Use random ROWID for inserted rows

2

With an optimistic VFS, sequentially increasing ROWIDs is a primary source of contention, and causes significant INSERT slowdown in [my benchmark](https://univalence.me/posts/mvsqlite-bench-20220930). We should provide a table-level option to allocate ROWIDs...

losfair

Users, access restrictions, GRANT etc

2

sqlite has no access restrictions, it is assumed that anyone with access to the OS, has access to the data. In a distributed system, we might want to add some...

dyasny

Provide replication hooks for distributing data

1

Historically (e.g. https://sqlite-users.sqlite.narkive.com/FsbiDRYS/sqlite-dqlite-sqlite-replication-and-failover-library) sqlite requires a few patches in order to facilitate replicating the data via Raft or another consensus protocol. This umbrella issue is here to discuss what kinds...

psarna