Personally, mySQL is a much more mature product than PostgreSQL. While both
have been around in the OSS world about the same amount of time, MySQL has
traditionally gotten the most attention from developers of both the server
and management tools.
MySQL is a very solid product, and in my opinion, just as solid as many of
the commercial SQL engines on the market. I actually think the tools that
are available for MySQL are far superior to those of Oracle and MS-SQL.
Tools like mySQL's QueryBrowser, SQLyog, Navicat, etc. offer lots.
PostgreSQL is an interesting beast. I like the server really well, but the
lack of tools is distracting. With only a few admin tools that are able to
connect to the latest version, it just makes it harder to use on a
day-by-day basis.
In the Telecom Systems department, we use both for our mission-critical
systems that support campus. Our PBX uses PostgreSQL internally with very
good results. Our cable television system and many of our aux application
use MySQL with good results as well. We have not run into any of the issues
that were in the OP's message (although we haven't deployed them in
situations that would utilize the newest features that they had issues
with).
-Nick Kwiatkowski
MSU Telecom Systems
On 1/9/09 1:49 PM, "Peter J Murray" <[log in to unmask]> wrote:
> What's wrong with PostgreSQL?
>
> Anyone have any commentary on it? Its a decent product from what I understand.
> I think MySQL is just more popular?
> ------Original Message------
> From: Oscar Castaneda
> Sender: MSU Network Administrators Group
> To: [log in to unmask]
> ReplyTo: Oscar Castaneda
> Subject: Re: [MSUNAG] The reliability of MySQL 5.1 code
> Sent: Jan 9, 2009 1:14 PM
>
> At the risk of starting one of those holy wars, I will make this comment:
> If I have to pay $20,000 for an Oracle license (as we did nine years
> ago) I would go for MySQL.
> If Oracle is going to have a nominal price, then I will go for Oracle
> before MySQL any day.
>
> Does Oracle has problems? Absolutely yes, as MySQL and Postgress, and
> windows, and linux and everything else does, but I think that it still
> is superior than MySQL in many areas.
>
> Of course, I am very well aware of the fact that most folks who favor
> linux and open source will go for MySQL.
>
> When you have an Oracle installation properly setup, you can just forget
> about it and it will always be running.
>
>
>
>
>
>
> Alec Warner wrote:
>> Who says the Oracle source code is any better off? :)
>>
>> -Alec
>>
>> On Fri, Jan 9, 2009 at 6:59 AM, Oscar Castaneda <[log in to unmask]> wrote:
>>
>>> MSU has a deal with Oracle. Since last year, MSU has a varsity license with
>>> Oracle and now is very cheap to get it.
>>>
>>>
>>>
>>>
>>>
>>>
>>>
------------------------
Nicholas Kwiatkowski
Communication Systems Analyst
Telecommunication Systems Department
Michigan State University
Direct: 517-432-2528
Dept / Customer Service / Trouble: 517-353-5515
E-Mail: [log in to unmask]
Website: www.telecom.msu.edu <http://www.telecom.msu.edu/>
|
