Home
Do you have a "Schema Master"?
  v5.0 Posted at 29/07/2019 2:20 PM by Matthew Wicks
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

Related rules

    Do you feel this rule needs an update?

    If you want to be notified when this rule is updated, please enter your email address:

    Comments: