ZDNet UK


Skip to Main Content

ZDNet.co.uk - Winner of Best Business Website 2007
  1. Home
  2. News
  3. Blogs
  4. Reviews
  5. Jobs
  6. Resources
  7. Community
  8. My ZDNet

 

ZDNet UK RSS Feeds


Office applications Toolkit

Story: MySQL and Firebird battle for database top spot

  • Previous comment

Posted by: Anonymous (Thursday 27 January 2005, 1:02 PM)

  • Reply

The results do not really surprise me now I have had time to consider it. MySQL is not really aimed at the same market as FB and PG. Lack of ACID compliancy, and for a long time lack of stored procedures and triggers made it too primative to be used with mission critical data. It does plug really nicely into LAMP, so I do see a great future for MySQL. There are also some licensing rules that affect how developers can bundle MySQL.

PostgreSQL until recently had no windows build. It doesn't take a brain surgeon to work out that this is going to limit its market. Many small businesses do not have a linux box. Some would argue windows isn't the best environment for a dbms, I am not going down that path though. The latest version has some features that FB lacks, so I expect PG to increase its market share now Windows software developers can realistically use it.

Contrary to some peoples belief, Firebird was a popular dbms well before Mozilla named their project. It is a bit of a shame really, because now people question the motives of FBs reaction. To be honest, Firefox didn't exactly suffer as a result of the name clash either. FB has a tiny footprint (3MB), yet is surprisingly powerful. It shares a lot with its ancestor (Interbase) particularily with respect to ease of integration into the Borland tools.

Both FB and PG are serious threats to SQL Server and Oracle. I imagine that the big boys will always be around, but their marketability will shift from superior product through to legal indemnification for IP. I don't include MySQL in this list because it is a different market, although if MySQL introduces ACID compliancy, it may still be a three horse race.

I think it is great that there is not just an open source alternative, but several open source alternatives that we can judge on technical merit rather than simple licensing style.

  • Previous comment

  • Reply to this comment
  • Return to story
  • Report this as offensive


Full Talkback thread

Featured Talkback

Why do so many (virtually all) software packages think that they are so important that they have to be started automatically every time the computer boots? What is the largest number of "speed access", "update check", "camera download" and whatever other background programs you have ever seen running? Of those, how many did you really need?

By: J.A. Watson

Read full story:
Annoying software: a rogues' gallery

Discussions

thinkfeeldo thinkfeeldo

Chromatica Maycontrolus

Monday 8 September 2008, 6:16 AM

4 comments
roger andre roger andre

BBC must switch on to PC switch off

Sunday 7 September 2008, 11:50 PM

3 comments

Vista Upgrade Blog

Official MS Windows 7 Bloggers

Check this out: http://blogs.msdn.com/e7...spx Its an official blog "Engineering Windows 7" Nothing. That's what is revealed. Until there is real... More

5 comments

Microsoft's Mojave just a desert vista

It didn't seem fair to wade into Microsoft's “Mojave Experiment” advert quite so soon after the flat earth incident. But The Economist has no such qualms: in this week's issue, it wonders... More

6 comments

... But Still a Few Things Amiss (with...

It's not all roses with Vista, of course. I had my first BSOD over the weekend, when I was turning the laptop back on after suspending it. They typical long blurb about "If this is... More

6 comments