Setting up a SQL GUI with CockroachDB

Create a free cluster on cockroachlabs.cloud

https://cockroachlabs.cloud/clusters/1f2936ba-9ec7-4b55-9f57-61a6c3fe9254/cert
'postgresql://paul:<REVEAL_PASSWORD>@free-tier.gcp-us-central1.cockroachlabs.cloud:26257/defaultdb?sslmode=verify-full&sslrootcert='$HOME'/.postgresql/root.crt&options=--cluster%3Dpython-bootcamp-2788'
'scheme://username:password@host:port/database_name?config_params'
  • Username: paul
  • Password: g4wH8APMDV
  • Host: free-tier.gcp-us-central1.cockroachlabs.cloud
  • Port: 26257
  • Database: defaultdb
  • Configuration Parameters: sslmode=verify-full&sslrootcert=’$HOME’/.postgresql/root.crt&options= — cluster%3Dpython-bootcamp-2788
  • sslmode: verify-full
  • sslrootcert: ’$HOME’/.postgresql/root.crt
  • options:--cluster%3Dpython-bootcamp-2788
  • sslrootcert: /Users/paul/root.crt
  • options: --cluster=python-bootcamp-2788

Download and install DBeaver

--

--

--

Engineer, Professor

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Mocking an API with Rapidmock

Docker Containers!

Individually Agile

WARP does not work after submitting an invite code

Digital Analytics at CXL — Blog 4

3 (+1) Questions for impactful Sprint Goals!

How to make your terminal pretty using OhMyZsh and Powerlevel10k

#LearnWeb3 with @thedapplist

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Paul Logston

Paul Logston

Engineer, Professor

More from Medium

Setting up your own RudderStack, the Docker way

IT Teams Daily Routines — The Tension Between Developing New Software and Maintaining Old Ones

Using Containers For Your NetSuite Dev Workflow

Connecting to MS Sql Server from a Mac with Windows Authentication