Installing PostgreSQL

For this example, we will use a PostgreSQL database, so you'll need to install PostgreSQL to be able to run this project on your machine.

If you have a macOS machine, the easiest way to install PostgreSQL is by doing so with Homebrew. You just need to run the following command:

brew install postgres

Once you've installed it, you need to run the following command:

ln -sfv /usr/local/opt/postgresql/*.plist ~/Library/LaunchAgents

Then, you can create two new aliases to start and stop your PostgreSQL server:

alias pg_start="launchctl load ~/Library/LaunchAgents"
alias pg_stop="launchctl unload ~/Library/LaunchAgents"

Now, you should be able to start your PostgreSQL server by using pg_start or stop it with pg_stop.

After this, you need to create your first database, like so:

createdb `whoami`

Now, you can connect to PostgreSQL using the psql command.

If you get an error stating role "postgresql" does not exist, you can fix it by...