The Complete Strapi™ Course with Plugins and Deployment - Database Creation and Configuration

The video tutorial covers configuring a database for a Strappy application, starting with SQLite for development and switching to Postgres for production. It explains creating a database on Render.com, using internal connection strings, and parsing these strings with the PG package. The tutorial emphasizes using environment variables for database configuration and demonstrates how to extract necessary connection details from a connection string.

What are the two main properties of database configuration in Strappy?

• Schema and SSL

• Username and Password

• Host and Port

• Client and Connection

Which database is used in production for Strappy?

• MySQL

• SQLite

• MongoDB

• Postgres

What is the first step to set up a Postgres database on render.com?

• Create an account

• Configure the database locally

• Download the Postgres software

• Insert payment information

What is the purpose of an internal connection string?

• To connect to external databases

• To enhance database performance

• To secure the connection within render.com infrastructure

• To provide public access to the database

Which package is used to parse the Postgres connection string?

• pg-parse

• pg-stringify

• pg-connection-string

• pg-promise

What environment variable is used to store the connection string?

• DATABASE_URL

• DB_CONNECTION

• CONNECTION_STRING

• POSTGRES_URL

What is the fallback mechanism if an environment variable is not found?

• Use a backup database

• Use default values

• Throw an error

• Skip the configuration