Re: Comparision of DBs (new to list)

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
>