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.
| Risk | Rule |
|---|---|
| Destructive tests damage data | Run crash, restore and migration tests on a throwaway container or a copy, never on a shared database. |
| Real data in a lab | Use generated data only. Never load production data or real card numbers into a practice database. |
| Superuser access | Create 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 disk | Set a disk limit on the container and watch free space during a run. |