In the ever-evolving landscape of data management, the introduction of Outerbase has revolutionized the way we interact with databases. It's not just another tool; it's a gateway to a new era of data accessibility and efficiency. Imagine a world where your database tasks are streamlined, your data queries are as simple as plain language, and collaboration among your team members is seamless, regardless of their location. Outerbase brings this vision to life, and in this article, we will guide you through the process of connecting Outerbase to your Supabase PostgreSQL database.
But first, let's dive into what Outerbase is.
Outerbase is a data management platform that serves as an interface for your MySQL database, allowing you and your team to securely access and manipulate data within a cloud-based environment. It simplifies database work, enhances efficiency, and promotes collaboration. Outerbase provides a user-friendly interface for interacting with your MySQL database and offers features like EZQL, Commands, Plugins, Data Catalog, and SQL query fields to streamline data-related tasks.
Let's Get Started
To get started, you need to create two accounts, one from Outerbase and the other from Supabase. After successfully creating the account. Let's head to Supabase to get our Postgres database connection parameters that will allow us to connect to Outerbase.
Supabase Connection Parameters:
After sign-up/sign-in you'll be redirected to your organisation page there you can add a new project, name it whatever you want, and set or generate a password for your project, then choose the region you close to your users for the best performance. Then select a plan that suits your needs(Free😊). And remember to copy your generated password.
After your project is created, you have to wait for 20 seconds or less to have your project set up by Supabase.
Now click on the settings icon and then at the sidebar, click on Database. There you should see a section called Connection info, and that's the information needed to make the connection from Outerbase to Supabase PostGres successful.
So copy the information that has the red circle behind it and in my case
Host: db.pzgxpdlvtawrlcthwtpn.supabase.co
Database name: postgres
Port: 5432
User(username): postgres
Password: [The password you provided when you created this project]
Outerbase Connection
After account creation or login, you'll be redirected to your base dashboard, where you can create or connect to a database. But since our focus is on connection to external database, you click on Connect a database.
Now select Postgres then click on contiune.
Now enter the information you got from Supabase and click on the Test Connection to validate your inputted info.
If you want to restrict access using the IP, on your project on Supabase go to settings -> Dashboard -> Network Restrictions. Then add an IP address provided by Outerbase to enable access to your data only to Outerbase.
If the provided info is correct then you should see a green colour with the text Connection Successful, then give a name to your base, and then you're done.
Conclusion
As we reach the conclusion of our exploration. Wish you a happy coding journey.
And I'll be documenting everything I learn from Outerbase until the hackathon by Hashnode and Outerbase is done.
#outerbasehackathon