Re: [cobalt-developers] MySQL vs Interbase

["William L. Thomson Jr." <support@xxxxxxxxxxxxxxxxxxxx>]

Jeff,

On Sat, 2003-01-25 at 10:48, Jeff Zanzinger wrote:
> We are trying to decide on a database to use on our newly installed raq3
> w/raq4 software upgrade.  
> 
> We use perl API to interface with database.  We're coming from a MySQL
> environment and were wondering if any body had preference regarding the
> two.  Your comments are greatly appreciated!!

The two are quite different. Open Source InterBase 6.0 is a stagnant
project. A project called Firebird has picked up where they left off.
So really in your case you are considering MySQL or Firebird. Unless you
want to go to Borland and purchase a license for IB 6.5 or 7.0.

Now with that said MySQL is not a SQL-92 compliant database engine. It
has no support for triggers, stored procedures, and a variety of other
things that SQL-92 compliant db all have.

PostgreSQL is closer to compare with Firebird/InterBase than MySQL.

Now depending on your future plans, Firebird is available for and runs
on just about OS out there.

Not to mention that Firebird licensing allows it to be embedded in third
party apps. MySQL would require a license at that point, because a
company still owns and is responsible for MySQL.

They do not sell what you need for a web site or such, but if you try to
embed that db and engine in a app of your own you will need to pay for
licensing rights.

Now as for the perl thing, I am mostly a Java guy. However I have heard
about perl modules being available for InterBase, which should still
work with Firebird. I am not sure if Firebird will have any native Perl
modules any time soon, but eventually they will.

Beyond that search google and the 

http://www.phpbuilder.com/annotate/message.php3?id=1011263
http://archive.develooper.com/dbi-users@xxxxxxxx/msg14891.html
http://www.debianlinux.net/databases.html

Personally I use Firebird. I started with InterBase and then migrated to
Firebird.

I prefer Firebird over any other RDMS out there. It has a variety of
management tools for all OS. It has a great community of very
knowledgeable and friendly people always willing to help.

It has been around and in development since 1984. It's very stable,
reliable and robust.

But that's just my 2 cents.


> Jeff Zanzinger
> 
> 
> _______________________________________________
> cobalt-developers mailing list
> cobalt-developers@xxxxxxxxxxxxxxx
> http://list.cobalt.com/mailman/listinfo/cobalt-developers
> 
-- 
Sincerely,
William L. Thomson Jr.
Support Group
Obsidian-Studios Inc.
439 Amber Way
Petaluma, Ca. 94952
Phone  707.766.9509
Fax    707.766.8989
http://www.obsidian-studios.com