Hi Matt,
Here's my synopsis...
MySQL - Not free for commercial use
Not a full SQL implementation
Speedy(though I don't know how much this gap is with PgSQL 7.0 but
it has been closing with each new PgSQL release.)
Best used for simple read/write to tables (data storage)
PgSQL - FREE!
Very close to full SQL compatibility (especially with 7.0)
Very nice additional PgSQL special features
Some stuff poorly documented
Best used for more complex uses (data manipulation) or where SQL
compatibility is important or because it's FREE!
Me personally, I like PostgreSQL. I have never fallen under this performance
issue with it, though I have seen bench tests prove MySQL faster. I think it
is just a matter of choice. Most people ignore the fact that if MySQL is
used commercially, the authors expect to be paid. PostgreSQL is free under
the Berkeley license.
Best advice: Look at each set of docs to compare features for what YOU will
need. Run each (they don't conflict) and run some sample queries to see the
performance difference. Then judge for yourself. You will probably be happy
either way you go. Millions of people use each, so neither can be that bad.
So would anyone like to start an emacs vs vi war next? ;)
Have fun,
--
_________________________________________________________________
Brian Ashe CTO
[EMAIL PROTECTED] Dee-Web Software Services, LLC.
http://www.dee-web.com/
-----------------------------------------------------------------
Those who desire to give up Freedom in order to gain Security,
will not have, nor do they deserve, either one.
Tuesday, May 09, 2000, 1:54:01 PM, you wrote:
BM> What is the groups opinions regarding MySQL vs PostgreSQL?
BM> -----Original Message-----
BM> From: Ward William E PHDN [mailto:[EMAIL PROTECTED]]
BM> Sent: Tuesday, May 09, 2000 9:37 AM
BM> To: '[EMAIL PROTECTED]'
BM> Subject: RE: [OT] PostgreSQL gets commercial support/funding
BM> All I can say is this: (and it's facetious)
BM> Why the heck is he headquartered in Norfolk if he's calling it Great Bridge?
BM> If you know anything about the area (I live in the area), Great Bridge is in
BM> Chesapeake, Va.
BM> Hmmmm.... I'm a multihatted Database Admin/Developer from way back (Informix
BM> Universal Server and Sybase) and have played with Postgres for years... I
BM> wonder if I might be able to get in on the ground floor...... :)
BM> This is good news for the community; Frank Batten has been fairly forward
BM> thinking for a long time when it comes to modern communications (witness the
BM> Weather Channel, for example).
BM> Bill Ward
BM> -----Original Message-----
BM> From: Charles Galpin [mailto:[EMAIL PROTECTED]]
BM> Sent: Tuesday, May 09, 2000 11:14 AM
BM> To: [EMAIL PROTECTED]
BM> Cc: recipient.list.not.shown; @nswcphdn.navy.mil
BM> Subject: [OT] PostgreSQL gets commercial support/funding
BM> interesting news snippet..
BM> Red Hat Angel Investor Funds New Open-Source Software Startup to Take On
BM> Database Giants
BM> NORFOLK, Va., May 9, 2000 (BUSINESS WIRE) --
BM> Frank Batten Jr.'s new Great Bridge LLC to commercialize world's
BM> most advanced open-source database
BM> Landmark Communications, a large privately held media company whose chairman
BM> bankrolled Linux leader Red Hat Inc., announced it has funded a wholly owned
BM> subsidiary with the intention of doing for databases what Red Hat did for
BM> Linux
BM> and operating systems - give business a formidable open source alternative
BM> to
BM> existing proprietary applications.
BM> Newly formed Great Bridge LLC is backed by more than $25 million from
BM> Landmark
BM> Communications, a media conglomerate involved in broadcast, print and
BM> interactive media including The Weather Channel, the Virginian-Pilot
BM> newspaper,
BM> and weather.com. Batten funded Red Hat's successful launch and IPO last
BM> year,
BM> and served on its board of directors.
BM> As Red Hat has done for the open-source Linux operating system, Great Bridge
BM> will market commercial products, services and support for PostgreSQL
BM> (popularly
BM> called "Postgres"), a rapidly evolving, open-source database that rivals
BM> leading
BM> proprietary databases such as Oracle and Microsoft SQL Server in performance
BM> and
BM> features. After recently winning the prestigious LinuxWorld award for Best
BM> Database Management System, the judges said PostgreSQL "has become one of
BM> the
BM> most mature and powerful open-source tools available."
BM> Open-source software like PostgreSQL and Linux is freely owned, enhanced and
BM> supported by global grassroots communities of elite programmers, rather than
BM> by
BM> a single company. Working with this collaborative software community, Great
BM> Bridge will help proliferate the commercial adoption of Postgres by
BM> providing
BM> the financial stability, assurance and professional support organization
BM> corporate buyers require.
BM> The Postgres development community consists of hundreds of developers
BM> worldwide,
BM> guided by a six-member core steering group, similar to the way Linux creator
BM> Linus Torvalds oversees and screens new enhancements for Linux. A key member
BM> of
BM> the steering group is joining Great Bridge as a senior developer, and the
BM> company intends to recruit other members from the Postgres community as
BM> well.
BM> "While PostgreSQL's Internet presence is growing rapidly, commercial
BM> acceptance
BM> has been hampered by the lack of a large-scale support organization," said
BM> Bruce
BM> Momjian, a PostgreSQL core member and author of PostgreSQL: Introduction and
BM> Concepts (Addison-Wesley). "Even though we continue to make huge advances
BM> using
BM> the open-source development model, many businesses prefer to get database
BM> support from a trusted, professional enterprise. I am excited to see Great
BM> Bridge providing that support."
BM> Great Bridge will operate initially as a wholly owned subsidiary of
BM> Landmark,
BM> which under Batten's leadership has made significant investments in other
BM> technology companies over the past two years. Alfred Ritter, former Landmark
BM> executive vice president and CFO, will head the company as president and
BM> CEO.
BM> Robert Strickland, former Landmark chief technology officer who held senior
BM> technology officer positions at MediaOne, Harvard Business School and The
BM> Weather Channel, will serve as CTO. Ned Lilly, a veteran of several
BM> Landmark-funded web startups, will serve as vice president of open-source
BM> development. David Mele, a new ventures director at Landmark and former
BM> manager
BM> with Andersen Consulting, will serve as vice president of marketing.
BM> "We strongly believe that the open-source process is a fundamentally better
BM> way
BM> to develop software," said Frank Batten, Jr., Chairman of the Board,
BM> Landmark
BM> Communications. "Products like Red Hat Linux and Apache Web Server proved
BM> these
BM> technologies can be commercial successes thanks to the faster development
BM> cycles, fewer bugs and better flexibility their development communities were
BM> able to deliver. The next big venue for the open-source movement will be the
BM> database market. We scrutinized all the potential open-source database
BM> systems,
BM> and Postgres was by far the most sophisticated, ready-for-prime time
BM> offering."
BM> Postgres in progress
BM> Today's unveiling of Great Bridge coincides with the Postgres development
BM> community's launch of PostgreSQL version 7.0, which adds significant
BM> performance
BM> improvements, new querying capabilities, and over 300 other enhancements.
BM> While Great Bridge will officially open for business in August, the company
BM> has
BM> already made significant progress working with the Postgres community to
BM> help
BM> make the technology a commercial contender:
BM> --In March, Great Bridge hosted the first-ever face-to-face meeting of the
BM> PostgreSQL core developers- a three-day meeting in San Francisco at which
BM> the
BM> core steering group and Great Bridge agreed to coordinate their respective
BM> efforts on technology improvements, with Great Bridge focusing on
BM> identifying
BM> key product and service features required by business customers.
BM> --Great Bridge has established a testing and integration lab and initiated
BM> the
BM> most comprehensive benchmark tests of PostgreSQL to date to give corporate
BM> technology buyers fair and accurate product performance comparisons.
BM> --The company has launched what it believes is the most extensive market
BM> research program ever conducted for an open-source software product to help
BM> it
BM> better understand and meet customer needs, and lay the foundation for the
BM> company's business model. These efforts include an initial round of 32
BM> qualitative focus groups conducted across four U.S. cities and an ongoing
BM> program of statistically valid quantitative research.
BM> "While open-source development yields superior software, businesses have
BM> been
BM> reluctant to deploy open-source alternatives without a reliable,
BM> professional
BM> enterprise behind them. The Postgres community has done an exemplary job in
BM> developing a standards-based, object-relational SQL database that can handle
BM> the
BM> heaviest demands of many e-commerce and enterprise applications," said
BM> Ritter.
BM> "Postgres can only get better. The community will continue to develop its
BM> capabilities beyond the award-winning features and performance it has
BM> already
BM> achieved. We at Great Bridge will be active contributing members of the
BM> community. And, we are committed to providing the kind of service and
BM> support
BM> that will encourage businesses to enjoy the benefits of this open-source
BM> database."
BM> Great Bridge will unveil its initial product and service offerings in
BM> August,
BM> along with additional members of its management team, and information
BM> regarding
BM> its channel strategy and business model.
BM> About Great Bridge
BM> Great Bridge LLC is committed to making open-source software commercially
BM> viable, and will be the leading commercial provider of PostgreSQL database
BM> products, service and support. Headquartered in Norfolk, Va., Great Bridge
BM> is a
BM> wholly owned subsidiary of Landmark Communications Inc.
BM> (www.landmarkcom.com), a
BM> multinational media company with businesses in newspapers; broadcasting;
BM> cable
BM> programming; electronic publishing; and specialty media, including guide
BM> books,
BM> billboards, interactive media and a new career schools division. The
BM> privately
BM> held company employs more than 5,000 people worldwide.
BM> Distributed via COMTEX.
BM> Copyright (C) 2000 Business Wire. All rights reserved.
--
To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe"
as the Subject.
