Show HN: WhatTheDuck – open-source, in-browser SQL on CSV files

refset · 2024-03-26T14:42:08

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.

pratik227 · 2024-03-28T06:32:10

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

slake · 2024-03-27T02:09:59

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

ramonverse · 2024-03-26T18:43:09

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 · 2024-03-27T06:34:33

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

hantusk · 2024-03-26T15:45:53

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 · 2024-03-26T17:24:59

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 · 2024-03-28T09:47:28

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!

boiler_up800 · 2024-03-26T15:13:40

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 · 2024-03-26T15:31:55

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 · 2024-03-26T19:03:56

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

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

pratik227 · 2024-03-27T12:25:55

Yes we have added there as well the PR is merged

fastasucan · 2024-03-28T14:46:34

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

yogini · 2024-03-27T21:01:54

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.

18chetanpatel · 2024-03-27T05:39:35

How about incorporating options for data visualization through charts?

pratik227 · 2024-03-27T08:47:25

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

spxneo · 2024-03-26T21:52:04

now how to make this collaborative? that would be interesting