libsqlhq's profile picture. Discuss libSQL at @tursodatabase.

libSQL

@libsqlhq

Discuss libSQL at @tursodatabase.

libSQL 已轉發

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! github.com/libsql/libsql/… #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: github.com/libsql/libsql/… And for sqld 0.3.3 here: github.com/libsql/sqld/re…


libSQL 已轉發

My libSQL talk from ScyllaDB Summit 2023 is available here: youtube.com/watch?v=UTpqi0… Check out all the other presentations too, the agenda was really great, thanks @ScyllaDB for having me! scylladb.com/scylladb-summi…


libSQL 已轉發

Join me in Barcelona! My talk on @libsqlhq is at 12:30, March 23rd wasmio.tech/sessions/webas…

The final agenda for #wasmio23 is now available! wasmio.tech/sessions/ Don't miss out on the opportunity to learn from the best, connect with like-minded developers, and be a part of a groundbreaking community.



libSQL 已轉發

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" wasmio.tech/sessions/webas… #wasmio23

wasm_io's tweet image. 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"

wasmio.tech/sessions/webas…

#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. blog.chiselstrike.com/sqlite-based-d…


libSQL 已轉發

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!

nanovms's tweet image. 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. blog.chiselstrike.com/webassembly-tr…


libSQL 已轉發

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: github.com/libsql/sqld 1/ 🧵

github.com

GitHub - libsql/sqld: LibSQL with extended capabilities like HTTP protocol, replication, and more.

LibSQL with extended capabilities like HTTP protocol, replication, and more. - libsql/sqld

Uh oh, these guys glued the postgres wire protocol to SQLite. Hacker news is gonna lose their collective minds



libSQL 已轉發

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

"Spanner: Google’s Globally-Distributed Database" by Corbett et al (OSDI '12) is a seminal paper from Google that I believe kick-started the last decade of distributed SQL databases such as @CockroachDB, @Yugabyte, and others. So let's dig into what the paper has to say! 🧐🧵1/

penberg's tweet image. "Spanner: Google’s Globally-Distributed Database" by Corbett et al (OSDI '12) is a seminal paper from Google that I believe kick-started the last decade of distributed SQL databases such as @CockroachDB, @Yugabyte, and others. So let's dig into what the paper has to say!

🧐🧵1/


libSQL 已轉發

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: github.com/libsql/libsql/… It is sowewhat similar to Litestream, but integrated with the database.


libSQL 已轉發

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: youtube.com/live/poA497gSs…

osdotsystem's tweet card. SQLite Internals: How The World's Most Used Database Works

youtube.com

YouTube

SQLite Internals: How The World's Most Used Database Works


libSQL 已轉發

The latest addition to @libsqlhq is just awesome! #wasm #rust #opensource #libsql


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: blog.chiselstrike.com/webassembly-fu… #WebAssembly #sqlite


libSQL 已轉發

crates.io/crates/libsql_… 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.


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: github.com/libsql/libsql/…


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. github.com/libsql/libsql/…


Loading...

Something went wrong.


Something went wrong.