Show HN: CSVFiddle – Query CSV files with DuckDB in the browser

Post by throwamon » Fri, Jul 01, 2022, 9:48 PM UTC

shubhamjain wrote: post #3

shbhrsaha wrote: post #2

Hey HN, 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…

Does it work with really large files? Like, >100mb or so. I was considering making something similar but with sqlite.js [1], but the problem with it is that it loads everything in memory, so I wasn't entirely sure how it will deal with larger workloads. [1]: https://sql.js.org/#/

Post by tlarkworthy » Fri, Jul 01, 2022, 10:38 PM UTC

throwamon wrote: post #10

Not to discourage you or anything, but Observable seems to cover this without too much hassle: https://observablehq.com/@cmudig/introducing-sql-with-duckdb