I'm going to think about how Datasette Apps can work with the apps themselves stored on a filesystem so they can be revision controlled using Git.
replyI have an idea for a way to edit them through Datasette and have them backed up to Git via a separate mechanism, but having them on disk would be a whole lot more convenient.
Filed an issue here: https://github.com/datasette/datasette-apps/issues/30
Interesting idea, I know there's the fsdir [0] table-valued function / module that allows loading from disk, so it should be possible to modify that or hard-code base list of paths or something
reply[0] https://sqlite.org/src/file/ext/misc/fileio.c, it allows you to read a directory recursively in the cli (`select * from fsdir("./");`)
Edit: It allows upwards traversals (`select * from fsdir("../../../../etc/passwd");`), so beware
Wow, I didn't know about that one. SQLite never ceases to surprise.
replyI'm sticking with the Python bundled sqlite3 though so I'm not in a good place to take advantage of that one.
It's probably out of scope for you, but I've used the 'vtfunc' module [0] for a similar purpose actually.
reply> it keeps your app and data in one place (I remember having some issue with this at the time, though I can't remember what the actual issue was)
replyCORS headers?
This seems to attractive side of seeing it, however the striping Json would not be suitable i believe
reply[flagged]
reply