Supabase is an open-source Firebase alternative that provides backend services needed to build a product. It comes with a built-in Postgres database. A database hosted on Supabase can easily be connected with Arctype for effective queries and management.
In this article, we’ll go through step-by-step instructions on how a database hosted in Supabase can be connected with Arctype.
In order to complete this tutorial, the following are prerequisites:
Log in to your Supabase account and follow the steps below to create a Postgres database on Supabase.
From your main dashboard, click on new project. This will take you to the page to create a new project. Complete the form with the relevant information for your project.
Note: the database password is what you use as a password when adding a new connection to your Arctype workspace.
Now that we have successfully created our database on Supabase, let’s connect it with our Arctype workspace. This is pretty simple and straightforward - just follow the steps below.
First, from your Supabase workspace dashboard, click database from the menu and then click on connection pooling. This will load a page that contains the information required to connect to your Arctype workspace, as shown below:
Now log in to your Arctype account and click on Get Started. This will take you to a page where you can add a New Connection to your workspace. The next step is to select the Postgres connection type.
After selecting Postgres, fill in the connection credentials details with the credentials as shown in Supabase’s connection pooling area in order to connect to the database that you have created.
Click on Test Connection. You should see a notification showing “**Connection Successful.**” Then click on save.
The table below shows the detailed description of each field:
|Name||Name helps you to keep track of your connections (in case you want to open many connections).|
|Host||This is the hostname of your database server. Get your host from the connection pooling area on your workspace dashboard under the database.|
|Port||Port is where everything is hosted.|
|User||Use postgres as your user.|
|Password||The password you provided when you created a new project on your Supabase account.|
|Database||Use postgres as your database.|
After the connection has been saved successfully, this will take you to the workspace, as shown below.
We have successfully connected a Supabase Postgres database to our Arctype workspace! Now, let's perform some operations on the database, like writing a query or creating a table.
In this tutorial, we learned how to create a Postgres database in Supabase and how the database can be connected to an Arctype workspace.
Using the Arctype client to connect to the database gives you the tools you and your team need to manage your database in one workspace effectively. If you are new to Arctype, you can read more about it in the Arctype documentation, which has additional information that you may need when using Arctype.