1. Why can't OSS databases match commercial databases in the same way Apache meets/beats IIS and/or iPlanet (née Netscape)?
- The OSS databases do not have support from alot of 3rd party tools. This is getting better, but its still alot of problems out there. MySQL is a hardcore database that until some months ago lacked alot of funtionality that make it hard to use in ebiz. Postgress have had some of this functionality (FK and triggers) for some time but it got other problems.
2. What database should I use?
- I think it's important to look on databases as something transparent. The different databases all got positiv and negativ things bound to them.
Until Pear::DB came PHP had big trouble with this transparency. Perl got their DBI and this is very cool. I also find that most OSS developers have great pain adopting new technology (I use emacs, but the guys that started earlier than me still use vi as their main editor). When something "works" for a OSS "hacker" it's very hard to replace it.
Its also very hard (read: nearly impossible) to convert a big Microsoft SQL databases with SP, Views, ER to MySQL. This will change when MySQL supports the minimum funtionality needed to run a ebiz app.