[oclug] Open Source Databases

[Mark Harrison]

----- Original Message ----- 
From: "Kevin Li" <y29li at engmail.uwaterloo.ca>
To: <oclug at lists.oclug.on.ca>
Sent: Monday, April 05, 2004 5:15 PM
Subject: [oclug] Open Source Databases


> 2. Why is MySQL so popular given it's lack of key enterprise database
features
> and hence why isn't PostgreSQL as popular given it's enterprise strengths?

For the same reasons that we have VHS recorders instead of BetaMax ones...

Most USERS don't choose databases based on comparative feature sets. They
normally choose databases based on (in order.)

- Application requirements
- O/S support
- Price

How do DEVELOPERS normally choose databases?

- What do they currently have?
- O/S support
- Technical Features
- Price

In my case, I need to run JReceiver (jreceiver.sourceforge.net), which ONLY
supports MySQL. Thus I have MySQL installed. Thus, when it came to writing
xAPdb (www.ascentium.co.uk/xap) and xAPlogger the database I used for
testing was MySQL. I believe that PostgresSQL will work fine with it, but if
you have a problem with my code, then I don't have it installed, nor the
inclination to install it simply to provide you with support... hence the
next developer (for example, www.mi4.biz)  is using xAPdb with MySQL to test
their Nuke addon... so the documentation for THAT will refer to MySQL as
well.

Regards,

Mark