PostgreSQL

PostgreSQL (also nicknamed Postgres) is an open-source object-relational database system.

Why do we use PostgreSQL?

We use PostgreSQL as our primary database for storing persistent data in our projects. We store data about entities such as users, products, orders, and more.

Features

Like any other relational database it makes use of features like:

• Indexing: enabling efficient data retrieval
• Custom data type support: Supports a range of custom data types such as arrays, UUIDs, enums and geospatial data types
• JSONB support: Enables efficient storage and querying of JSON data
• Transactions: Grouping multiple operations into a single unit, meaning they will either succeed or roll back if an error occurs.

How can I use PostgreSQL locally?

We run all our development services within Docker. Each project should contain a docker-compose.yaml file which contains a postgres service. After running docker-compose up -d you should see this container running in your Docker Desktop.

To use PostgreSQL in our project, we use an ORM, we make use of TypeORM.

How can I use PostgreSQL for developnent or other environments?

This part is explained in the Hoop topic.

DBMS

A DBMS is an application that allows you to easily view and manage the data within your database. The DataBase Management System we use at Wisemen is TablePlus, this app can be dowloaded via SetApp.