[HN Gopher] Commandline Database Clients with Autocompletion and...
___________________________________________________________________
Commandline Database Clients with Autocompletion and Syntax
Highlighting
Author : thunderbong
Score : 65 points
Date : 2021-02-18 17:39 UTC (5 hours ago)
(HTM) web link (www.dbcli.com)
(TXT) w3m dump (www.dbcli.com)
| flyinglizard wrote:
| Azure Data Studio is a very nice hybrid between a lightweight
| visual and a rich command line tool. It still has some bugs but I
| like it very much (and it's cross platform).
| orra wrote:
| Azure Data Studio is slick, but disappointingly it's not open
| source. (It's source available with a proprietary license).
|
| BeeKeeper Studio has hence caught my attention.
|
| There are is also an open source database extensions for
| VSCode, including an official MSSQL one from Microsoft. Except,
| I just realised many of its key dependencies are proprietary.
| asdfghjklkjhgf wrote:
| I've been really happily using pgcli for the last couple years. I
| really like it. It has all of the upside of psql but with added
| benefits that don't get in the way and are configurable. If you
| use psql, I believe it's pretty much a drop-in replacement and
| worth the minimal effort to try out. I personally switched from a
| GUI client, since I had been missing the psql backslash commands
| for a while
| wsostt wrote:
| I can imagine a use for this when looking for a quick answer
| without having to wait for SQL Server Management Studio to load
| up.
| bntyhntr wrote:
| I'm not a heavy db user, but I touch it once or twice a day. I
| use mycli as my daily driver. I configured separate profiles
| for when I connect to prod, and added autocomplete for my db
| profiles.
|
| I haven't found a gui I'm happy with on Linux, but I've been
| loving mycli for the last 4 years or so.
| amjith wrote:
| > I've been loving mycli for the last 4 years or so.
|
| So rewarding to hear this. Cheers!
| paulryanrogers wrote:
| One thing I always miss from CLI is the vertical properties view:
| `\G` in mysql and `\x` in pgsql
| amjith wrote:
| They are both supported in mycli and pgcli clients.
| mixmastamyk wrote:
| These are quite nice. I'd like to complain however that the pgcli
| on PyPi is out of date and a newer version that has several new
| features implemented should be pushed forward. :D
| amjith wrote:
| The latest version of pgcli is pypi was released on Dec 11
| 2020. There are only a few changes unreleased in the master
| branch.
|
| https://github.com/dbcli/pgcli/blob/master/changelog.rst
|
| What feature are you waiting for? I can talk to the project
| lead to see if we can push out a new release if needed.
| mixmastamyk wrote:
| Oh thanks. They aren't critical but I was waiting on the
| unicode table borders without row separators and ability to
| change additional syntax highlight colors in the config file.
|
| Also, I have some awkward issues when typing out statements
| and don't know if they have been improved. Was just hoping
| maybe there had been some tweaks in the area have no
| information on that.
| hhsnopek wrote:
| Has anyone found/built a CLI client for DynamoDB?
| astuyvenberg wrote:
| AWS CLI is pretty handy
| taude wrote:
| SnowSql (For snowflake users):
| https://docs.snowflake.com/en/user-guide/snowsql.html
___________________________________________________________________
(page generated 2021-02-18 23:01 UTC)