PostgreSQL is a very popular open-source database platform.

The homepage says: “PostgreSQL is a powerful, open source object-relational database system with over 35 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.”

Postgres is the most advanced open source database because it is created with the goal of highly extendable and standards compliant.
It is capable of efficiently handling multiple tasks at the same time, ensuring data integrity while being ACID compliant.

Unlike MySQL and SQLite, Postgres is an object relational database. Postgres includes advanced features like table inheritance, function overloading, which can be imported to the certain applications. In addition, Postgres adheres more closely to the SQL standards than the MySQL.

Postgres was designed to be extensible. This means that you can define your own data types at custom functions using other programming languages, and more.

On the downside, PostgreSQL’s features decreses its speed. For heavy applications, MySQL may be better and indeed MySQL is more popular.

To interact with PostgreSQL we can use any Python module that follows Python Database API. We can use SQLAlchemy or another ORM. We can use the PostgreSQL Shell or PostfreSQL GUI.

Learn with YouTube

Alex the Analyst has a video where he compares MySQL, Microsoft SQL Server and PostgreSQL. The video is called MySQL vs Postgresql vs Microsoft SQL Server Management Tools | Which Option is Best? I haven’t used PostgreSQL yet (at the time of this writing) so i can’t compare the three. However, I’ve use SQL Server much more than MySQL and SQL Server is currently my favourite. Alex’s favourite is also SQL Server, however for beginners he recommends MySQL, partly because it is open source, just like PostgreSQL. One advantage of Microsoft SQL Server is that is has T-SQL built on top of the standard SQL language, which add a lot of powerful functionality to SQL.