October 23, 2009

Evolving A Database With MySQL

In present-day programming, the data storage is far from the static beast some people believe it once was. Lots of applications have their own piece of data storage in relational databases and the shape of that storage alters as often as the applications themselves: daily. The only problem is that while the structure must change often, the data just has to morph itself around that, and stay essentially what it was, but in the new form.

In this howto, I will show you how to "grow" your own database definition in a way that is maintainable. I will make so-called "recreate" scripts. These scripts can be used to both create a database from scratch and update an existing database. When I say database definition, it will not be limited to table structure, we will "grow" the data also. But not all of it. Only what's necessary...


Article Source HowtoForge
October 23, 2009, 6:25 am
Read More

Click Here!