[HN Gopher] Show HN: WhatTheDuck - open-source, in-browser SQL o...
       ___________________________________________________________________
        
       Show HN: WhatTheDuck - open-source, in-browser SQL on CSV files
        
       WhatTheDuck is an in-browser sql tool to analyze csv files that
       uses duckdb-wasm under the hood.  Please provide
       feedback/issues/pull requests.
        
       Author : slake
       Score  : 75 points
       Date   : 2024-03-26 10:55 UTC (12 hours ago)
        
 (HTM) web link (github.com)
 (TXT) w3m dump (github.com)
        
       | refset wrote:
       | 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.
        
       | boiler_up800 wrote:
       | 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 wrote:
         | 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 wrote:
         | Keep an eye on this link. New support is being added every so
         | often.
         | 
         | https://github.com/davidgasquez/awesome-duckdb?tab=readme-ov...
        
       | hantusk wrote:
       | 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 wrote:
         | 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.
        
       | ramonverse wrote:
       | 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.
        
       | spxneo wrote:
       | now how to make this collaborative? that would be interesting
        
       ___________________________________________________________________
       (page generated 2024-03-26 23:01 UTC)