[HN Gopher] Show HN: SQL workbench in the browser
       ___________________________________________________________________
        
       Show HN: SQL workbench in the browser
        
       Author : tobilg
       Score  : 54 points
       Date   : 2024-02-28 13:44 UTC (9 hours ago)
        
 (HTM) web link (sql-workbench.com)
 (TXT) w3m dump (sql-workbench.com)
        
       | abtinf wrote:
       | This is interesting. Any chance you will open source it?
        
         | tobilg wrote:
         | Eventually at a later point in time! I'm currently integrating
         | the AI-based generation of queries...
        
       | tobilg wrote:
       | The SQL Workbench is built upon DuckDB WASM, Perspective.js and
       | React.
       | 
       | It supports the querying remote and local data (Parquet, CSV and
       | JSON), data visualizations and the sharing of multiple queries
       | via URL.
       | 
       | There's also a tutorial blog post at https://tobilg.com/using-
       | duckdb-wasm-for-in-browser-data-eng... that explains common usage
       | patterns.
       | 
       | Happy to answer any questions!
        
         | paddy_m wrote:
         | Perspective is an awesome table library, very powerful and
         | fast. I get the sense it's mostly used for internal finance
         | applications and not for web apps much.
        
       | 9dev wrote:
       | I've been working on something similar to this, but using the
       | WASM build of SQLite, which is amazing. But then I started
       | implementing a small file browser for the Origin private FS API,
       | just so I could manage the database files when debugging, you see
       | - and I got so thoroughly sidetracked, I only noticed when I
       | finished the multi-modal CSV file editor which could show CSV
       | files as sortable tables, using a streaming, web worker based
       | parser no less. Shortly after I found the whole thing way too
       | bothersome and forgot about it completely until now.
       | 
       | It's a dangerous business, creating side projects. Before you
       | know it, you build streaming parsers :)
        
       ___________________________________________________________________
       (page generated 2024-02-28 23:00 UTC)