Checks

• This is not a duplicate of an existing issue (please have a look through our open issues list to make sure)
• I have thoroughly read and understand The Odin Project Contributing Guide
• Would you like to work on this issue?

Describe your suggestion

Currently, the macOS instructions for installing PSQL involve installing psql dependencies directly via brew. At the time of writing, I didn't have a good sense of the macOS ecosystem and assumed that was the best way to install PSQL and friends.

Now that I've been working with macOS, it seems that there is a better way: https://postgresapp.com/

This install method nets us a few advantages:

1. PSQL version management - you can install multiple concurrent versions of Postgres and run one at a time, or run different versions on different local ports.
2. Tooling comes packaged in (psql and friends like pg_dump and pg_restore) without much fuss.

I think it's a much better way to manage PSQL on macOS. The project is open source and licensed under the same license as PSQL itself.

Additionally, I'd like to update the instructions so that we use at least N-1 of the current release (PSQL is officially on V17, but the macOS instructions are on v14).

Path

Ruby / Rails

Lesson Url

https://www.theodinproject.com/lessons/ruby-on-rails-installing-postgresql

(Optional) Discord Name

crespire

(Optional) Additional Comments

Spots to change/impacts:

• Rails Lesson
• NodeJS Lesson
• Rails project setup instructions
• NodeJS project setup instructions - if we instruct learners to set up a test project to use this local DB, those instructions should also be updated to reflect whatever path we decide here re: local trust auth.