RE: Oracle vs Mysql

Sounds like the old Oracle vs. Ingress battles. Oracle won because it was better at marketing. All detailed in the book "The Difference Between God and Larry Ellison". I can see it now -- MySQL, the Oracle of the free databases.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Wednesday, January 14, 2004 4:39 PM To: Multiple recipients of list ORACLE-L

Ryan,

        It's postgres.org. I'm not sure how they generate the operating revenue they need, but that's why they are not advertising like MySql AB is.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
Sent: Wednesday, January 14, 2004 5:05 PM To: Multiple recipients of list ORACLE-L

i thought postgre was a for profit company? how do they generate revenues? ----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, January 14, 2004 4:19 PM

> 1) DBI is a perl module to handle the communication with various
databases.
> 2) Postgres is free. I believe that you can buy commercial support, but I
don't know
> where. May be Rich can jump in with that.
> 3) DBI is free and so is perl. I'm cheap & easy, but not free.
>
>
> On 01/14/2004 02:34:52 PM, Ryan wrote:
> > what is DBI?
> >
> > is postgre free? Is it like linux where you pay for support? I cant find
any
> > licensing info on the website. Most shops dont need oracle, sql server,
> > sybase, or DB2.
> >
> > Most applications are small. I was on a project where the government had
an
> > Oracle EE license on windows. They didnt even use foreign key
constraints.
> > Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free
database
> > could have handled that.
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Wednesday, January 14, 2004 1:44 PM
> >
> >
> > >
> > > On 01/14/2004 12:44:25 PM, "Jesse, Rich" wrote:
> > > > If you have the choice, look at PostgreSQL in addition to MySQL.
From
> > what
> > > > I've seen, it's more mature than MySQL.
> > >
> > > I second that. PostgresSQL supports transactions and uses perl as its
> > > scripting language. From what little I read and saw (just a little
pilot
> > > project with the goal to see "what the heck is Postgres"), it's a very
> > > decent database, with a decent performance and capabilities sufficient
> > > for a small, departmental database server. I know nothing of
clustering,
> > > distributed database, database links, replication and alike. In other
> > words,
> > > I wouldn't use it for an enterprise-wide server for GE or Wall-Mart,
but
> > > it can be quite a convenient storage space for a small corner shop or
a
> > > small department. Because of perl and DBI, exchanging data with other
> > > servers like oracle or UDB (DB2) is easy.
> > >
> > > --
> > > Mladen Gogala
> > > Oracle DBA
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Mladen Gogala
> > > INET: mladen_at_wangtrading.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).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Ryan
> > INET: ryan.gaffuri_at_cox.net
> >
> > 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).
> >
>
> --
> Mladen Gogala
> Oracle DBA
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mladen Gogala
> INET: mladen_at_wangtrading.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ryan
  INET: ryan.gaffuri_at_cox.net

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: Goulet, Dick
  INET: DGoulet_at_vicr.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).
-- 
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).