Setting up PostgreSQL, SQLAlchemy, and Alembic
We are going to start by setting up the database tools needed for the backend database. PostgreSQL is a popular free and open source RDBMS. It is similar to other dialects of the SQL databases that exist – for example, MySQL, MariaDB, and Oracle. This database can be used to store data for any web application. PostgreSQL has enterprise-grade features that make it robust, scalable, and reliable.
We will also set up SQLAlchemy, an object-relational mapper (ORM). An ORM is a high-level abstraction layer on top of a relational database that allows web developers to rely on Python object-oriented programming code to execute database operations, such as read
, insert
, update
, and delete
, rather than writing SQL queries directly. Finally, in this section, we will set up Alembic to handle database migrations.
Setting up PostgreSQL
To get started with PostgreSQL locally on your machine, download it from https://www.postgresql.org...