PostgreSQL

PostgreSQL (or postgres for short) is a powerful, open-source relational database system used to store, manage, and query structured data reliably. It supports advanced features like complex queries, transactions, extensibility, and compliance with SQL standards. Known for its robustness and scalability, it’s widely used in applications ranging from small projects to large enterprise systems. Postgres forms the backbone of the framework system laid on on this site.

Installing PostgreSQL

The installation of PostgreSQL depends on your operating system. You can download distributions from the official download page. For MacOS you can alternatively use Homebrew, also mentioned on the postgreSQL official download page for MacOS. For details you can consult Karttur’s post on Install postgreSQL and postGIS. Also for Linux (Ubuntu) you can use alternative installation, e.g. as outlined in Karttur’s post installations for Ubuntu.