Louis-Philippe Huberdeau wrote:
> MySQL4.1 is still in development, and so is PHP5. Moving from MySQL3.x
> to 4.x will not be that much of a major change since everything that
> used to work still work. I run a dev version of php5 (pre-beta, didn't
> have time to upgrade) and mysql4.1 alpha on my test server and the
> standard mysql lib connects just fine with the MySQL server. Scripts
> won't suffer from that change.
>
> SQLLite will sure be a major part of PHP from now on. PHP developpers
> wanted to seperate PHP and MySQL for a while since PHP can do a lot
> more
> and most seemed to forget it. MySQL is powerful but it's not the only
> solution. PHP/MySQL is NOT a platform.
>
> As for your alter table problem, you might want to review your basic
> data architecture and use a relational table instead. You shouldn't
> need
> to modify a table structure that way all the time.

The tables are altered only when a new objective is added, which is very
rare. I would estimate it would happen perhaps once every three months at
the most. There are a list of objectives which are already defined from the
getgo, and these are quite comprehensive. The ability to modify this list is
provided simply for completeness, I doubt that it would be used very often.
relational tables seemed like overkill...