[COLUG] Market review

[Balint, Jess]

Sure, PostgreSQL does have all the nice features that many high end
databases support, but I am talking more in terms of speed on large
databases. Sure it supports triggers, spl, whatever else, and I do like the
table inheritance but for one thing there is no support for using raw disk
for databases. In PostgreSQL, you must use a file in the filesystem. And
querying across databases? Even server instances? Unthinkable....

Now that Microsoft has a 64-bit version of SQL server, it is competing very
well in terms of scalability with DB2, Oracle.... I'm definitely not a
Microsoft advocate, but they also have support for many business
intelligence and olap tools, MicroStrategy, E.Piphany......

Not to mention other things needed for large transactional systems like
replication (GBorg?). PosgreSQL is good, but I just don't think it (yet) can
support larger databases. And why would somebody by a large database system
if not to use it for a large database?

In reply to Rob:

I don't know too much about Firebird/InterBase.. I'll have to check it out.
I have heard a few things about some partnering between MySQL and SAP for an
enterprise-MySQL. Also, MySQL doesn't support views, but it sounds like when
they do (2 years+?), they will be better than any other implementation
that's out there.

-- jess

> -----Original Message-----
> From: Jody McCluggage [mailto:jmccluggage at neo.rr.com]
> Sent: Wednesday, July 02, 2003 10:33 PM
> To: colug at colug.net
> Subject: RE: [COLUG] Market review
> 
> 
> PostgreSQL is a full featured and robust open source db (includes
> support for triggers, stored procedures, several programming 
> languages,
> row level locking, etc) that is very comparable to the big 
> boys (Oracle,
> DB2, MSSQL).  To this day I still do not understand why MySQL gets
> almost all the attention in the open source community and PostgreSQL
> almost gets none.  MySQL does not support most of the high 
> end features
> of PostrgeSQL.  True, if all you are doing is building a 
> simple back-end
> for your web app then MySql is your boy (due to its size and 
> speed).  I
> have used Postgre and have been very impressed with it.  
> 
> As for MSSql not being comparable to Oracle, I would disagree.  Since
> version 7 MS has been very serious about the high end db market and it
> shows.  MSSql is a very solid full featured db at a fraction of the
> price (heck, the DTS program that is packaged with it is almost worth
> the price alone).  That is why Oracle does not take MSSql for granted
> anymore. (they may publicly shrug of MSSql as a toy but their actions
> tell a different story).  The only thing the MSSql is lacking is
> internal support for a programming language which they will be
> addressing in their next release (which will support their .net
> languages).
> 
> At least that is my opinion.
> 
> Jody
> 
> -----Original Message-----
> From: colug-admin at colug.net [mailto:colug-admin at colug.net] On 
> Behalf Of
> rfunk at funknet.net
> Sent: Wednesday, July 02, 2003 9:57 PM
> To: colug at colug.net
> Subject: Re: [COLUG] Market review
> 
> Balint, Jess wrote:
> >I do not think that and Open Source database can compete 
> with MSSQL in
> terms
> >of speed and scalability. The current Open Source databases 
> are smaller
> >scaled
> 
> I'm no database guru, but I'm not so sure about this.  Firebird (which
> used to be the commercial system InterBase) and PostgreSQL have proven
> themselves worthy of some major scale.  MySQL has less of a
> scalability record, but its latest major release finally has a chance
> at competing with the big guys.  I'm not sure I'd put any of them up
> against Oracle, but I have no doubt that they'd be competitive with
> MSSQL.
> 
> -- 
> ==============================| "A slice of life isn't the whole cake
>  Rob Funk <rfunk at funknet.net> | One tooth will never make a full grin"
>  http://www.funknet.net/rfunk |    -- Chris Mars, "Stuck in Rewind"
> _______________________________________________
> colug mailing list
> colug at colug.net
> http://www.colug.net/mailman/listinfo/colug
> 
> 
> _______________________________________________
> colug mailing list
> colug at colug.net
> http://www.colug.net/mailman/listinfo/colug
>