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/>