StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POCollaborating on websites with relational databases and a CMS
text
Body
copied!<p>What processes do you put in place when collaborating in a small team on websites with databases? </p> <p>We have no problems working on site files as they are under revision control, so any number of our developers can work from any location on this aspect of a website.</p> <p>But, when database changes need to be made (either directly as part of the development or implicitly by making content changes in a CMS), obviously it is difficult for the different developers to then merge these database changes.</p> <p>Our approaches thus far have been limited to the following:</p> <ul> <li>Putting a content freeze on the production website and having <strong>all</strong> developers work on the <strong>same</strong> copy of the production database</li> <li>Delegating tasks that will involve database changes to <strong>one</strong> developer and then asking other developers to import a copy of that database once changes have been made; in the meantime other developers work only on site files under revision control</li> <li>Allowing developers to make changes to their own copy of the database for the sake of their own development, but then manually making these changes on all other copies of the database (e.g. providing other developers with an SQL import script pertaining to the database changes they have made)</li> </ul> <p>I'd be interested to know if you have any better suggestions.</p> <p><em>We work mainly with MySQL databases and at present do not keep track of revisions to these databases. The problems discussed above pertain mainly to Drupal and Wordpress sites where a good deal of the 'development' is carried out in conjunction with changes made to the database in the CMS.</em></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload