David,

That's for the valuable feedback.

Sean

-----Original Message-----
From: David J N Begley [mailto:d.begley@...]
Sent: Monday, August 28, 2000 12:23 PM
To: Developers Initiative IB (E-mail)
Subject: Re: [IBDI] Feedback requested -- Product Comparisons

On Mon, 28 Aug 2000, Leyne, Sean wrote:

> - Identify other open-source SQL DBMS which you consider to be
> real competitors to IB (not a simple list from the open-source.org web
> site)

PostgreSQL and MySQL are probably the only "real competitors" to
InterBase,
depending on what criteria you impose - it's not hard to just dig up a
list
of other potential competitors (for very loose definitions of
"competitors"):

http://freshmeat.net/appindex/Daemons/Database.html

> Additionally, while I am navigating through the loads of information
on
> the respective web sites, I would appreciate of direct feedback from
> those of you who have had direct experience with the other products
(or
> have done some recent product comparisons). I'm looking for is both
the
> good and the bad, as the products compare with IB.

http://www.PostgreSQL.org/docs/faq-english.html#1.14
http://openacs.org/philosophy/why-not-mysql.html
http://www.mysql.com/documentation/mysql/bychapter/manual_Comparisons.ht
ml

The biggest problem I've encountered with MySQL for anything beyond very
basic
databases is the lack of foreign keys, and the developers' incredible
excuse
for their absence (other problems too, but this one beat all else):

http://www.mysql.com/documentation/mysql/bychapter/manual_Compatibility.
html#Missing_Foreign_Keys

Positively, MySQL's multithreaded architecture runs really nicely on our
SMP
boxes to provide very fast read response. PostgreSQL uses a
process-per-client model (I thought even Oracle had starting moving
toward
multithreading).

Remember when reading above, claims of MySQL's lacking in features
(which, for
the most part, is quite true), remember that they've been trying to
remedy
that situation, even if just to tick a checkbox - for example
(transactions):

http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.ht
ml#BDB

Cheers..


dave



Community email addresses:
Post message: IBDI@onelist.com
Subscribe: IBDI-subscribe@onelist.com
Unsubscribe: IBDI-unsubscribe@onelist.com
List owner: IBDI-owner@onelist.com

Shortcut URL to this page:
http://www.onelist.com/community/IBDI