PostgreSQL, most commonly referred to as Postgres, is the fourth most popular database in the world. It has a primary focus on data integrity and has the ability to be customized through extensions. PostgreSQL was developed based on POSTGRES 4.2 at Berkeley Computer Science Department at the University of California. Postgres is 100% free and open source and is licensed under the PostgreSQL license.
Postgres has been around since 1996 and has seen a resurgence in recent years. This is due to the fact that it is a database known to work well and, being fully open source and extensible, it is easy to work with and is often the database of choice for those looking to move away from Oracle's proprietary software.
In this whitepaper, we’ll look at where PostgreSQL makes sense, and some places where it is a less ideal choice. PostgreSQL is popular with developers due to numerous features like logical replication, simple read balancing, commit tracking, and full-text search support for JSON.