Arctype connects to YugabyteDB
Tags: sql, yugabytedb
Published: 2021-07-28 19:01:28

<p>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.</p>
<h2 style="text-align: left">Setting up a database connection</h2>
<p style="margin-left: 20px">1. I went to <a href="https://arctype.com/" target="_blank" rel="noopener">https://arctype.com/</a> and downloaded the client for Windows.</p>
<p style="margin-left: 20px">2. When I launched the app, I created an Arctype account and logged into it.</p>
<p style="margin-left: 20px">3. At the Connect a Database step, I choose PostgreSQL and click Continue.</p>
<p><img loading="lazy" class="aligncenter size-full wp-image-4445" src="https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-Blog-Post-Image-8.png" alt="Arctype-Blog-Post-Image-8" srcset="https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-Blog-Post-Image-8.png 1999w, https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-Blog-Post-Image-8-300x188.png 300w, https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-Blog-Post-Image-8-1024x640.png 1024w, https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-Blog-Post-Image-8-768x480.png 768w, https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-Blog-Post-Image-8-1536x960.png 1536w" sizes="(max-width: 1999px) 100vw, 1999px" width="1999" height="1250"></p>
<p style="margin-left: 20px">4. I enter my Host and Port info and click Continue.</p>
<p><img loading="lazy" class="aligncenter size-full wp-image-4447" src="https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-Blog-Post-Image-7.png" alt="Arctype-Blog-Post-Image-7" srcset="https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-Blog-Post-Image-7.png 1999w, https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-Blog-Post-Image-7-300x188.png 300w, https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-Blog-Post-Image-7-1024x640.png 1024w, https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-Blog-Post-Image-7-768x480.png 768w, https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-Blog-Post-Image-7-1536x960.png 1536w" sizes="(max-width: 1999px) 100vw, 1999px" width="1999" height="1250"></p>
<p style="margin-left: 20px">5. I enter my database, username, password, and nickname for this database and click Continue.</p>
<p><img loading="lazy" class="aligncenter size-full wp-image-4431" src="https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-1.png" alt="Arctype + YB Blog Post Image 1" srcset="https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-1.png 1908w, https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-1-300x164.png 300w, https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-1-1024x558.png 1024w, https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-1-768x419.png 768w, https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-1-1536x837.png 1536w" sizes="(max-width: 1908px) 100vw, 1908px" width="1908" height="1040"></p>
<p style="margin-left: 20px">6. I enter my workspace name and click Continue.</p>
<p>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).</p>
<h2 style="text-align: left">Querying your database</h2>
<p>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.</p>
<p><img loading="lazy" class="aligncenter size-full wp-image-4432" src="https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-2.png" alt="Arctype + YB Blog Post Image 2" srcset="https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-2.png 1324w, https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-2-300x124.png 300w, https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-2-1024x423.png 1024w, https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-2-768x317.png 768w" sizes="(max-width: 1324px) 100vw, 1324px" width="1324" height="547"></p>
<p>You can visualize results on a grid (with search and export to .csv) or displayed as charts, like a heatmap.</p>
<p><img loading="lazy" class="aligncenter size-full wp-image-4433" src="https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-3.png" alt="Arctype + YB Blog Post Image 3" srcset="https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-3.png 1920w, https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-3-300x155.png 300w, https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-3-1024x529.png 1024w, https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-3-768x397.png 768w, https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-3-1536x794.png 1536w" sizes="(max-width: 1920px) 100vw, 1920px" width="1920" height="992"></p>
<p>I can create tables from there, and also import a .csv.</p>
<p>I’m imported a csv here (<a href="https://www.kaggle.com/komalkhetlani/coronavirus-covid19-vaccinations" target="_blank" rel="noopener">https://www.kaggle.com/komalkhetlani/coronavirus-covid19-vaccinations</a>). I used text, date and numeric datatypes.</p>
<p><img loading="lazy" class="aligncenter size-full wp-image-4434" src="https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-4.png" alt="Arctype + YB Blog Post Image 4" srcset="https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-4.png 1690w, https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-4-300x173.png 300w, https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-4-1024x589.png 1024w, https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-4-768x442.png 768w, https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-4-1536x883.png 1536w" sizes="(max-width: 1690px) 100vw, 1690px" width="1690" height="972"></p>
<p>I can query and display in a grid…</p>
<p><img loading="lazy" class="aligncenter size-full wp-image-4435" src="https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-5.png" alt="Arctype + YB Blog Post Image 5" srcset="https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-5.png 1113w, https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-5-300x125.png 300w, https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-5-1024x425.png 1024w, https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-5-768x319.png 768w" sizes="(max-width: 1113px) 100vw, 1113px" width="1113" height="462"></p>
<p>Or graphs that can be added to a dashboard…</p>
<p><img loading="lazy" class="aligncenter size-full wp-image-4436" src="https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-6.png" alt="Arctype + YB Blog Post Image 6" srcset="https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-6.png 1341w, https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-6-300x117.png 300w, https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-6-1024x400.png 1024w, https://blog.yugabyte.com/wp-content/uploads/2021/07/Arctype-YB-Blog-Post-Image-6-768x300.png 768w" sizes="(max-width: 1341px) 100vw, 1341px" width="1341" height="524"></p>
<p>All this is created in a workspace that can be shared with colleagues for team collaboration.</p>
<p>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 <a href="https://docs.yugabyte.com/latest/yugabyte-cloud/free-tier/" target="_blank" rel="noopener">Yugabyte Cloud</a>&nbsp;and load various Open Data to learn the power of SQL.</p>
<h2 style="text-align: left">Conclusion</h2>
<p>We are here to help and answer any questions you may have. Join us on our <a href="https://www.yugabyte.com/slack" target="_blank" rel="noopener">community Slack</a>&nbsp;channel, and star us on&nbsp;<a href="https://github.com/yugabyte/yugabyte-db" target="_blank" rel="noopener">GitHub</a>.</p>