REST APIs with Flask and Python - Adding PostgreSQL to Your Heroku App

The video tutorial explains how to switch from SQLite to Postgres using Heroku add-ons. It covers the installation and configuration of Heroku Postgres, setting up environment variables, and integrating Psycopg2 with SQLAlchemy. The tutorial also demonstrates deploying the application and testing database connections, emphasizing the importance of using environment variables for seamless database integration.

Why is PostgreSQL preferred over SQLite for Heroku applications?

• PostgreSQL is easier to set up than SQLite.

• PostgreSQL provides persistent storage across deployments.

• PostgreSQL supports more data types than SQLite.

• PostgreSQL is faster than SQLite.

What is the maximum number of rows allowed in the free Heroku Postgres plan?

• 1,000 rows

• 5,000 rows

• 10,000 rows

• Unlimited rows

What must be done to ensure the application uses the new PostgreSQL database URL?

• Restart the Heroku application.

• Set the database URL as an environment variable.

• Reinstall the Heroku Postgres addon.

• Manually update the database URL in the code.

Which Python library is used to interact with PostgreSQL in this setup?

• Django ORM

• MySQL Connector

• SQLAlchemy

• Psycopg2

How can you ensure the application still runs locally with SQLite?

• By setting a default value for the database URL.

• By installing a local version of PostgreSQL.

• By disabling environment variables locally.

• By using a different codebase for local development.

What tool is used to test the database connection and perform operations like user registration?

• MySQL Workbench

• DBeaver

• Postman

• pgAdmin

What is the maximum number of simultaneous connections allowed in the free Heroku Postgres plan?

• 10 connections

• 50 connections

• 20 connections

• 5 connections