Show HN: WhatTheDuck – open-source, in-browser SQL on CSV files (github.com)

119 points by slake 2y ago ↗ HN

WhatTheDuck is an in-browser sql tool to analyze csv files that uses duckdb-wasm under the hood.

Please provide feedback/issues/pull requests.

17 comments

[ 4.7 ms ] story [ 46.6 ms ] thread

Looks nice! I would suggest to pointing users to a small demo csv file and query that can be quickly loaded/pasted to see it working. Or even have a "Load example CSV and query" button.

slake 2y ago ↗

Sounds like a good idea. We'll get to it.

pratik227 2y ago ↗

We have added an upload sample file button thanks for feedback @refset

boiler_up800 2y ago ↗

IDE support is definitely one area where DuckDB could be better. My current workflow is to edit SQL files in VS Code and then use ‘.read’ within the DuckDB CLI.

reportgunner 2y ago ↗

I don't use DuckDB but I use the community version of DBeaver for SQL - looks like it supports DuckDB too[0]

[0] https://duckdb.org/docs/guides/sql_editors/dbeaver.html

chrisjc 2y ago ↗

Keep an eye on this link. New support is being added every so often.

https://github.com/davidgasquez/awesome-duckdb?tab=readme-ov...

pratik227 2y ago ↗

Yes we have added there as well the PR is merged

fastasucan 2y ago ↗

Same here. You have Harlequin which is worth a try, but ideally I would just write and execute in vscode.

hantusk 2y ago ↗

I liked SQL workbench (https://news.ycombinator.com/item?id=39537794) which has the same core ideas but more usable features at this point (query history, parquet support and charts) - if you hadn't seen it maybe some of its features will inspire you.

mritchie712 2y ago ↗

SQL workbench also uses https://perspective.finos.org/ for tables. It's a WASM table library which pairs nicely with duckdb and works well with large tables.

tobilg 2y ago ↗

Thanks you, https://sql-workbench.com author here :-) Let me know if you have some feature requests / bug reports etc. at https://github.com/tobilg/sql-workbench/issues Thanks!

ramonverse 2y ago ↗

Cool stuff, we are also building in the space, currently adding Python support with Pyodide. I would recommend you add your live website at the top of the README so people can find it easily (we had a lot of views that way for https://github.com/pretzelai/pretzelai). Also, we added a simple text2sql "Ask AI" that users loved, maybe your users will like it too.

westurner 2y ago ↗

JupyterLite is also built on Pyodide.

Is there support for DuckDB in JupyterLite in WASM in WhatTheDuck or pretzelai?

datasette-lite can load [remote] sqlite and Parquet but not yet DuckDB (?) with Pyodide in WASM, and there's also JupyterLite as a datasette plug-in: https://github.com/simonw/datasette-lite

spxneo 2y ago ↗

now how to make this collaborative? that would be interesting

18chetanpatel 2y ago ↗

How about incorporating options for data visualization through charts?

pratik227 2y ago ↗

Yah I think it's a good idea I think detailed documentation will also be helpful

yogini 2y ago ↗

Loved the idea and the entire project! Starred it on GitHub.

One suggestion, when I land on the website I would love to see a small example already added. Basic CSV and some SQL queries to run and play with.

It would be best if you also launch it on Peerlist. Many people are working in a similar space there, they also might find this useful.