Introduction to PostgreSQL

Django comes with a SQLite database which is great for testing and debugging at the beginning of a project. However, it is not very suitable for production. Django also support these database engines:

We will take a closer look at the PostgreSQL database engine.

PostgreSQL database is an open source relational database, which should cover most demands you have when creating a database for a Django project. It has a good reputation, it is reliable, and it perform well under most circumstances. We will add a PostgreSQL database to our Django project. To be able to use PostgreSQL in Django we have to install a package called psycopg2.

Type this command in the command line to install the package. Make sure you are still inn the virtual environment:

The result should be something like this:

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

0:00:00

[ notice ] A new release of pip is available: 24.3.1 -> 25.0.1 [ notice ] To update, run:

The psycopg2 package is a driver that is necessary for PostgreSQL to work in Python. We also need a server where we can host the database. In this tutorial we have chosen the Amazon Web Services (AWS) platform, you will learn more about that in the next chapter.