Connecting your Spring API to Postgres
I recently was going through these videos on PluralSight to learn some Spring API concepts, and ran into some trouble getting my API to connect to my database. The video glossed over connecting to the database, but I followed some instructions on getting Postgres on Docker. Try as I may, I continually got errors saying I either had the wrong password or that no password was offered. Eventually I realized the Docker container was on the same port as my local Postgres instance, but even when I changed the port I got a whole new JPA error. Since I knew I could connect to the local Postgres instance, I created a new database there instead. The videos directed me to a GitHub repository where I was able to find some SQL scripts for creating tables and inserting the data. These were easy to run in Docker, but to run them in PSQL I needed to learn a few easy commands. PSQL uses the '\' character plus another letter to run commands, for example '\l' (that...