--- title: "PostgreSQL® - Tutorial - Build a Strapi app connected to your service" description: "Learn how to build a Strapi application using the Cloud Databases PostgreSQL® service." url: https://docs.us.ovhcloud.com/en/public-cloud/databases/postgresql-tutorial-build-strapi-app-connected-service lang: en --- > For AI agents: the complete documentation index is available at https://docs.us.ovhcloud.com/en/llms.txt, the full documentation bundle is available at https://docs.us.ovhcloud.com/en/llms-full.txt. # PostgreSQL® - Tutorial - Build a Strapi app connected to your service **Learn how to build a [Strapi](https://strapi.io/) application using the Cloud Databases [PostgreSQL®](https://www.postgresql.org/) [service](https://us.ovhcloud.com/public-cloud/postgresql/)**. **Warning:** **NOTE:** OVHcloud provides services for which you are responsible for their configuration and management. You are therefore responsible for their proper functioning.   ## Before you begin You need to be able to order a database solution in the OVHcloud Control Panel, as explained in our [Getting Started with Cloud Databases](https://docs.us.ovhcloud.com/en/public-cloud/databases/getting-started.md) guide. As [Strapi](https://strapi.io/) is written in JavaScript, packages like [nodejs](https://nodejs.org/), [nvm](https://github.com/nvm-sh/nvm), and [yarn](https://classic.yarnpkg.com/en/) are necessary for this tutorial.   ## Instructions ### Create a PostgreSQL[®](#go-further) database To set up a PostgreSQL®, follow the instructions in our [PostgreSQL® - Configure an Instance to Accept Incoming Connections](https://docs.us.ovhcloud.com/en/public-cloud/databases/postgresql-configure-instance-accept-incoming-connections.md) guide.   ### Before you begin, prepare your environment What you need here is to check your `nodejs` and `yarn` versions. According to the official documentation on [GitHub](https://github.com/strapi/strapi), check that your existing nodejs installation matches "NodeJS >= 12 \<= 16". You will require nodejs and yarn tools to configure and run Strapi App. These tools are available for various Linux, Windows, and macOS operating Systems. The installation steps are not provided in this guide but can be found in the links below: - [nodejs](https://nodejs.org/en/download/package-manager/) - [nvm](https://github.com/nvm-sh/nvm) - [yarn](https://classic.yarnpkg.com/lang/en/docs/install/) **Warning:** **NOTE:** nodejs version >= 18 is required for this setup. This tutorial uses v20.11.0. No specific version of yarn is specified; this tutorial was made with the v1.22.21.   ### Declare the NodeJS version Use this command to list the versions of NodeJS: ``` nvm ls ``` Install the latest version of NodeJS: ``` nvm install ``` Check the version: ``` node --version ```   ### Set up a new instance of Strapi Strapi offers a simple way to install its product with yarn. Run the following command in a terminal: ```sh yarn create strapi-app my-strapi ``` You will be prompted to choose between the Quickstart or Custom method. Select `Custom` and press `Enter`. Then, select JavaScript and press `Enter`. **Warning:** **NOTE:** If you choose the Quickstart option, default parameters will be applied, and a server will automatically start. ``` $ yarn create strapi-app my-strapi yarn create v1.22.19 [1/4] Resolving packages... [2/4] Fetching packages... [3/4] Linking dependencies... [4/4] Building fresh packages... success Installed "create-strapi-app@4.17.1" with binaries: - create-strapi-app ? Choose your installation type Quickstart (recommended) ❯ Custom (manual settings) ? Choose your preferred language ❯ JavaScript TypeScript ``` On the next step, select `postgres` and press `Enter`. ``` ? Choose your default database client sqlite ❯ postgres mysql ``` Then, enter your PostgreSQL® database parameters, and select `Yes` when prompted for enabling SSL connection. Database parameters can be found in the [OVHcloud Control Panel](https://manager.us.ovhcloud.com/). ``` ? Choose your installation type Custom (manual settings) ? Choose your preferred language JavaScript ? Choose your default database client postgres ? Database name: ? Host: ? Port: ? Username: ? Password: ? Enable SSL connection: Yes Creating a project with custom database options. Creating a new Strapi application at /home/my/app/path/my-strapi. Creating files. Dependencies installed successfully. Your application was created at /home/my/app/path/my-strapi. Available commands in your project: yarn develop Start Strapi in watch mode. (Changes in Strapi project files will trigger a server restart) yarn start Start Strapi without watch mode. yarn build Build Strapi admin panel. yarn strapi Display all available commands. You can start by doing: cd /home/my/app/path/my-strapi yarn develop Done in 662.54s. ``` Get the CA certificate from the OVHcloud Control Panel: Save the generated file into the `config` folder inside the my-strapi folder, just beside the `database.js` file, and rename it as `ca-certificate.crt` Now open the `config/database.js` file, find the block with your database information, and modify the `ssl` line as follows. Add the following block with your database information at the end of `database.js` file if it doesn't exist. Make sure to update your Database Host Name, Port, and Password. ``` const fs = require('fs'); module.exports = ({ env }) => ({ connection: { client: 'postgres', connection: { host: env('DATABASE_HOST', 'postgresql-ab1cd2ef-gh1ij2kl3.database.cloud.ovh.us'), port: env.int('DATABASE_PORT', 20184), database: env('DATABASE_NAME', 'defaultdb'), user: env('DATABASE_USERNAME', 'avnadmin'), password: env('DATABASE_PASSWORD', 'MyStrongPassword'), ssl: { ca: fs.readFileSync(`${__dirname}/ca-certificate.crt`).toString(), } }, }, }); ``` Where `${__dirname}` is the full path of the `config` folder. Save and exit the file, the configuration is done!   ### Start Strapi Launch the Strapi application with the yarn command: ```sh yarn develop ``` ``` $ yarn develop yarn run v1.22.17 warning ../../../package.json: No license field $ strapi develop Building your admin UI with development configuration ... Admin UI built successfully Project information ┌────────────────────┬──────────────────────────────────────────────────┐ │ Time │ Fri Dec 31 2021 13:26:35 GMT+0100 (Central Euro… │ │ Launched in │ 13253 ms │ │ Environment │ development │ │ Process PID │ 1861833 │ │ Version │ 4.0.2 (node v16.13.1) │ │ Edition │ Community │ └────────────────────┴──────────────────────────────────────────────────┘ Actions available One more thing... Create your first administrator 💻 by going to the administration panel at: ┌─────────────────────────────┐ │ http://localhost:1337/admin │ └─────────────────────────────┘ [2021-12-31 13:26:35.437] http: GET /admin (24 ms) 200 [2021-12-31 13:26:35.497] http: GET /admin/runtime~main.2d8596f7.js (7 ms) 200 [2021-12-31 13:26:35.498] http: GET /admin/main.dfa22c7a.js (3 ms) 200 [2021-12-31 13:26:35.775] http: GET /admin/project-type (1 ms) 200 [2021-12-31 13:26:35.808] http: GET /admin/497.726adbfa.chunk.js (2 ms) 200 [2021-12-31 13:26:35.813] http: GET /admin/2664.f33f619d.chunk.js (1 ms) 200 [2021-12-31 13:26:35.822] http: GET /admin/4362.c65ab24b.chunk.js (1 ms) 200 [2021-12-31 13:26:35.855] http: GET /admin/fontawesome-css.32df0f91.chunk.js (1 ms) 200 [2021-12-31 13:26:35.860] http: GET /admin/en-json.4c3c1c95.chunk.js (4 ms) 200 [2021-12-31 13:26:35.861] http: GET /admin/fr-json.c75e1a2e.chunk.js (2 ms) 200 [2021-12-31 13:26:35.870] http: GET /admin/fontawesome-css-all.90be2358.chunk.js (1 ms) 200 [2021-12-31 13:26:35.878] http: GET /admin/content-type-builder-translation-en-json.81257d0d.chunk.js (2 ms) 200 [2021-12-31 13:26:35.881] http: GET /admin/content-type-builder-translation-fr-json.2156f48c.chunk.js (4 ms) 200 [2021-12-31 13:26:35.885] http: GET /admin/email-translation-en-json.ef8208e3.chunk.js (5 ms) 200 [2021-12-31 13:26:35.886] http: GET /admin/email-translation-fr-json.76afb1c3.chunk.js (3 ms) 200 [2021-12-31 13:26:35.893] http: GET /admin/i18n-translation-en-json.a90b9dc5.chunk.js (5 ms) 200 [2021-12-31 13:26:35.894] http: GET /admin/upload-translation-en-json.d205cecd.chunk.js (5 ms) 200 [2021-12-31 13:26:35.897] http: GET /admin/i18n-translation-fr-json.482f6933.chunk.js (6 ms) 200 [2021-12-31 13:26:35.898] http: GET /admin/upload-translation-fr-json.0f4b3839.chunk.js (6 ms) 200 [2021-12-31 13:26:35.902] http: GET /admin/users-permissions-translation-en-json.3e650c44.chunk.js (7 ms) 200 [2021-12-31 13:26:35.904] http: GET /admin/users-permissions-translation-fr-json.12f3c930.chunk.js (4 ms) 200 [2021-12-31 13:26:35.906] http: GET /admin/fontawesome-js.2639263c.chunk.js (1 ms) 200 [2021-12-31 13:26:35.989] http: GET /admin/cropper-css.b71d1229.chunk.js (3 ms) 200 [2021-12-31 13:26:36.006] http: GET /admin/init (40 ms) 200 [2021-12-31 13:26:36.173] http: GET /admin/fde9b1ad0670d29a2516.png (1 ms) 200 ``` Congratulations! You have just finished the setup, the server starts, and open your browser on the admin login creation page `http://localhost:1337/admin/auth/register-admin`. Fill in the form fields as requested, and press the `Let's start` button. You are now using a Strapi app connected to an OVHcloud-managed PostgreSQL® database.   ### Controls #### Add an entry to Strapi Using the admin interface, click on the `Content Manager` menu, and add a user, such as: Then press the `Save` button.   #### Check the database As described above, connect to the PostgreSQL® database with `psql` command line interface. ```sh $ psql --dbname=defaultdb --host=postgresql-ab1cd2ef-gh1ij2kl3.database.cloud.ovh.us --port=20184 --username=avnadmin --password ``` Then find, in the `up_users` table, our previously created entry. Here the user is named "demo": ``` defaultdb=> SELECT id,username,email,created_at FROM public.up_users WHERE username='demo'; id | username | email | created_at ----+----------+-----------------+------------------------ 1 | demo | demo@mymail.com | 2021-12-31 13:46:08.04 (1 row) ```   ### Cleaning up To clean your Strapi, make sure it is closed by pressing `CTRL+C` in the terminal you used to launch it, then delete your installation folder. ```sh rm -rf /home/my/app/path/my-strapi/ ``` To clean your PostgreSQL®, use the OVHcloud Control Panel to delete your managed PostgreSQL® service from the `Configuration` tab:   ## Go further Browse all the [Databases guides](https://docs.us.ovhcloud.com/en/public-cloud/databases/landing-page-databases.md). Browse the rest of the [OVHcloud US documentation](https://docs.us.ovhcloud.com/en/index.md) for guides on our other products and services. Learn more about [Managed Databases](https://us.ovhcloud.com/public-cloud/databases/) on the OVHcloud US website. OVHcloud Managed Databases and Analytics: - Grafana® is a registered trademark of Grafana Labs and is used with the permission of Grafana Labs. OVH SAS and its subsidiaries are not affiliated with or endorsed by Grafana Labs. - Kafka® is a registered trademark of The Apache Software Foundation and has been licensed for use by OVHcloud, who has no affiliation with and is not endorsed by The Apache Software Foundation. - MongoDB® is a registered trademark of MongoDB, Inc. - MySQL® is a registered trademark of Oracle and/or its affiliates. - PostgreSQL® is a registered trademark of the PostgreSQL Community Association of Canada.