4 ms·

I’ve been working on something similar to this, but using the WASM build of SQLite, which is amazing. But then I started implementing a small file browser for t

by 9dev 3y ago

I’ve been working on something similar to this, but using the WASM build of SQLite, which is amazing. But then I started implementing a small file browser for the Origin private FS API, just so I could manage the database files when debugging, you see - and I got so thoroughly sidetracked, I only noticed when I finished the multi-modal CSV file editor which could show CSV files as sortable tables, using a streaming, web worker based parser no less. Shortly after I found the whole thing way too bothersome and forgot about it completely until now. It’s a dangerous business, creating side projects. Before you know it, you build streaming parsers :)

simonw 3y ago
My version of this kind of thing the WASM build of Python which includes a WASM build of SQLite, running my Datasette server-side web application entirely in the browser. Here's a SQL query executed against that parquet file of AWS edge locations: https://lite.datasette.io/?parquet=https://raw.githubusercontent.com/tobilg/aws-edge-locations/main/data/aws-edge-locations.parquet#/data?sql=select+rowid%2C+%5Bindex%5D%2C+code%2C+city%2C+state%2C+country%2C+countryCode%2C+count%2C+latitude%2C+longitude%2C+region%2C+pricingRegion+from+%5Baws-edge-locations%5D+order+by+rowid+limit+101 https://lite.datasette.io/?parquet=https://raw.githubusercon...