DEV Community

loading...
Yugabyte

Arctype connects to YugabyteDB

Franck Pachot
20 years in databases from dev to prod - Oracle Certified Master, AWS Data Hero, love to learn and share
Originally published at blog.yugabyte.com Updated on ・6 min read

YugabyteDB is PostgreSQL compatible. It uses the same protocol and SQL layer as PostgreSQL. This makes YugabyteDB compatible with a majority of database tools, because PostgreSQL is the most popular open source database on the planet. Here is an example with Arctype, a user-friendly collaborative SQL client to query and visualize data.

Setting up a database connection

1. I went to https://arctype.com/ and downloaded the client for Windows.

2. When I launched the app, I created an Arctype account and logged into it.

3. At the Connect a Database step, I choose PostgreSQL and click Continue.

Arctype-Blog-Post-Image-8

4. I enter my Host and Port info and click Continue.

Arctype-Blog-Post-Image-7

5. I enter my database, username, password, and nickname for this database and click Continue.

Arctype + YB Blog Post Image 1

6. I enter my workspace name and click Continue.

YugabyteDB is a distributed database. If you have a DNS entry with multiple IP addresses, you get high availability (in my tests, Arctype reconnects automatically).

Querying your database

I immediately can see the tables in my database, and query them. Some interesting features are variables – which runs prepared statements – and autocompletion from the catalog objects and the query aliases.

Arctype + YB Blog Post Image 2

You can visualize results on a grid (with search and export to .csv) or displayed as charts, like a heatmap.

Arctype + YB Blog Post Image 3

I can create tables from there, and also import a .csv.

I’m imported a csv here (https://www.kaggle.com/komalkhetlani/coronavirus-covid19-vaccinations). I used text, date and numeric datatypes.

Arctype + YB Blog Post Image 4

I can query and display in a grid…

Arctype + YB Blog Post Image 5

Or graphs that can be added to a dashboard…

Arctype + YB Blog Post Image 6

All this is created in a workspace that can be shared with colleagues for team collaboration.

This product is new, free to use, and has a community on Discord, to help. This is a nice way to get the power of SQL databases with a user-friendly interface. Of course, you can connect it to Yugabyte Cloud and load various Open Data to learn the power of SQL.

Conclusion

We are here to help and answer any questions you may have. Join us on our community Slack channel, and star us on GitHub.

Discussion (0)