2 ms·

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. I have an id

by simonw 4mo ago

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. I 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 https://github.com/datasette/datasette-apps/issues/30

anitil 4mo ago
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 [0] https://sqlite.org/src/file/ext/misc/fileio.c 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
- simonw 4mo ago
  Wow, I didn't know about that one. SQLite never ceases to surprise. I'm sticking with the Python bundled sqlite3 though so I'm not in a good place to take advantage of that one.
  - anitil 4mo ago
    It's probably out of scope for you, but I've used the 'vtfunc' module [0] for a similar purpose actually. [0] https://github.com/coleifer/sqlite-vtfunc https://github.com/coleifer/sqlite-vtfunc
ramses0 4mo ago
nee: couchapps https://railsware.com/blog/couchdb-and-couchapp-part-1/amp/#:~:text=CouchApp%20%E2%80%93%20feel%20power%20of%20JavaScript%20in%20CouchDB https://railsware.com/blog/couchdb-and-couchapp-part-1/amp/#... https://couchapp.readthedocs.io/en/latest/couchapp/gettingstarted.html#init-your-application https://couchapp.readthedocs.io/en/latest/couchapp/gettingst... https://couchapp.readthedocs.io/en/latest/user/list-of-couchapps.html https://couchapp.readthedocs.io/en/latest/user/list-of-couch...

by simonw 4mo ago

anitil 4mo ago

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 [0] https://sqlite.org/src/file/ext/misc/fileio.c 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

simonw 4mo ago
Wow, I didn't know about that one. SQLite never ceases to surprise. I'm sticking with the Python bundled sqlite3 though so I'm not in a good place to take advantage of that one.
- anitil 4mo ago
  It's probably out of scope for you, but I've used the 'vtfunc' module [0] for a similar purpose actually. [0] https://github.com/coleifer/sqlite-vtfunc https://github.com/coleifer/sqlite-vtfunc

ramses0 4mo ago

nee: couchapps https://railsware.com/blog/couchdb-and-couchapp-part-1/amp/#:~:text=CouchApp%20%E2%80%93%20feel%20power%20of%20JavaScript%20in%20CouchDB https://railsware.com/blog/couchdb-and-couchapp-part-1/amp/#... https://couchapp.readthedocs.io/en/latest/couchapp/gettingstarted.html#init-your-application https://couchapp.readthedocs.io/en/latest/couchapp/gettingst... https://couchapp.readthedocs.io/en/latest/user/list-of-couchapps.html https://couchapp.readthedocs.io/en/latest/user/list-of-couch...