Re: Looking for an article
From:	"Ann W. Harrison" <aharrison@ibphoenix.com>  (IBPhoenix)
To:	"William L. Thomson Jr." <wlt@obsidian-studios.com>
Date:	06/21/07 12:02 PM
William L. Thomson Jr. wrote:

>
> Shocked that the project would not side with Jim on stuff. Guess we all
> have our own ideas and opinions. Guess with Jim's help MySQL will start
> to be a real contender with Fb. MySQL does have some things Fb doesn't,
> but most times it's MySQL that's lacking from my experience. At least
> with regard to standard stuff.

The real problem with MySQL is the number of non-standard features
is enormous and they have serious effects on adding new standard
features - what does it mean, for example, to check foreign key
dependencies on an 'insert ignore'?

>
> I was shocked that PostgreSQL only recently got roles. Managing large
> multiuser dbs must have been a pain.

Postgres has always been best for people who really like system
management.

Cheers,


Ann




From:	"Ann W. Harrison" <aharrison@ibphoenix.com>  (IBPhoenix)
To:	"William L. Thomson Jr." <wlt@obsidian-studios.com>
Date:	06/22/07 10:44 AM
William,

>
> Insert ignore, sounds like a oxymoron

It's a mass load that just dumps records that fail constraints -
normally primary / unique - and continues with the insert.

>
> .... Choosing PostgreSQL db versions was a
> pain. Seems neither MySQL or PostgreSQL are as version friendly as
> Firebird. I love the backward compliance of Firebird. I assume that in
> part is due to the RDBMS being around for so long. It's just normal
> practice now  Which is much appreciated.

That was a philosophy drilled into us at DEC which Jim managed
to make a serious belief of everybody who works on InterBase
and Firebird.

Cheers,


Ann