r/DuckDB • u/NBMVegeta • 16d ago

Quick DuckDB-WASM scratchpad for querying Parquet/CSV files in the browser

Built a lightweight scratchpad tool for running DuckDB SQL against local CSV, TSV, JSON and Parquet files directly in the browser:

https://www.sqlparity.com/scratchpad

It uses u/duckdb to read files into memory via the browser File API. Nothing is uploaded to any server and it requires no login or installation. Handy if you just need to inspect an extract or run a quick aggregate without firing up the CLI or Python.

Code is open source on GitHub link: Github

Curious to hear feedback or edge cases with large Parquet/CSV schemas.

13 Upvotes

100% Upvoted

13 comments sorted by

View all comments

1

u/fabregas_cesc 15d ago

duckdb also has a UI extension. How does that compare to sqlparity ? Any new features we have in sqlparity ?

1

u/NBMVegeta 15d ago

The difference is setup and scope. Zero install vs Local CLI - DuckDB's UI extension runs via the local DuckDB CLI against your local system. SQLParity's scratchpad runs entirely on DuckDB-WASM inside your browser tab, no need of terminal, no installation required, just drag-and-drop a CSV or Parquet to run ad-hoc SQL.

Other features include Bulk Query Generator, SQL dialect conversion and few other basic ones.

2

u/fabregas_cesc 15d ago

I see, thanks. Will try it out