PostgreSQL

PostgreSQL¹ is a popular object-relational database management system that is known for its powerful feature set and extensibility. The database makes it possible to add custom data types, procedures (even in different programming languages) and has a large ecosystem of extensions. In addition, conforms closely to the SQL standard, moreso than other relational databases.

Comparison

Each of the requirements is scored on a scale from 1 (very poor) to 5 (very good).

Data integrity

Score: 5. Data integrity is an important feature of PostgreSQL. It is fully ACID-compliant, meaning that it has robust transactions. In additions, relations between tables can ensure that related data items remain consistent.

Handling necessary data

Score: 5. PostgreSQL should have no trouble handling millions of rows in a table.

JavaScript support

Score: 4. There are many libraries² available that support PostgreSQL, with different levels of abstraction and functionality.

Performance

Score: 4. PostgreSQL performs very well in benchmarks³⁴, both for simple and more complex operations.

Query support

Score: 5. There is great support for SQL, including advanced features. Joining data is a core feature of relational databases like PostgreSQL.

Scalability

Score: 2. PostgreSQL is mainly built to be scored vertically, by increasing the machine’s resources. Additionally, it supports read replicas to increase read capacity. Third-party extensions and compatible software could further expand these features.