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:[EMAIL PROTECTED]/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 > [EMAIL PROTECTED] > 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 _______________________________________________ cobalt-developers mailing list [EMAIL PROTECTED] http://list.cobalt.com/mailman/listinfo/cobalt-developers
