Datasette Lite
It’s Datasette… running entirely in your web browser with WebAssembly and Pyodide!
Loading SQLite, CSV and JSON data
SQLite: https://lite.datasette.io/?url=https://github.com/simonw/scrape-hmb-traffic/blob/main/hmb.db?&install=datasette-copyable#/hmb?sql=with+item1+as+( ++select ++++time(datetime(commits.commit_at%2C+’-7+hours’))+as+t%2C ++++duration_in_traffic+%2F+60+as+mins_in_traffic ++from ++++item_version ++++join+commits+on+item_version._commit+%3D+commits.id ++order+by ++++commits.commit_at )%2C item2+as+( ++select ++++time(datetime(commits.commit_at%2C+’-7+hours’))+as+t%2C ++++duration_in_traffic+%2F+60+as+mins_in_traffic ++from ++++item2_version ++++join+commits+on+item2_version._commit+%3D+commits.id ++order+by ++++commits.commit_at ) select ++item1.*%2C ++item2.mins_in_traffic+as+mins_in_traffic_other_way from ++item1 ++join+item2+on+item1.t+%3D+item2.t - see Measuring traffic during the Half Moon Bay Pumpkin Festival
JSON: https://lite.datasette.io/?json=https://gist.github.com/simonw/73d15c0dd1025d1196829740bacf4464
Installing plugins
Add ?install=name-of-plugin to pip install that plugin into your browser’s environment!
This only works with a subset of plugins.