DEV Community

Amit Chauhan
Amit Chauhan

Posted on

Using pgcli with YugabyteDB

#pgcli #yugabytedb #potsgres

pgcli is popular postgres client that does auto completion and syntax highlighting.

YugabyteDB is popular open source distributed database. If you see the architecture diagram below, YugabyteDB has Postgres Compatible YSQL API.

YugabyteDB Architecture

What this means is that most clients which work for Postgres work out of box with YugabyteDB. Let's take pgcli as an example.

  • Install the pgcli. On mac, if you are using brew you can simply do this (for linux see instructions here): 
brew install pgcli
Enter fullscreen mode Exit fullscreen mode
  • Once installed, let's connect to the YugabyteDB. Example: 
pgcli -h 127.0.0.1 -p 5433 -U yugabyte
Enter fullscreen mode Exit fullscreen mode
  • That's it - enjoy all the goodies offered by pgcli on YugabyteDB

Screenshot showing PGCLI in action using YugabyteDB

Top comments (0)

Read next

abhay_yt_52a8e72b213be229 profile image

Using Docker for Microservices: Streamlining Development, Deployment, and Scaling

Abhay Singh Kathayat -

aldeiacloud profile image

Alarme Dynamo Throttle Events - Discord

Railander Marques -

musharaf_hussain profile image

A Journey into Machine Learning Simplification

Musharaf Hussain Abid -

bhatiagirish profile image

AWS Serverless: Develop, Test, and Deploy with AWS Lambda's New Code Editor and SAM template

Girish Bhatia -