Skip to: Site menu | Main content

Self Healing Databases: Managing Schema Updates In The Field

Mon, Jan 15th 2007: Sydney, Australia:

Database schema update management is a problem that is overlooked by many web application developers initially, but once you have a number of deployments in the field it rapidly becomes a major headache to propagate schema changes in synch with your PHP, Python, or Perl application code.

Internet Vision Technologies has developed a technique for "self-healing databases" for the SiteBuilder web application suite, allowing updates to occur automatically in the field whenever new versions of the application are pushed out. This technique has been used successfully on a number of large scale deployments such as the Siemens intranet which runs on MySQL and uses over 2500 tables. The talk covers the overall methodology with specific examples from the SiteBuilder codebase.