Compare real, in-memory, and SQLite testing databases, highlighting reliability and setup trade-offs. Then show configuring two Postgres databases with Docker Compose for local testing and straightforward connections.

Master the basics of json web tokens (jwt) for authentication and authorization by understanding header, payload, signature, signed vs encrypted tokens, and using them in authorization headers with stateless verification.

Initialize an express server by importing config, loading environment variables, and connecting to the database, then listen on the configured port within an immediately invoked function expression.

Inspect the newly synced Sequelize tables in Postgres with DBeaver, noting a unique email, a unique username, and the primary key. Explain why migrations provide a history of database changes.

Create and implement an authentication middleware that verifies bearer access or refresh tokens from the authorization header using jwt utilities, handles errors, and passes control to the next middleware.

Explore adding tests for the token controller middleware, covering invalid and missing authorization headers, bearer tokens, and 500 errors, with Jest spies on JWT utils.

Add logout controller and register in router. Retrieve the JWT from the request body, locate the user by email with the refresh token model, and return 200 with success true.

Add tests for the logout controller by issuing a post /logout with an access token, and verify 200 status, the message 'successfully locked out', and a nullified refresh token.

Connect to the database, set up a new app, import the default module to wire up controllers and models, and start listening on port 80.

Learn to use the debug script to attach the debugger, inspect variables, step through code, and diagnose issues in a sequelize orm app with express and postgres.