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!

Image of Timescale

🚀 pgai Vectorizer: SQLAlchemy and LiteLLM Make Vector Search Simple

We built pgai Vectorizer to simplify embedding management for AI applications—without needing a separate database or complex infrastructure. Since launch, developers have created over 3,000 vectorizers on Timescale Cloud, with many more self-hosted.

Read full post →

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more