2006-03-03

Automatic Schema Update

I've been working on ACal somewhat--on the database constructor method. I thought to myself, there's a good chance that the SQL database schema is going to change in the future. It would be very convenient if ACal automatically updated the schema as needed. And so I got to work and after about 3 hours of work and debugging, and 101 lines of code, it's a reality.

So now instead of doing this to upgrade the ACal calendar:

  1. Backup data.
  2. Delete database.
  3. Reinstall calendar.
  4. Import data.
It becomes a single step:
  1. Upgrade calendar.
So much nicer if I do say so myself. No other PHP system I know of does this right now.

0 comments: