5 ms·
Author here, happy to answer questions! Simon already gave a great intro to my SQLite extensions, and I just want to point folks to Anton Zhiyanov's sqlean pro
by alexgarcia-xyz 4y ago
Author here, happy to answer questions!
Simon already gave a great intro to my SQLite extensions, and I just want to point folks to Anton Zhiyanov's sqlean project, for pure-C extensions: https://github.com/nalgeon/sqlean https://github.com/nalgeon/sqlean
Also, some of these extensions are also packaged as Datasette plugins, so you can also run `datasette install datasette-sqlite-regex` or `datasette install datasette-sqlite-ulid` to add these extension to your Datasette instances! https://docs.datasette.io/en/stable/plugins.html https://docs.datasette.io/en/stable/plugins.html
- thibautg 4y agoNice! Is Spatialite supported?
- college_physics 4y agoYes, pip installing a GIS system would be awesome!
- alexgarcia-xyz 4y agoNot yet! Spatialite is a very big and intimidating codebase that's hard to compile. I've been mulling the idea of creating several smaller GIS sqlite extensions, especially since Spatialite development is starting to get stale, but nothing to share for now.
- nsteel 4y agoHave you looked into cross-compiling those arm targets using Docker and Github Actions? I'm not familiar with the toolchain you have to use but other projects do that.
- alexgarcia-xyz 4y agoI've tried it! For Rust SQLite extensions, I'm able to use some cross compilers for some extra ARM targets on linux[0], I just haven't had the time to do it for all extensions yet. For MacOS arm builds cargo has the `aarch64-apple-darwin` target which works, but is a bit slower than expected at runtime. I've also tried zig for cross compiling C extensions on different platforms, which seemed to work ok but I've heard of some perf issues cropping up with those. [0] https://github.com/asg017/sqlite-loadable-rs/blob/main/.github/workflows/test.yaml#L43-L50 https://github.com/asg017/sqlite-loadable-rs/blob/main/.gith...