Database Migrations in PHP (Posobota #66)

Transcript

1. Database Migrations in PHP Posobota #66 Vladimír Kriška @ujovlado
2. My experience • Paradox: first company I worked with was the closest to migrations • Then it went only worse • no migrations • single file migrations • Yii framework database migrations
3. Pros • Exact version of schema with creation and application date • CLI interface (automation) • Easy rollback, going through history
4. Cons • Need to regenerate/change model
5. Other options/ideas • Generate migrations directly from model (no SQL writing) • With each change create DB dump with file per table, than version in Git
6. Other tools • Phinx • Sqitch (Perl) • Doctrine, Phalcon, Propel, CakePHP • and many others …
7. Migrations in Yii • Two main commands • yiic migrate up • yiic migrate down • And also: history, new, to, mark
8. Example • let’s do some shit …
9. Tips/tricks • DB schema has to be versioned - no matter how • If you don’t know how to do it, choose solution from some framework • Don’t write own tool for migrations • Start with migrations ASAP
10. • Always write down migrations • Try to avoid shortcut methods (they disallow c&p from migration) • Don’t mix schema and data migrations • Write short migrations • Don’t change applied migrations
11. THE END Thanks!