UsefulConcept

As we are finalizing all of the features for Savvy v 4.0 I am now looking at the install/upgrade process.

In the past to install you edit a config file, make a db, run the db sql script. Pretty easy. To upgrade you overwrite some files and maybe run an upgrade script.

I am thinking that in this release maybe we introduce a full install/upgrade script that makes the db, config file and upgrades the database (for existing installs).

What have people done in this regard? Any gotchas I should be aware of.

The only real kicker for testing here is that we support a few different DB's so the create table and update scripts are a bit different. Also there must be a lot of error handling to test for various possible problems before the install can continue. Something that has to be tested on various OS server platforms.

My initial thoughts are to run the test lines to check for tags enables, proper file access, etc. (already done) then create a config file if not already existing. Then connect to DB (must already be created and datasource already made) and from there it creates the DB. Check each table and field for existance and if not create it / them and populate any data that is needed (like admin account for new install).

As easy as the install is now, sometimes we run into issues with people and their config, with caching turned on, etc. Always possible to mess things up. Trying to automate may really help in this regard, or make it even more complicated...

Like this entry? Subscribe to my blog.