Database

PostgreSQL

Reliable open-source relational database

Maintained by

PostgreSQL Global Development Group

Released 1996

Source code and version control tooling on a developer screen

Plain explanation

What PostgreSQL is

PostgreSQL is a relational database, meaning it stores information in tables with defined relationships between them and enforces rules about what is valid. It is the general-purpose default for business systems that need their records to stay correct.

A reliable open-source relational database that works well for transactional business systems, reporting, structured relationships, and applications that need strong data integrity.

How Axis uses it

PostgreSQL is our default database for new work. It handles the operational and reporting needs of most business systems without adding license cost.

What it is used for

Where PostgreSQL shows up in our projects

These are the practical applications we build with it, not a list of everything it can theoretically do.

Business application databases

Customer portals

Transactional systems

Reporting

Geospatial data

Structured operational data

Honest assessment

When PostgreSQL is the right call, and when it is not

Every technology has a range where it performs well and a range where something else is a better answer. We would rather say so up front.

A strong fit when

Relationships and data integrity matter
The system needs mature SQL reporting
A capable open-source database is preferable to proprietary licensing

We would consider another option when

The project is already standardized on SQL Server and changing provides no business value
A specialized document, analytics, or time-series workload clearly fits another data store

Related services