ScaffoldHub
Search…
SQL

Providers

You can use any provider you want, those are just recommendations.
Cloud SQL: for PostgreSQL, MySQL & SQL Server  |  Cloud SQL: Relational Database Service  |  Google Cloud
Google Cloud
Amazon RDS | Cloud Relational Database | Amazon Web Services
Amazon Web Services, Inc.

Setup

First, manually create a database. You can usually create it via the console. This is an example for the Google Cloud SQL provider:
Temporarily change the backend/.env database credentials to point to this database.
On the backend, run:
1
npm run db:create
Copied!
Done!
Now revert the database credentials to the localhost ones.

Troubleshooting

Allowed IP addresses

Cloud database providers usually start the database blocking all external connections. You must whitelist the IPs you will use.
In case you want to allow all IPs, the pattern is usually 0.0.0.0/0.
Last modified 1yr ago