Hacker Newsnew | past | comments | ask | show | jobs | submitlogin
Dblab: Interactive Terminal Client for PostgreSQL, MySQL, SQLite3 and Oracle (github.com/danvergara)
140 points by thunderbong on June 7, 2024 | hide | past | favorite | 19 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!



[flagged]


So don't use them and don't yap about it here.

The tools are great, there are no ads in them and I am glad the devs are not starving to death.

People take open source for granted and complain about most inane things.


Ads in a README isn't inane.


Ok do you sponsor any open source project? Are you contributing to any? Or are you just freeloading and complaining?

No wonder we have burnouts left and right leading to problems like XZ utils.

These ads are hurting no one and are helping the creators. If you are offended move on. Your comment has negative value.


I'm not going to justify how much I support FOSS to you. I was sharing my opinion on how I feel about these things. Maybe some devs won't overreact and will take that feedback into consideration, one way or another.


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




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: