SQL Databases

For data that must be saved and stored correctly, we use PostgreSQL (we usually refer to it as “Postgres”).

PostgreSQL

It’s a thirty-year-old open source database that is highly respected, is well supported by documentation and hosting providers, and can be used by any developer who knows the SQL standard.

Installation

A guide to installing Postgres in any environment can be found in Postgres Installation Tutorial.

If you are using Docker, you can create your database inside a container using the Postgres image.

Amazon Relational Database Service (RDS)

For production environments we suggest using RDS. RDS makes it easy to set up, operate, and scale a relational database in the cloud.

Some of the features that RDS provides that are helpful for us are:

RDS is compatible with the following databases engines: