This page is a work in progress.You can help improve it. →

Back-End Setup Part 2

Insomnia

Insomnia is a graphical tool that allows us to work with web based APIs.

Installation

brew install --cask insomnia

PostgreSQL

The database engine we will be using for our back-end work.

Installation

Start a Terminal and run:

pg_config >/dev/null 2>&1 && echo "STOP"

If this comes back and says "STOP" -- STOP AND DISCUSS WITH YOUR INSTRUCTOR

Otherwise, proceed to the next step.

brew install postgresql
brew services start postgresql
brew install pgcli

Configure pgcli with nice defaults

The following command will set some common user configuration options in your pgcli. If you've used pgcli before and have custom configured it, this will overwrite your configuration changes.

sdg pgcliConfig

Install a graphical tool for working with our database

psql and pgcli are good command-line tools for working with a database. You may prefer working with a graphical user interface for your database work. If so, install BeeKeeper Studio and use it in place of psql and pgcli.

Test if it is working:

From Terminal:

createdb MyTestDatabase

Then:

pgcli MyTestDatabase

If this command runs without requiring a password the configuration is complete.

To close the pgcli tool you can type exit and press return.

© 2017 - 2021; Built with ♥ in St. Petersburg, Florida.