libSQL

Discuss libSQL at @tursodatabase.

[Piotr Sarna @sarna_dev]

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

[libSQL @libsqlhq]

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

[Piotr Sarna @sarna_dev]

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

[Piotr Sarna @sarna_dev]

Join me in Barcelona! My talk on @libsqlhq is at 12:30, March 23rd
https://t.co/AMwwDhDcOQ

[Wasm I/O @wasm_io]

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

[libSQL @libsqlhq]

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

[NanoVMs @nanovms]

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!

[libSQL @libsqlhq]

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

[Pekka Enberg @penberg]

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/ 🧵

[Piotr Sarna @sarna_dev]

Some thoughts about Spanner’s distributed database architecture from @libsqlhq contributor @penberg

[Pekka Enberg @penberg]

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.

[libSQL @libsqlhq]

Thanks to @lucasvillareal for this optimization to libSQL! Community contributions are an important part of our mission.

https://t.co/5kkoXZCYX2

[gh: Abdur-RahmaanJ @osdotsystem]

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

[gh: Abdur-RahmaanJ @osdotsystem]

The latest addition to @libsqlhq is just awesome!

#wasm #rust #opensource #libsql

[libSQL @libsqlhq]

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

[Glauber Costa @glcst]

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.

[Piotr Sarna @sarna_dev]

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.

[libSQL @libsqlhq]

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

[Star History @StarHistoryHQ]

1.3K ⭐️ libSQL (@libsqlhq) is an #OpenSource, open contribution fork of SQLite.
https://t.co/r0I6Bs82iB

https://t.co/5rGOmUPmZt

#starhistory #GitHub #SQL
via @StarHistoryHQ

[libSQL @libsqlhq]

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