@libsqlhq

Discuss libSQL at @tursodatabase.

libsql.org
Joined October 2022
  • Tweets21
  • Following4
  • Followers803
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/pul… #WebAssembly

Optimize the wasm memory allocation mode by L-jasmine · Pull Request #145 · tursodatabase/libsql

About fix: load wasi_nn plugin: On WasmEdge 0.11.2 . When load wasi_nn plugin, we need call WasmEdge_ConfigureAddHostRegistration(ConfCxt, WasmEdge_HostRegistration_WasiNN);. But On WasmEdge 0.12.0...

github.com
6
2
24
6,478
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/rel… And for sqld 0.3.3 here: github.com/libsql/sqld/relea…
1
2
1
16
2,542
My libSQL talk from ScyllaDB Summit 2023 is available here: youtube.com/watch?v=UTpqi00M… Check out all the other presentations too, the agenda was really great, thanks @ScyllaDB for having me! scylladb.com/scylladb-summit…
3
20
2,361
Join me in Barcelona! My talk on @libsqlhq is at 12:30, March 23rd wasmio.tech/sessions/webasse…
Wasm I/O@wasm_io15 Feb 2023
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.
1
1
3
1,982
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/webasse… #wasmio23
7
1
18
3,185
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…
1
8
6
41
14,142
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!
2
1
17
3,271
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/webass…
5
6
24
6,398
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 - libsql/sqld: LibSQL with extended capabilities like HTTP protocol, replication, and more.

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

github.com
Pete Hunt 🚁
@floydophone2 Dec 2022
Uh oh, these guys glued the postgres wire protocol to SQLite. Hacker news is gonna lose their collective minds
9
47
8
242
108,970
Some thoughts about Spanner’s distributed database architecture from @libsqlhq contributor @penberg
Pekka Enberg
@penberg29 Dec 2022
"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/
1
3
933
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/pul… It is sowewhat similar to Litestream, but integrated with the database.

Integrate bottomless WAL: automatic replication to S3-compatible storage by psarna · Pull Request...

This patchset integrates libSQL with https://github.com/libsql/bottomless - an optional extension which adds transparent automatic replication to S3-compatible storage. It only works in WAL mode, b...

github.com
4
5
32
4,219
Thanks to @lucasvillareal for this optimization to libSQL! Community contributions are an important part of our mission. github.com/libsql/libsql/pul…

Let virtual table implementations know which SQL string is being executed by lucasvr · Pull Request...

SQLite provides an interface to expose different data sources (such as files or other database systems) as virtual tables. There are several callbacks one must implement to enable e.g., connection ...

github.com
1
1
7
484
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-4…

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

This session is for you if you want to understand SQLite in depth! ...

youtube.com
4
1
12
1,107
The latest addition to @libsqlhq is just awesome! #wasm #rust #opensource #libsql
2
3
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/webass… #WebAssembly #sqlite
6
1
18
crates.io/crates/libsql_bind… 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.
2
7
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.
1
3
1
12
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/pul…

Allow registering and executing WebAssembly functions by psarna · Pull Request #45 · tursodatabas...

This series implements a mechanism for registering and running Wasm functions. The current runtime of choice is wasmtime and its libwasmtime.so library with C bindings (but a switch to Rust should ...

github.com
2
4
1.3K ⭐️ libSQL (@libsqlhq) is an #OpenSource, open contribution fork of SQLite. star-history.com/#libsql/lib… github.com/libsql/libsql #starhistory #GitHub #SQL via @StarHistoryHQ
3
5
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/iss…

Issues · tursodatabase/libsql

libSQL is a fork of SQLite that is both Open Source, and Open Contributions. - Issues · tursodatabase/libsql

github.com
2
4
Load more