sqlean

If that's the case how would the sqlite package (also part of sqlean)'s fileio work out https://github.com/nalgeon/sqlean/blob/main/docs/fileio.md fileio_read - Read file contents as a blob. fileio_scan - Read a file line by line. fileio_write - Write a blob to a file. fileio_append - Append a string to a file. fileio_mkdir - Create a directory. fileio_symlink - Create a symlink. fileio_ls - List files in a directory. If one only exposes sqlite command query access and limit certain aspects of this sqlite extension depending on the use case perhaps, I feel like this might be a good alternative as well? Edit: thinking more about it I think its for actually making sqlite interact with the filesystem and not the idea of it acting as a file system itself without too much overhead, I was thinking something like th

SQLite supports this with the help of a virtual table: https://github.com/0x09/sqlite-statement-vtab Available in sqlean: https://github.com/nalgeon/sqlean/blob/main/docs/define.md#t... And my Go driver: https://pkg.go.dev/github.com/ncruces/go-sqlite3/ext/stateme... Mine is a strict port, though admittedly, this could be improved with additional pushdown.

There are also some good libs for SQLite. This is the standard set that I use. https://github.com/nalgeon/sqlean

How do you typically deal with "missing features" from SQLite (e.g. stored procedures)? Do you use extensions like https://github.com/nalgeon/sqlean in production?

I definitely plan to! I have a much larger list of SQLite extensions I've built here: https://github.com/asg017/sqlite-ecosystem Here's a few other references you may enjoy if you wanna learn more about SQLite extensions: - The single source file for sqlite-vec: https://github.com/asg017/sqlite-vec/blob/main/sqlite-vec.c - sqlean, a project from Anton Zhiyanov which is good base of great SQLite extensions: https://github.com/nalgeon/sqlean - The official SQLite docs: https://www.sqlite.org/loadext.html - The "hello world" SQLite extension example: https://www.sqlite.org/src/file/ext/misc/rot13.c

People should check out Nalgeon's work on SQLite extensions: https://github.com/nalgeon/sqlean. It's a worthy effort.

sqlean or sqlpkg perhaps? https://github.com/nalgeon/sqlean https://sqlpkg.org/

I guess it depends on what kind of support time scale you're wanting? Popular curated extension collections like sqlean (https://github.com/nalgeon/sqlean) seem like they'll have a shelf life of many years.

The simplicity of tree-navigation in "closure" is pretty amazing: https://github.com/nalgeon/sqlean/issues/27 Given that SQLite supports huge sizes for text, you could almost use the above as a way to create an outliner, with everything stored in the database itself ...

> Can one disable json support ... Yeah, it's pretty configurable, including the JSON support. Being able to include/exclude things can be done at compile time: https://www.sqlite.org/compile.html ← lists the options for including/excluding stuff And there's a function for loading 3rd party extensions at run-time too, which itself can be turned off. :) There's a fair amount of 3rd party extensions too. eg: https://github.com/nalgeon/sqlean GIS stuff, encryption support (several varieties), Excel/ODS support, and tonnes of other things

https://github.com/nalgeon/sqlean/blob/main/docs/define.md I've been considering using that: define Anyone have any experience with it?

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 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