Thread: Comparision of DBs (new to list)

Hi - I'm new to the list - G'Day to everyone!

Q: Is there a product comparison matrix (either static or
like crash-me at MySQL)?
http://www.mysql.com/information/crash-me.php

I would like to compare:
PostgreSQL 7.1, M$ SQL Server 7+ and Oracle 9i.

I could not find anything searching the archives.

Thanks in advance, Kym Farnik (mailto:kym@recalldesign.com)
-- Recall Design     http://www.recalldesign.com

> Q: Is there a product comparison matrix (either static or
> like crash-me at MySQL)?
> http://www.mysql.com/information/crash-me.php
>
> I would like to compare:
> PostgreSQL 7.1, M$ SQL Server 7+ and Oracle 9i.

I haven't found exact comparisons either. They are good to get a general idea
about the capabilites if you would just like a starting place, however I
would not use solely such a comparison for an important decision. One problem
I found with mysql's crashme is that it was somewhat misleading. By that I
don't mean to say that the mysql team has intentionally distorted anything.
What I mean is that it is quite hard to measure exact feature translations
from different databases.

For example, mysql (an I believe mssql) uses "auto_increment" to assign a
number to a record automatically. PostgreSQL uses sequences, which are a
different approach that can accomplish the same goal. I don't think that the
mysql crashme recognizes that postgres can accomplish this task, since it
can't be accomplished in the same exact way.

So, for a real comparison, read some documentation about each database, and
determine how/if you could implement your required features in each. After
that, of course, you can see if a database seems to be more stable or faster
or easier to work with than another that met your requirements.

You can also always ask a mailing list how you accomplish a given task in
their respective database, and see if you like it more/less than another
database.

Of course, all this testing & experimentation is much cheaper with a free
database like postgres.

Regards,
    Jeff

Hi - Thanks - thats why I asked, the crashme tests take an MySQL
perspective whereas I would like a PGsql perspective.
BTW: Oracle product comparisons do an Oracle perspective,
M$ do a M$ perspective, FredBlogSQL does a FredBlogSQL perspective
etc.
IT Marketing - don't you love it!  :-)
Kym

> Kym Wrote:
> Q: Is there a product comparison matrix (either static or
> > like crash-me at MySQL)?
> > http://www.mysql.com/information/crash-me.php
> >
> > I would like to compare:
> > PostgreSQL 7.1, M$ SQL Server 7+ and Oracle 9i.

Jeff wrote:
>
> I haven't found exact comparisons either. They are good to get a
> general idea
> about the capabilites if you would just like a starting place, however I
> would not use solely such a comparison for an important decision.
> One problem
> I found with mysql's crashme is that it was somewhat misleading.
> By that I
> don't mean to say that the mysql team has intentionally distorted
> anything.
> What I mean is that it is quite hard to measure exact feature
> translations
> from different databases.
>
> For example, mysql (an I believe mssql) uses "auto_increment" to assign
a
> number to a record automatically. PostgreSQL uses sequences, which are a
> different approach that can accomplish the same goal. I don't
> think that the
> mysql crashme recognizes that postgres can accomplish this task, since
it
> can't be accomplished in the same exact way.
>
> So, for a real comparison, read some documentation about each
> database, and
> determine how/if you could implement your required features in
> each. After
> that, of course, you can see if a database seems to be more
> stable or faster
> or easier to work with than another that met your requirements.
>
> You can also always ask a mailing list how you accomplish a given task
in
> their respective database, and see if you like it more/less than another
> database.
>
> Of course, all this testing & experimentation is much cheaper with a
free
> database like postgres.
>
> Regards,
>     Jeff
>

Hi - Thanks - thats why I asked, the crashme tests take an MySQL
perspective whereas I would like a PGsql perspective.
BTW: Oracle product comparisons do an Oracle perspective,
M$ do a M$ perspective, FredBlogSQL does a FredBlogSQL perspective
etc.
IT Marketing - don't you love it!  :-)
Kym

> Kym Wrote:
> Q: Is there a product comparison matrix (either static or
> > like crash-me at MySQL)?
> > http://www.mysql.com/information/crash-me.php
> >
> > I would like to compare:
> > PostgreSQL 7.1, M$ SQL Server 7+ and Oracle 9i.

Jeff wrote:
>
> I haven't found exact comparisons either. They are good to get a
> general idea
> about the capabilites if you would just like a starting place, however I
> would not use solely such a comparison for an important decision.
> One problem
> I found with mysql's crashme is that it was somewhat misleading.
> By that I
> don't mean to say that the mysql team has intentionally distorted
> anything.
> What I mean is that it is quite hard to measure exact feature
> translations
> from different databases.
>
> For example, mysql (an I believe mssql) uses "auto_increment" to assign
a
> number to a record automatically. PostgreSQL uses sequences, which are a
> different approach that can accomplish the same goal. I don't
> think that the
> mysql crashme recognizes that postgres can accomplish this task, since
it
> can't be accomplished in the same exact way.
>
> So, for a real comparison, read some documentation about each
> database, and
> determine how/if you could implement your required features in
> each. After
> that, of course, you can see if a database seems to be more
> stable or faster
> or easier to work with than another that met your requirements.
>
> You can also always ask a mailing list how you accomplish a given task
in
> their respective database, and see if you like it more/less than another
> database.
>
> Of course, all this testing & experimentation is much cheaper with a
free
> database like postgres.
>
> Regards,
>     Jeff
>