Dblab: Interactive Terminal Client for PostgreSQL, MySQL, SQLite3 and Oracle | Hacker News Reader

Dblab: Interactive Terminal Client for PostgreSQL, MySQL, SQLite3 and Oracle

github.com

140 pointsthunderbong19 comments

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.

https://github.com/xo/usql has a similar feel to it, with a variety of backends.

It works, but faaaaaaar from perfect! Perfect would include a lot more things like auto completion, syntax highlighting etc etc etc

psql’s very good, but duckdb’s CLI made me wish psql had some of its features.

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/

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!

This gives me vibes of:

https://github.com/jesseduffield/lazygit

and

https://github.com/jesseduffield/lazydocker

nice!

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

Does anyone have a comparison with https://harlequin.sh/ ?

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.

This looks great! It instantly made me think of my favourite ever query editor, which was SQL Query Analyzer from SQL Server 2000.

Probably a false alarm, but Windows 11 detects virus in dblab_0.24.0_windows_amd64.tar.gz

An alternative for sqlite is litcli, it has auto-completion.

Does it work in 80x25? All the screenshots are like 300x150.

Cool

Reply on news.ycombinator.com