shbhrsaha
Joined 14 years ago
Joined 14 years ago
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