[HN Gopher] ZeQLplus: Terminal SQLite Database Browser
       ___________________________________________________________________
        
       ZeQLplus: Terminal SQLite Database Browser
        
       Author : amadeuspagel
       Score  : 46 points
       Date   : 2025-06-28 12:32 UTC (10 hours ago)
        
 (HTM) web link (github.com)
 (TXT) w3m dump (github.com)
        
       | amadeuspagel wrote:
       | This is the best tool in its category that I've found. It's the
       | only that can stream results (so you can run SELECT without LIMIT
       | and see the first results immidiately) _and_ display them as a
       | table.
       | 
       | EDIT: Crashes often though.
        
         | deafpolygon wrote:
         | How is that best in class, then? If it crashes often, it's not
         | production-ready.
        
           | amadeuspagel wrote:
           | I wrote that in a burst of enthusiasm before I noted the
           | crashes.
        
           | 0cf8612b2e1e wrote:
           | If only my production tools did not crash.
        
         | zX41ZdbW wrote:
         | My SQL Playground can stream results and display them as a
         | table: https://play.clickhouse.com/
         | 
         | And for a command-line client, clickhouse-client has been
         | around since 2016.
        
           | amadeuspagel wrote:
           | Impressive, but the category I was refering to is SQLite
           | clients.
        
       | smartmic wrote:
       | Interesting to see a tool written in V in the wild. I will try it
       | out just for that reason.
        
       | CraigJPerry wrote:
       | The UI looks a lot like Harlequin
       | https://github.com/tconbeer/harlequin
        
         | darkteflon wrote:
         | I really like Harlequin. Discovered it by accident when I was
         | assessing Textual - I think they showcased it.
         | 
         | I can't think of another DB TUI tool as nice. I use it mainly
         | with DuckDB, for which I believe it was originally written
         | (although the web notebook UI that now ships with the DuckDB
         | binary is also nice).
         | 
         | Slightly OT, but PyCharm / Datagrip always feels quite flaky
         | with DuckDB. Thanks to Harlequin, I never needed to dig into it
         | too deeply. I only wish that DuckDB supported writes while
         | attached (in read-only mode) from another process! Although I
         | understand there are good reasons for not doing so.
        
       | nodesocket wrote:
       | I was looking for a simple, no bloat sqlite explorer that runs in
       | a container and ended up deploying sqlite-web[1] in read-only
       | mode. Very impressed, no external dependencies, works great. A
       | CLI tool is nice, but then still have to ssh into the remote
       | server to access the db file.
       | 
       | [1] https://github.com/coleifer/sqlite-web
        
       ___________________________________________________________________
       (page generated 2025-06-28 23:00 UTC)