logoalt Hacker News

wodenokototoday at 11:57 AM2 repliesview on HN

My biggest pain point with using different cli to connect to different databases is that they all do things like listing tables differently.

Another nice feature one would want from such a program is of course auto complete.


Replies

adonesetoday at 4:51 PM

I find this to put my psql in a better place as a daily driver. Adding this to ~/.inputrc [1] will allow you to limit search on your entered text. Eg.

select (up arrow)

will loop through your psql history for commands that started with e.g., . The challenging part is in wide tables and or table with large data. Less is awkward usually so using pspg made it less awkward.

I tried also to with help of ai, to write a plugin for sublime that fits my flow. It worked well but I think I'm more used to psql.

[1]

~/.inputrc

$if psql "\e[A": history-search-backward "\e[B": history-search-forward $endif

edit: formatting

data_derstoday at 1:03 PM

Yeah for me standardization is the big win. But not just output formatting but cli commands and a guarantee that they’re as past as possible given that all the connectors use ADBC