PHP Classes

You're welcome

Recommend this page to a friend!

      Database structure synchronizer  >  All threads  >  You're welcome  >  (Un) Subscribe thread alerts  
Subject:You're welcome
Summary:questions, bug reports, suggestions?
Messages:6
Author:shadower
Date:2008-06-17 10:04:08
Update:2008-08-28 10:58:20
 

  1. You're welcome   Reply   Report abuse  
Picture of shadower shadower - 2008-06-17 10:04:10
Anyone, please feel free to post your questions, bugs and suggestions regarding the database structure synchronizer here. Let's do it a little better :)
Thanks in advance

  2. Re: You're welcome   Reply   Report abuse  
Picture of Valter Hall Valter Hall - 2008-07-15 21:34:46 - In reply to message 1 from shadower
Hello.
I didn't really understand what I should use this package for. Currently I work project/training with databases like:
CMS - for images, headlines, posts
Recepies - cooking
meeting/route - planner

How will I use the package?

  3. Re: You're welcome - I forgot my email   Reply   Report abuse  
Picture of Valter Hall Valter Hall - 2008-07-15 21:35:43 - In reply to message 1 from shadower
Hello.
I didn't really understand what I should use this package for. Currently I work project/training with databases like:
CMS - for images, headlines, posts
Recepies - cooking
meeting/route - planner

How will I use the package?

Valter Hall /Sweden


valterhall@hotmail.com

  4. Re: You're welcome   Reply   Report abuse  
Picture of shadower shadower - 2008-07-24 10:12:53 - In reply to message 3 from Valter Hall
Ok, as I can see I need to explain the package use cases in more details.
This package is useful when you have multiple copies of the same software that might have a little different mysql tables structure for some reason.

Some examples from the real life:

1. mysql software team development
Lets say you need to deligate some part of work to external developer. So you give him a copy of current sql tables with testing data and make new checkout of code from version control system (SVN for eample).
When the developer finishes his work, he commits his code changes to the SVN, so you can review them. He also gives you a database with the test data you may test the new feature at. But if you can easily see the cnahges in the code (php for example) with any diff program (like winMerge) there is no way for you to look at the changes made in the database structure as well as import those changes into your own working copy. Here database structure synchronizer (DSS) helps.

2. scripts for updating the software to the new version
Let's say you develop some software which uses mysql for storing data. Let's imagine your software comes with installation script which allows not only to setup the program from scratch, but also update existing installation from previous version to a new one. In this case you should have an SQL to create the tables in empty database as well as SQL which will just update existing tables structure. To generate proper update SQL code you might use the DSS.

  5. Improvements   Reply   Report abuse  
Picture of Andrea Ercolino Andrea Ercolino - 2008-08-27 07:17:40 - In reply to message 4 from shadower
Very useful. Thanks!

Are you going to add support for CONSTRAINTs ?

  6. Re: You're welcome   Reply   Report abuse  
Picture of shadower shadower - 2008-08-28 10:58:21 - In reply to message 5 from Andrea Ercolino
Thx for the idea! I am not so familiar with CONSTRAINTs as I prefer to have such functionality at code level instead. But I will think in this direction. Thx again.