Arctype connects to YugabyteDB

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.

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

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

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.

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

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.

I can query and display in a grid…

Or graphs that can be added to a dashboard…

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.