[RFE] Presentation of an remote database and sharing

[saaj]

As a user of Sqliteviz,
In order to share my data and its visualisation(s) with others,
I want to be able to import/download external data and the inquiry by just following a URL to Sqliteviz, and to export/upload mine.

The URL may look something like (respective to the instance can also be localhost:8080 and so on):

https://lana-k.github.io/sqliteviz/?database=...&inquiries=...&id=id-of-the-viz-in-the-file

Where:

• database is a (CORS-enabled) URL to a SQLite database
• inquiries is a (CORS-enabled) URL to a Sqliteviz JSON inquiry file (like inquiries.json)
• id is a visualisation is the inquiries file

To make the user interaction smooth there can be an integration with GitHub Gist to automatically upload the database and config. Conversely it can be useful to also be able to open/import a GitHub Gist. CORS seems to be there as I can see Access-Control-Allow-Origin: * there.

As a similar solution for reference:

• d3.js' bl.ocks.org (https://bl.ocks.org/mbostock/3231298, https://gist.github.com/mbostock/3231298) -- GitHub Gists are used to store code, data and metadata
• DBHub (sample) -- a la GitHub for (SQLite) databases,
• Commercial services: observablehq.com, datawrapper.de