knaxuslearn · build · ship

Roadmaps / Databases / Setup and lab safety

Read first

Setup and lab safety

You need one laptop with 8 GB of RAM or more and 20 GB of free disk, Docker, the current PostgreSQL major version in a container, psql, pgbench and a language of your choice. Everything is free.

RiskRule
Destructive tests damage dataRun crash, restore and migration tests on a throwaway container or a copy, never on a shared database.
Real data in a labUse generated data only. Never load production data or real card numbers into a practice database.
Superuser accessCreate a limited role for the application. Use the superuser only for setup, and write down what each role may do.
Load tests can fill a diskSet a disk limit on the container and watch free space during a run.