I recently used Astro [0] to make TrumpOrderTracker.com [1] and it was a great experience. It can definitely handle much more than just blogs.
1,075 karma · joined March 7, 2012
I made CSVFiddle because I wanted a quick way to query CSV files with SQL and share the results with other people.
The app runs 100% in-browser, so the data you import and the queries you write are never sent to a web server. When you share the URL to a workspace, all of its queries and references to CSV files are just encoded in the URL fragment.
In-browser querying is made possible by DuckDB-Wasm, which has been an awesome project to work with:
https://duckdb.org/2021/10/29/duckdb-wasm.html
There are definitely limitations with CSVFiddle (e.g. sometimes the auto-parsing feature doesn't accurately interpret the imported files), but so far it's been useful for a range of data tasks.
Some demo workspaces you can check out:
University Students by State https://tinyurl.com/6k35anth
Uber Pickups in NYC https://tinyurl.com/5n8av39h
Have you set up your UUID and HASH according to the post? You'll actually need to run the app through mitmproxy yourself to get your unique credentials. Then, just drop those into the variables at the top of the script.
I just added some error handling to the script to make this a bit more obvious!