Integrate Digital Ocean with Strapi

These integration guides are not official documentation and the Strapi Support Team will not provide assistance with them.

The purpose of this guide is to allow users to deploy Strapi applications on the DigitalOcean App Platform. This guide uses the PostgreSQL development database provided by DigitalOcean, so applications can be tested in a deployed environment. At the end of the guide there is information on how to connect a Strapi application to a DigitalOcean Managed Database. Additional information about migrating local database content to a production database and other deployment topics are provided in the DigitalOcean documentation.

Prepare the deployment

Prior to starting the deployment process each user needs:

• a DigitalOcean account (The Strapi referral link for DigitalOcean provides $200 in credits.),
• a GitHub account and Git version control,
• an existing Strapi application.

Setup a Strapi project for deployment

Strapi uses environment configurations to maintain multiple environments inside a single application. This section describes how to setup a production environment in a Strapi application.

1. Add a production configuration environment by creating a sub-directory ./config/env/production.
2. Create database.js inside the ./config/env/production directory.

3. Add the code snippet to the database configuration file:

   1 // path: /config/env/production/database.ts
   2 export default ({ env }) => ({
   3   connection: {
   4     client: 'postgres',
   5     connection: {
   6       host: env('DATABASE_HOST'), 
   7       port: env.int('DATABASE_PORT'), 
   8       database: env('DATABASE_NAME'), 
   9       user: env('DATABASE_USERNAME'), 
   10       password: env('DATABASE_PASSWORD'),
   11       ssl: {
   12         rejectUnauthorized:env.bool('DATABASE_SSL_SELF', false),
   13       },
   14     },
   15     debug: false,
   16   },
   17 });

4. Create server.js inside the ./config/env/production directory.

5. Add the code snippet to the server configuration file:

   1// path: /config/env/production/server.ts
   2export default ({ env }) => ({
   3     proxy: true,
   4     url: env('APP_URL'), // Sets the public URL of the application.
   5     app: { 
   6       keys: env.array('APP_KEYS')
   7     },
   8 });

6. Add PostgreSQL dependencies by installing pg package:

   • With yarn:

     yarn add pg

   • With npm

     npm install pg

7. Verify that all of the new and modified files are saved locally.

8. Commit the project to a remote repository:

   git add .
   git commit -m "commit message"
   git push

Create and configure a DigitalOcean App

Deploying on the DigitalOcean App Platform requires creating an App, connecting the App to a development database, and setting environment variables. At the end of the following steps a Strapi application should be successfully deployed.

Create a DigitalOcean App

From the DigitalOcean website create and App and connect it to a GitHub repository:

1. Click on the Create button and select Apps.
2. Select GitHub and authorize access to the correct repository.
3. Select the branch.
4. (optional) Select the source directory.
5. Choose whether or not to "Autodeploy" when an update is pushed to the GitHub repository.
6. Click the Next button.

Connect an App to a database

After creating an App attach a development database. To add a development database on the following screen:

1. Click Add Resource.
2. Select Database and click Add.
3. Select Dev Database and name the database. The default database name is "db" and is used to prefix the database values in the global environment table. If another database name is used, it should be substituted for "db".
4. Click the Create and Attach button.
5. Click the Next button to set the Environment Variables (Env Vars).

Add environment variables

In the DigitalOcean App Platform there are Global and Component-level environment variables. Strapi applications in production need Global-level variables to set the database connection, and can use either Component or Global-level variables for secrets storage. The following procedure is to add the database variables at the Global level and store the Strapi secrets at the Component level.

1. Add the database, URL, and NODE_ENV variables to the global environment table:

   Variable name	Value
   APP_URL	${APP_URL}
   DATABASE_HOST	${db.HOSTNAME}
   DATABASE_PORT	${db.PORT}
   DATABASE_NAME	${db.DATABASE}
   DATABASE_USERNAME	${db.USERNAME}
   DATABASE_PASSWORD	${db.PASSWORD}
   NODE_ENV	production

2. Add the key-value pairs for the Strapi secrets to the component environment variables table:

   Variable name	value
   APP_KEYS	"unique user-generated secrets here"
   API_TOKEN_SALT	"unique user-generated secret here"
   ADMIN_JWT_SECRET	"unique user-generated secret here"
   JWT_SECRET	"unique user-generated secret here"
   (optional)TRANSFER_TOKEN_SALT	"unique user-generated secret here"

3. Click Next.

4. (optional) Edit the App name and Region and click Save
5. Click Next.
6. Click Create Resources to create the App and database.

Deploy and access a Strapi application

When the preceding steps are completed DigitalOcean should automatically try to build and deploy the application. The Strapi admin panel is accessed at {your App domain}/admin once the application is successfully deployed.

Add a managed database

DigitalOcean managed databases are a production-scale database solution for a deployed Strapi application. Switching from a development database to a managed database requires modifying the Strapi application and modifying the settings on DigitalOcean:

• removing the development database and database environment variables,
• installing the pg-connection-string dependency,
• changing the production database configuration file,
• creating and attaching the database in the DigitalOcean platform.

Modify the Strapi application

When a managed database is attached to a Strapi application, the connection parameters are passed directly from the database to the application .yaml file (App Spec in the DigitalOcean settings). This requires a modification to the config/env/production/database file and the addition of the pg-connection-string dependency.

To add the pg-connection-string dependency navigate to the project directory and install pg-connection-string:

• With yarn:

  yarn add pg-connection-string

• With npm:

  npm install pg-connection-string

To switch to a managed database modify the config/env/production/database file to be able to parse the DATABASE_URL:

1// path: /config/env/production/database.ts
2
3const parse = require("pg-connection-string").parse;
4
5const { host, port, database, user, password } = parse(
6   process.env.DATABASE_URL
7 );
8
9export default ({ env }) => ({
10  connection: {  
11    client: 'postgres',
12    connection: {
13      host,
14      port,
15      database,
16      user,
17      password,
18      ssl: {
19        ca: env('DATABASE_CA'),
20      },
21    },
22    debug: false,
23  },
24});

Create a managed database on DigitalOcean

Changing the settings on the DigitalOcean App Platform to incorporate a managed database requires creating and attaching the database to an existing Strapi application. Additionally, the database environment variables must be removed, as managed databases propagate the connection properties automatically.

1. Click on the Create button from any DigitalOcean page and select Databases.
2. Select a location (use the same location as the application location).
3. Select the PostgreSQL database engine.
4. Select a database configuration.
5. Click the Create a Database Cluster button.

Attach the managed database to an App

After creating the managed database, navigate to the application page:

1. Click on the Create button and select Create/Attach Database.
2. Select Previously Created DigitalOcean Database.
3. Use the picklist to select the previously created database.
4. Click Attach Database.

Configure environment variables for production-ready managed database

Remove the previously added 'DATABASE_*' global variables added for connecting to the dev database, then set the following environment variables, inserting your database name (e.g. db-postgresql-nyc3-1234) in place of dbClusterName:

After attaching the database, DigitalOcean will attempt to auto-deploy the application. If the deployment is successful a link to the application will be provided at the top of the application page.