[Toolsdev] MySQL versions on zydeco

[Dave Belfer-Shevett <dbs@homeport.org>]

On Fri, 2005-06-03 at 18:37 -0400, Hacksaw wrote:
> DBS, have you looked at recent postgresql implementations? In a related 
> question, have you upgrade MySql to their recent version, especially the one 
> with crude triggers?

It looks like the MySQL on Zydeco is 3.23.mumble, which is -ancient-.
SInce the distribution is based on Redhat 7.3, this is understandable,
but we can't really develop against this.

I'm Ccing Alex on this.  Alex, if we can upgrade MySQL on zydeco to 4.1,
that would be grand.  If you don't hasve the bandwidth, I'd like to
bring in Mort, who did all our Redhat-based MySQL upgrades about 6
months ago.

> People who are thinking about the schema: Has anyone identified a problem that 
> would be best solved with Postgresql's more complete triggers, or would 
> MySql's do, or do we need them at all?

CONGO manages its own triggers, usign the database as flat SQL storage.
I'd recommend using coded-in triggers rather than database-specific
triggers, to allow motion / ease migration in teh future.

	-dbs

-- 
Dave Belfer-Shevett <dbs@homeport.org>
Arisia Registration Geek