3 ms·
This is such a huge step forward for the usability of custom SQLite extensions in Python world. Alex has a whole family of SQLite extensions that he's built in
by simonw 4y ago
This is such a huge step forward for the usability of custom SQLite extensions in Python world.
Alex has a whole family of SQLite extensions that he's built in Rust which are worth checking out:
- sqlite-xsv: https://github.com/asg017/sqlite-xsv https://github.com/asg017/sqlite-xsv
- sqlite-fastrand: https://github.com/asg017/sqlite-fastrand https://github.com/asg017/sqlite-fastrand
- sqlite-ulid: https://github.com/asg017/sqlite-ulid https://github.com/asg017/sqlite-ulid
- sqlite-jsonschema: https://github.com/asg017/sqlite-jsonschema https://github.com/asg017/sqlite-jsonschema
- sqlite-regex: https://github.com/asg017/sqlite-regex https://github.com/asg017/sqlite-regex
- sqlite-url: https://github.com/asg017/sqlite-url https://github.com/asg017/sqlite-url
- sqlite-http: https://github.com/asg017/sqlite-http https://github.com/asg017/sqlite-http
- sqlite-lines: https://github.com/asg017/sqlite-lines https://github.com/asg017/sqlite-lines
- sqlite-path: https://github.com/asg017/sqlite-path https://github.com/asg017/sqlite-path
- sqlite-html: https://github.com/asg017/sqlite-html https://github.com/asg017/sqlite-html
- beckingz 4y agoSo how soon do we get sqlite extensions in the browser with WASM?
- alexgarcia-xyz 4y agoIt'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#cell-8 https://observablehq.com/@asg017/introducing-sqlite-lines#ce... [1] https://observablehq.com/@asg017/introducing-sqlite-path#cell-10 https://observablehq.com/@asg017/introducing-sqlite-path#cel... [2] https://github.com/vlcn-io/cr-sqlite https://github.com/vlcn-io/cr-sqlite [3] https://github.com/asg017/sqlite-loadable-rs/issues/5 https://github.com/asg017/sqlite-loadable-rs/issues/5
- deleted 4y ago[deleted]