3 ms·
This looks super cool, very useful for some of the data science stuff I've been working with at work recently. Something I'm curious about; is it possible to u
by Jarwain 6y ago
This looks super cool, very useful for some of the data science stuff I've been working with at work recently.
Something I'm curious about; is it possible to use datasette as a sort of "sqlite browser"? Say I have users with sqlite databases with various data, but all the dbs conform to a known schema; can I use datasette to allow my users to upload their sqlite databases and browse them?
Or would I have to do something more custom, running datasette in the background against an uploaded db and serving the result to my user?
- simonw 6y agoI'm working on improvements related to this at the moment. Currently you need to run Datasette against existing SQLite databases when it starts up. Plugins like https://datasette.io/plugins/datasette-upload-csvs https://datasette.io/plugins/datasette-upload-csvs can be used to let people add new tables to those existing databases, but there isn't a mechanism to add a whole new database file without restarting the server. In the next release I hope to be able to support pointing Datasette at a directory and having any new SQLite files that are added to that directory automatically show up in the interface without having to restart the server. You can follow this issue for updates: https://github.com/simonw/datasette/issues/417 https://github.com/simonw/datasette/issues/417