| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle vs Mysql
Back to MySQL and whether Postgres is the way to go,
I can recall editorials debating whether Unix/Oracle would ever be industrial strength enough to support critical applications.
The point the book "The Difference Between God and Larry Ellison" tries to make is that the technically superior product isn't always the one that succeeds. Often it is the one that is marketed better. A quick check of Amazon reveals several books devoted to MySQL, but I don't see any devoted to Postgres.
The story the author relates has to do with distributed databases. Ingres was developing a distributed database capability. Larry got wind of this and announced an new product "SQL*Star", that hadn't even been discussed within Oracle. When Ingres announced their product, the press asked "isn't than like Oracle's SQL*Star?".
My point is that each time these free databases are discussed, people mention the fact that Postgres is superior from a technical standpoint. But from what I see, often it is the best marketed product that prevails.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Tuesday, January 20, 2004 11:45 AM
To: Multiple recipients of list ORACLE-L
On Wed, 14 Jan 2004, eric king wrote:
> I think he is talking about 100GB database. Can PostgreSQL and MySQL
handle
> that size? We used MySQL in some of the web projects, but it just stores
> small set of operational data and later on those data are moved to Oracle
as
> a permenant store. For small set of data, MySQL is quite good, but it
lacks
> features such as foreign key constraints, triggers etc.
I seem to recall reports of Monty (the creator of MySQL) supporting terabyte size databases with earlier versions of MySQL. Not sure what types of storage systems were used to achieve that, though.
And to be fair, MySQL _does_ offer foreign key constraints (it used to not, though), but only (iirc) if you use the 'Innodb' table type. Now whether or not a database allowing some tables to have FK support and others not is a good proposition you'll have to judge for yourself.
I still prefer Pg to MySQL.
Fwiw,
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Jan 20 2004 - 12:29:25 CST
 |
 |