from Hacker News

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

by slake on 3/26/24, 10:55 AM with 17 comments

• by refset on 3/26/24, 2:42 PM

  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.

• by ramonverse on 3/26/24, 6:43 PM

  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.

• by hantusk on 3/26/24, 3:45 PM

  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.

• by boiler_up800 on 3/26/24, 3:13 PM

  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.

• by yogini on 3/27/24, 9:01 PM

  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.

• by 18chetanpatel on 3/27/24, 5:39 AM

  How about incorporating options for data visualization through charts?

• by spxneo on 3/26/24, 9:52 PM

  now how to make this collaborative? that would be interesting