Re: [Fofredux-devel] Re: other issues / comments

[Kevin <ke...@dr...>]

Andrew Turner wrote:

>Thanks for the quick succession/stream of development msgs. Actually
>brought up a bunch of good points. The primary issue being I am
>responsible for having checked in incomplete/bad code. I'm very sorry
>about that. I was rushing to get a baseline in for other people to
>fool around with and didn't do appropriate testing. I'll not do this
>in the future.
>
>Anyways, you're correct that we need to be able to handle
>updates/inserts of new tables. I believe Carlos was working on
>wrapping up the mysql calls to work with wither MySQL or PostgreSQL.
>Perhaps we can handle wrapping up clean select/inserts there? The
>other, easier, alternative is to add an "upgrade.php" that does tests
>and updates to tables as necessary. This could be a set of tests and
>inserts, or an actual intelligent upgrade depending on version number.
>  
>
>
ADODB supports updating a table schema to match a template.  It will add 
columns and change column types as needed.  It's pretty slick.  I prefer 
this to hand coding an intelligent upgrade script.

-Kevin