[HN Gopher] Dblab: Interactive Terminal Client for PostgreSQL, M...
       ___________________________________________________________________
        
       Dblab: Interactive Terminal Client for PostgreSQL, MySQL, SQLite3
       and Oracle
        
       Author : thunderbong
       Score  : 104 points
       Date   : 2024-06-07 05:26 UTC (17 hours ago)
        
 (HTM) web link (github.com)
 (TXT) w3m dump (github.com)
        
       | saulpw wrote:
       | Does it work in 80x25? All the screenshots are like 300x150.
        
       | francislavoie wrote:
       | Neat! I use mycli as my default repl but this looks nice for
       | "discovery", being able to see the table list in the sidebar and
       | check the schemas quickly. The area where mycli shines is the
       | fantastic query autocomplete, built in less paging, lots of
       | configuration and saved queries for quick access.
        
       | tiffanyh wrote:
       | If you like terminal apps ...
       | 
       | Terminal Trove is a site that lists a number of other CLI tools
       | (including other database clients).
       | 
       | https://terminaltrove.com/list/
        
       | ledauphin wrote:
       | Hi - this sounds really interesting. If the author sees this -
       | would you consider putting some non-technical features in the
       | list? "cross-platform" and "zero dependencies" are great, but
       | those aren't really helping me decide whether I might benefit
       | from giving this a spin.
       | 
       | From skimming the rest of the readme, I kind of think this is
       | meant for "visually navigating tables in a database, as read-only
       | operations." But I may very well be wrong. A summary of the
       | actual use cases would be very helpful!
        
       | vdm wrote:
       | Does anyone have a comparison with https://harlequin.sh/ ?
        
       | racl101 wrote:
       | Cool
        
       | dharbin wrote:
       | In my opinion, psql is the "perfect" terminal database client.
       | It's fast, has the ability to easily switch between wide and
       | narrow row formats, and has commands for the things I do
       | frequently.
       | 
       | I have often wanted psql to work with other databases, because
       | the other CLI clients are either bare-bones, or just plain
       | unusable.
        
         | kermatt wrote:
         | https://github.com/xo/usql has a similar feel to it, with a
         | variety of backends.
        
         | signal11 wrote:
         | psql's very good, but duckdb's CLI made me wish psql had some
         | of its features.
        
       | zX41ZdbW wrote:
       | Thank you. I didn't hear about dblab before.
       | 
       | Added a bug fix: https://github.com/danvergara/dblab/pull/206 and
       | a feature request: https://github.com/danvergara/dblab/issues/207
        
       | petepete wrote:
       | This looks great! It instantly made me think of my favourite ever
       | query editor, which was SQL Query Analyzer from SQL Server 2000.
        
       | breadwinner wrote:
       | Probably a false alarm, but Windows 11 detects virus in
       | dblab_0.24.0_windows_amd64.tar.gz
        
       | hu3 wrote:
       | This gives me vibes of:
       | 
       | https://github.com/jesseduffield/lazygit
       | 
       | and
       | 
       | https://github.com/jesseduffield/lazydocker
       | 
       | nice!
        
         | squigz wrote:
         | Both of those repos have ads at the very top of the README,
         | basically guaranteeing I won't use them. At least put the
         | description of your project before the ads...
        
       | tester457 wrote:
       | An alternative for sqlite is litcli, it has auto-completion.
        
       ___________________________________________________________________
       (page generated 2024-06-07 23:01 UTC)