Do you have a "Schema Master"?
29/07/2019 2:20 PM by
You have a web site master right? This is the central point of contact if the site goes down.
When developing an application, all members can code. However schema changes being done by many developers often can lead to trouble.
Who is "Schema Master"? What does he do?
- Figure: One person should be the 'Schema Master', on an average sized project (of 5-10 devs)
If your project has a database, you need to select a "Schema Master". This is the one person who should review all modifications to the database. These include:
The "Schema Master" in a development shop is often the lead programmer on the team. They are in charge of all database changes and scripts. Team members should still feel free to make changes, just get them double checked by the Schema Master.
- Figure: The Applications Database stores version info in a table called _zsVersion
- Figure: Only a "Schema Master" checks in the .sql files
Do you feel this rule needs an update?