Pekka Enberg

Piotr Sarna had some rough patches to libSQL to enable VM preemption, which are beneficial for CPU isolation if a tenant is running CPU intensive queries. Let's think about adding...

SQLite extension support

1

Let's add support for extensions such as ones listed on sqllean https://antonz.org/sqlean/

Shall we do a npm package, similar to https://www.npmjs.com/package/@sqlite.org/sqlite-wasm?

We currently only have an I/O, but it's convoluted with page stuff. Let's introduce a storage layer on top of it, which WebAssembly can implement and skip the I/O layer...

Let's implement a page server that provides access to pages over remote protocol. The WebAssembly bindings will use that.

Program execution uses an interpreter now, but let's explore how much we can improve by using a dynamic assembler such as https://docs.rs/dynasm/latest/dynasm/

Add support for overflow pages.

Investigate if we can use the same TPC-H benchmarking approach as LLVMSQLite: https://github.com/KowalskiThomas/LLVMSQLite#benchmarking-with-tpc-h

The "SQL Statement Logging for Making SQLite Truly Lite" by Park et al. paper argues for logical logging, which can make SQLite writes more I/O efficient. Let's look into adopting...