Thanks for building this as open-source!
How is it different from CSVFiddle (which is also based on DuckDB-wasm, I think)? Ability to have multiple tables loaded and running join queries against them would be crucial.
Show HN: Open-source, browser-local data exploration using DuckDB-WASM and PRQL
81–84 of 84 posts
Re: Show HN: Open-source, browser-local data exploration using DuckDB-WASM and PRQL
#82Thanks for building this as open-source! How is it different from CSVFiddle (which is also based on DuckDB-wasm, I think)? Ability to have multiple tables loaded and running join queries against them would be crucial.
Thanks!
We're different in a couple of ways:
- You don't need SQL to transform and manipulate data in Pretzel - we have visual blocks where you can construct a transform chain (though we do support manual SQL blocks now!)
- We have better CSV parsing (I spent a fair bit of time on this!). See one of our test case CSVs here that breaks (https://imgur.com/a/O8XMfET)
- We allow plotting!
- We support PRQL - which IMO is a better way to build data pipelines (but we also support SQL)
- We have AI Blocks! You can use your API keys (or our server) to get SQL from text which you can edit
- We're currently adding support for Python via Pyodide (pyodide.org) so you can do complex data transforms, even train simple ML models right inside the browser!
- Lastly, we'll be adding a ton more features to Pretzel over the coming months (many of them have been asked for in this thread actually!)
Support for multiple files is crucial - we'll be adding that soon. Right now, we're rethinking our whole task execution architecture so any major features will have to wait until then.
Re: Show HN: Open-source, browser-local data exploration using DuckDB-WASM and PRQL
#83Earlier quoted context omitted.
Yes! I'm heartened to see people realize the the benefits of PRQL and chained transforms over vanilla SQL (with some caveats!). We'll definitely add a PRQL/SQL block to the UI soon (you will be able to toggle to select which one you'd like). On that point - PRQL doesn't natively support PIVOT statements. As a hack, we made our own flavor of PRQL with a PIVOT statement and we parse that to SQL CTEs to make it work for…
For folks looking for a workaround in the meantime, you can add an AI block and it will give you the returned SQL to edit. Not ideal because it’s just wasting credits, but it worked for me.
Hey! We added support for SQL blocks btw!
Re: Show HN: Open-source, browser-local data exploration using DuckDB-WASM and PRQL
#84Earlier quoted context omitted.
For folks looking for a workaround in the meantime, you can add an AI block and it will give you the returned SQL to edit. Not ideal because it’s just wasting credits, but it worked for me.
Hey! We added support for SQL blocks btw!
Awesome, thanks for the update!