Redeploying Qexo with PlanetScale
After an update to the official Qexo documentation, it was mentioned that Djongo does not support MongoDB well. Developers recommend using MySQL/PostgreSQL. Since the previous iteration version was too large, causing Qexo to malfunction, I decided to redeploy it.
With each version iteration and updates to the official documentation, I made corresponding modifications to Qexo and recorded them accordingly.
PlanetScale
Register、log in and create a database
Connect to the database
Click on Get connection strings
Create a password
Select General at the Connect with section
Get database-related information
Vercel
Click the button to deploy with one click
The first attempt will fail without adding environment variables, add them and redeploy
Add environment variables
Setting -> Environment Variables
| Name | Description | Example |
|---|---|---|
| MYSQL_HOST | MySQL database connection address (corresponds to host in .env) | aws.connect.psdb.cloud |
| MYSQL_PORT | MySQL database communication port (default is 3306) | 3306 |
| MYSQL_USER | MySQL database username (corresponds to username in .env) | xxxxx |
| MYSQL_NAME | MySQL database name (corresponds to database in .env) | xxxxx |
| MYSQL_PASSWORD | MySQL database password (corresponds to password in .env) | xxxxxxxxxxxx |
| PLANETSCALE | Set to 1 to disable foreign key constraints and prevent deployment failures | 1 |
Redeploy
Deployments -> Redeploy
Obtain the Qexo project ID
Setting -> General -> Project ID
Obtain token
Github
Obtain token
Initialization
No changes, just fill in the corresponding information as usual
