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.
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…
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…
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/ 🧵
"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/
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.
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.
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/…
17K Followers 318 FollowingSpin up billions of databases. One per agent, one per user. Fully compatible with SQLite, and soon... Postgres!
https://t.co/LsugLYx8qw
https://t.co/Zn4AwNBEVp
68 Followers 592 FollowingFull stack typescript developer with designer and product manager background.
Enjoy Astro, Tanstack.
Learning marketing and business.
Open to work. Remotely ✉️
2K Followers 3K FollowingWorking to build a global digital immune system for Earth & Humanity — the Internet of Impacts @ixoworld | Seeker of Serendipity
485 Followers 4K FollowingLife is simply complicated. If I’m talking to myself I’m having a team meeting 🤫 leading by learning while counting to infinity… #fullstack #data #engineer 🦀
289 Followers 3K FollowingZero deps. Zero ceremony. All the rage. No build, on-premise, tunnels 👌. 0x28y in the industry. Use that experience. Biker, jogger, DIY Chef, mushroom picker.
22 Followers 1K FollowingStrong passion for Data and using it to tell stories and make predictions through building Dashboards and performing Data analysis.
6K Followers 2K FollowingRemote desktop protocol expert, OSS contributor and Microsoft MVP. I love designing products with Rust, C# and PowerShell. Proud to be CTO at Devolutions. 🇨🇦