Databases
Modelling in PostgreSQL, MySQL or SQLite: referential integrity, indexes, versioned migrations with Flyway, backups and slow queries.
What it covers
- Relational model with referential integrity and keys where they belong.
- Versioned migrations with Flyway: the schema travels alongside the code.
- Indexes and slow-query review measured on real data, not sample data.
- Automated backups and a restore drill, which is the part almost nobody does.
- Redis caching where the query will not get fast enough on its own.
Technologies
- PostgreSQL
- MySQL
- SQLite
- Redis
- Flyway
- SQLAlchemy