Movatterモバイル変換


[0]ホーム

URL:


Skip to content
DEV Community
Log in Create account

DEV Community

Fady Shafeek
Fady Shafeek

Posted on • Edited on

     

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 toSupaBase 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 queryCREATE EXTENSION postgis; in your database. To verify that it's installed correctly, runSELECT 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!

Top comments(0)

Subscribe
pic
Create template

Templates let you quickly answer FAQs or store snippets for re-use.

Dismiss

Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment'spermalink.

For further actions, you may consider blocking this person and/orreporting abuse

  • Joined

More fromFady Shafeek

DEV Community

We're a place where coders share, stay up-to-date and grow their careers.

Log in Create account

[8]ページ先頭

©2009-2025 Movatter.jp