Postgres is favored over MySQL for its support of Transactional DDL, allowing multiple schema changes to be rolled back if any fail, which is essential for effective database migration. The author highlights the complications that arise when down scripts are not properly tested, emphasizing Postgres's advantage in ensuring schema integrity during migrations. This functionality makes Postgres a superior choice for developers working with frameworks like PlayFramework.