DEV Community

Fady Shafeek
Fady Shafeek

Posted on • Edited on

1

How to get free Postgres Cloud Database

Are you looking to set up a Postgres database for your project without breaking the bank? Look no further than SupaBase! In this guide, I'll walk you through the steps to get free Postgres using SupaBase, along with enabling PostGIS for spatial data capabilities.

  1. Sign up for SupaBase: Head over to SupaBase and sign up. Create a new workspace and project with your preferred names.

Image description

Image description

  1. Project Settings: Once you're in your project, navigate to the project settings.

  2. Configure the Database: Under the configuration tab, find the Database section. Here, you'll get the connection parameters needed to connect to your Postgres database.

Image description

  1. Test the Connection: It's always a good idea to test the connection before proceeding. Open your preferred coding environment, like Lowcoder, and create a new app. Add a new data source of type "Postgres" and input the SupaBase connection parameters. Voila! You're connected.

Image description

Image description

Image description

Image description

Image description

Image description

  1. Enable PostGIS: If you need spatial data capabilities, enabling PostGIS is a must. Simply execute the query CREATE EXTENSION postgis; in your database. To verify that it's installed correctly, run SELECT PostGIS_Full_Version();.

Image description

Image description

  1. Load Your Data: With PostGIS enabled, you can now seamlessly load your spatial data from tools like QGIS into your Postgres database.

Congratulations! You've successfully set up a free Postgres database with SupaBase and enabled PostGIS for spatial data needs. Happy coding!

Hostinger image

Get n8n VPS hosting 3x cheaper than a cloud solution

Get fast, easy, secure n8n VPS hosting from $4.99/mo at Hostinger. Automate any workflow using a pre-installed n8n application and no-code customization.

Start now

Top comments (0)

Billboard image

Deploy and scale your apps on AWS and GCP with a world class developer experience

Coherence makes it easy to set up and maintain cloud infrastructure. Harness the extensibility, compliance and cost efficiency of the cloud.

Learn more

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay