Skip to main content

online sql queries

If you have an online csv you can online query it like a database with https://lite.datasette.io. 

You can load data from a CSV file hosted online (provided it allows access-control-allow-origin: *) by passing that URL as a ?csv= parameter - or by clicking the "Load CSV by URL" button and pasting in a URL.

Example: https://lite.datasette.io/?csv=https://simpel.cc/comment/comments.csv#/data?sql=select+*+from+comments

Attention: simpel.cc hasn't set the server access-control-allow-origin: * so enable it temporarily w/ browser extension "CORS".

Example: https://lite.datasette.io/?csv=https://pldb.com/pldb.csv#/data?sql=select+*+from+pldb+order+by+title+asc+limit+100

That is working w/o the extension.