From SQLite to PostgreSQL

Now, we’re going to transition from SQLite to PostgreSQL. While there are some exceptions, we usually only need to change the connection string.

Setting up Postgres user and password

By default, Postgres on Mac installed with Homebrew will allow connections without a password. In Windows, the default is to require the password. We can turn that off by changing the file C:\Program ...