Ability to open a SQLite database by "uploading" it

[simonw]

Not actually uploading it to the server, but opening it through the browser file open UI - like https://squoosh.app/

[simonw]

Related:

• Ability to open a database by URL #6

[psychemedia]

In this general space (getting content into a browser based app), you could also add file system access.

Elsewhere, JupyterLite was the prompt for the jupyterlab-contrib/jupyterlab-filesystem-access extension, I think.

[jsmarr]

Related: It looks like you can't use a file:/// URL to load a local sqlite db into datasette lite, which I imagine is a common use case. If someone sends you a .db file to use, you need to find a "real URL" to host it at, which may not always be easy/desirable, esp. if it's sensitive data. Wonder how much work it would be to support file:/// URLs, whether or not it comes with a "nice file picker UI" to figure out the URL (which of course would be even nicer).

[jsmarr]

As a workaround, I used the "Web server for chrome" extension to start a local web server, which also lets you explicitly set CORS headers, which seem to be working. But when I try to use the resulting URL, which loads fine in my browser and looks like http://127.0.0.1:8887/path/to/file.db it still says "That database URL could not be loaded" with no other explanation or error in the console log. Not sure why it's not working or how to fix it.