libgsqlite
sqlite-loadable-rs
libgsqlite | sqlite-loadable-rs | |
---|---|---|
10 | 2 | |
507 | 317 | |
- | - | |
0.0 | 6.7 | |
over 1 year ago | 26 days ago | |
Rust | Rust | |
MIT License | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
libgsqlite
-
Show HN: Query Your Sheets with SheetSQL
There is similar open-source project for Google Sheets: https://github.com/0x6b/libgsqlite (SQLite extension), which is a fork of https://github.com/x2bool/xlite (same idea but for Microsoft Excel spreadsheets)
- GitHub - 0x6b/libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table.
- Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table
-
Query Google Sheets as virtual tables with SQLite extension – libgsqlite
Those setup instructions are so frustrating: https://github.com/0x6b/libgsqlite#setup-google-cloud
Why does this have to be so hard!? I really wish Google Cloud (and likewise AWS and many other providers) didn't force users to jump through so many steps to use tools like this.
- SQLite extension for querying Google Sheets as virtual tables
sqlite-loadable-rs
-
SQLiteGPT - Directly query ChatGPT with SQL functions
The implementation is just a prototype right now and it should be implemented as a proper loadable extension in Rust with sqlite-loadable-rs. Make sure to star the GitHub repo if you want to see this happen! ;-)
-
Making SQLite extensions pip install-able
It's possible but very difficult. For extensions built purely in C, you can statically compile extensions into a SQLite WASM build, which I have a few demos of with sqlite-lines [0] and sqlite-path[1].
For extensions but in Rust however, it's much more difficult. Matt @tantaman has some success cross compiling his cr-sqlite [2] project to WASM, but it's quite complex.
SQLite extensions typical rely on dlopen() to load dynamic libraries as an extension. WASM doesn't really have that, so you either have to statically compile your extension in your WASM build (which is difficult for non-C languages bc SQLite is written in C), or hack around some barely-supported WASM features that emulate dlopen(). Though I'm not the best with WASM, so hopefully someone with more WASM experience chimes in to help! It's something I'm tracking in this issue for the `sqlite-loadble-rs` project [3]
[0] https://observablehq.com/@asg017/introducing-sqlite-lines#ce...
[1] https://observablehq.com/@asg017/introducing-sqlite-path#cel...
[2] https://github.com/vlcn-io/cr-sqlite
[3] https://github.com/asg017/sqlite-loadable-rs/issues/5
What are some alternatives?
grist-core - Grist is the evolution of spreadsheets.
sqlite-ulid - A SQLite extension for generating and working with ULIDs