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.
- Sign up for SupaBase: Head over to SupaBase and sign up. Create a new workspace and project with your preferred names.
Project Settings: Once you're in your project, navigate to the project settings.
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.
- 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.
-
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, runSELECT PostGIS_Full_Version();.
- 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)