A significant open-source contribution from @realwasmedge folks just landed in @libsqlhq: improved memory allocation, WASI support and more efficient type translation for #wasm user-defined functions. Thanks! https://t.co/LuTwdoBPxo
#WebAssembly
We are pleased to announce new versions of core #libSQL and its server sqld.
Read the release notes for libSQL 0.2.0 here:
https://t.co/TSTFwMrCj3
And for sqld 0.3.3 here:
https://t.co/LALd7DXNCe
My libSQL talk from ScyllaDB Summit 2023 is available here: https://t.co/9IrSivfWHe
Check out all the other presentations too, the agenda was really great, thanks @ScyllaDB for having me! https://t.co/pzzpW3zy5F
Learn about @libsqlhq, a fork of SQLite, and its support for dynamic function creation and execution directly via SQL, all powered by Wasm in @sarna_dev 's talk "WebAssembly functions for your SQLite-compatible database"
https://t.co/ff8yMpD3Ub
#wasmio23
SQLite isn’t network-accessible - until now. With our fork, you can query using the Postgres wire protocol (using psql) or over HTTP. Read more about libSQL “server mode” in this post by @glscst.
https://t.co/BAzaF5MAeK
flying sqld via @libsqlhq on nanos; now you can use your embedded sql talking to a daemon that speaks postgres wire all contained on its own little vm - neat!
With libSQL, you can use database triggers with functions implemented in #Wasm to put more code closer to your data. In this post, @sarna_dev shows how this can help automate parts of a secure user registration flow for your app.
https://t.co/BgwCaXTQk7
We indeed glued SQLite to PostgreSQL wire protocol to implement a server mode for @libsqlhq! And finally the repository is in decent enough shape for us to make it open source: https://t.co/HWvENib9YW 1/ 🧵
We merged WAL virtualization by @sarna_dev patches to @libsqlhq today. It unlocks bunch of interesting use cases, but one cool thing we're working on is bottomless storage with S3: https://t.co/XTHwi65xfm It is sowewhat similar to Litestream, but integrated with the database.
I am presenting SQLite internals to the @libsqlhq community.
If you missed my #devfest talk, you can catch up tomorrow 10 00PM (GMT+4)
#opensource
You can put a reminder here:
https://t.co/lD7DSPb6qT
Our first major milestone of libSQL with #WASM user defined functions was released today as v0.1.0. @sarna_dev gives a summary of this feature in this article, along with a tool to compile #Rust code:
https://t.co/RE0QTzQjFy
#WebAssembly#sqlite
https://t.co/tGkjU0okOw is how we'll be doing WASM from Rust for @libsqlhq : All you need to do is to add a #[libsql_bindgen] proc macro (one of my favorite parts of rust, btw), and boom: you can use that function as an UDF in libsql.
Just trimmed another ~50% of Wasm module size compiled from Rust by recompiling std lib with abort on panic. The demo user-defined encryption function for #libSQL now occupies 24KiB, used to be 44KiB.
Lots of community momentum forming around adding support for WASM stored procedures in libSQL.
Take a look at this PR from @sarna_dev:
https://t.co/CmQaOorTyY
We have big plans for our fork of SQLite! Take a look at the list of open issues on GitHub to see where we're going. (Issues are listed in no particular order.)
Questions or comments? We welcome your participation.
https://t.co/YG9hcjlld7