Setting up our Postgres database
In this section, we will install and set up a Postgres database. Relational databases are still very relevant, and these days NoSQL databases are all the rage. However, according to StackOverflow, Postgres continues to be one of the world's most popular databases. Additionally, its performance is world class, beating MongoDB by a significant margin (https://www.enterprisedb.com/news/new-benchmarks-show-postgres-dominating-mongodb-varied-workloads). So, Postgres is what we will be using as our database technology.
Let's install our Postgres database. We will use the installer provided by EDB. EDB is a third-party company that provides tools and services for supporting Postgres:
- Go to the URL https://www.enterprisedb.com/downloads/postgres-postgresql-downloads and select the download for your platform. I will be using version 12.4 for Mac, which is the latest Mac version as of the time of writing.
- Accept all the defaults on the...