Richard,
Spoken like a true academic!! All the reasons below we do know but right now we are pointing out that Mysql is actually more widely deployed that your favorite postgreSQL and this is a fact that can't be disputed with academic reasoning but more with facts and proof. Personally the last time I tried PostgreSQL was about 3 years ago. I then tried mysql and I have never looked back since. PostgreSQL gave me so much headache just to setup and get it running ( all kinds of issues about postmaster running etc I even wondered whether postmaster was not my Mailer-Daemon :-) I am sure things are much better nowadays but it will take a lot to convince me to move form Mysql which has always worked reliably for me and the ease of use and availability of great howtos and documentation is a great added plus. Searching freshmeat projects section for mysql brings up so many apps that use it that it naturally makes it the better choice for me. Of course I don't put it up there with RDBMS like oracle however given a choice between MySQL,PostgreSQL and MSSQL I would chose MySQL but YMMV :-) Noah. > Mysql does a good job when it comes to integrating Mail Transfer Agents or > your Samba Domain Controller. There a couple if things it does well, and I > know thousands of websites use it as backend RDBMS. An article that says HP > runs mysql creates an impression that the cores Information Systems of HP are > supported by mysql. Which is wrong. In fact, HP runs it core business systems > on Oracle Real Application Cluster. ItÂs very rare to find corporate companies > running a single RDMBS. There many data centers which run some of their > information systems on Microsoft SQL (MSQL), and this doesnÂt mean MSQL comes > near the best. > Take an example of Jeremy from Yahoo finance: > http://jeremy.zawodny.com/mysql/sv.pm/mgp00003.html. He had the following > reasons for using mysql. > -speed > -reliability > - It has never crashed for us > -Ease of administration > -Excellent support > -features - replication > - Normal files > - Useful Add-ons > - Regular Expressions > -Cost > -Source Code Availability > -Available APIs. He had the courtesy to even say, ÂIt has never crashed for us > Â. What about other people? > JeremyÂs points for acclaiming mysql are very weak for anyone well read in > Database Management Systems. If you believe in learning, install a copy of > mysql (if you have been depending on news letters), Postgres and Oracle as a > starting point for your own evaluation. Trial downloads are also available for > DB2 and Sybase. Again, try out the commercial RDMBS, which have lots to offer > that has not yet been implemented in open source systems. > Take and example of the new implementations > (http://developer.postgresql.org/beta-history.txt) in Postgres which is my > favorite in open source systems. All the new things being implemented now in > postgres existed in Oracle8i and were perfected Oracle9i. Right now Oracle has > magical stuff with 10g. > So my dear friend, work around the village and you will stop praising your ... > as the best cook:) Richard. Ziggy David Lubowa writes: > > On Thu, 12 Aug 2004 14:04:02 +0300, Richard K Ssekibuule wrote > > > > It (MYSQL) continues to be the RDBMS of choice for some of the big boys: > > Yahoo!, > > > > Google, Cisco, Sabre Holdings, HP and NASA. > > > > ++ Actually the above is true , i know for a fact yahoo runs a mysql db > > Jeremy Zawodny's site can tell you more on what he does for yahoo e.t.c > > http://jeremy.zawodny.com/ > > > I highly doubt this report! If you have worked on database systems, > > > there is no way you can risk mission critical systems with the 'young' > > > architecture of mysql. Let us not mislead people with such articles. > > ++ I also dont dispute the fact the the rest of the mentioned companies > > also use mysql, the thing is you "cannot" say that mysql doesnt work or > > doesnt scale it depends on the nature of the problem and how you approach > > it. If you go on mysql site you will also see some of the accolades mysql > > has got over time. ++ Lastly i dont really think the article is misleading > > or else it would not be posted. Correct me if i am wrong - Z > > > > > > Richard. Kyohere Luke writes: > Interesting tho, that despite the latest > > > features and emerging benchmarks, > > > > mysql is still the most popular RDBMS used world-wide, with <QUOTE>more > > > > than five million active installations worldwide</QUOTE> > > It > > > continues to be the RDBMS of choice for some of the big boys: Yahoo!, > > > > Google, Cisco, Sabre Holdings, HP and NASA. > > Seems that the average > > > developer is not after features as much as he is > > > > after raw speed and ease of getting the application up and running. > > > > Most Popular Database? > > > > http://forums.devshed.com/t42653/s.html?highlight=treeview > > > > http://forums.devshed.com/showthread.php?s=&threadid=35171 > > Also, > > > php's popularity, as well as Apache's, has boosted mysql's with such > > > > acronyms as LAMP (Linux, Apache, Mysql, PHP). > > However, Postgresql > > > may benefit from mysql's latest licensing changes, i.e > > > > its changes some of its libraries from LGPL to the more restrictive > > > > GPL...which is causing heads to turn in the opensource world, especially > > > > with PHP developers, according to Internet News: > > > > http://www.internetnews.com/dev-news/article.php/3358061 > > Luke. > >> > > > Paul Bagyenda wrote: >> > > > >>> http://developer.postgresql.org/beta-history.txt >>> > > > >>> The beast keeps growing. While this is just a beta at this stage, > > > >>> there are a couple of things to look forward to: > > > >>> - Savepoints inside transactions: So that you don't have to rollback > > > >>> the entire transaction > > > >>> - Point-in-time recovery: Recover to a certain point in time > > > >>> - Separate disk storage using table spaces: Put one database on one > > > >>> partition and another on a different one, without using symbolic links > > > >>> and such. > > > >>> - Change column types using ALTER TABLE: Odd one this. What happens to > > > >>> the data if I change from varchar to int4?? > > > >>> - Server Runs on Win32: On WinNT based systems (WinNT/2000/XP) for the > > > >>> first time ever. (Not sure if this should matter much, but its been a > > > >>> bit of a gap!) > > > >> > > > >> Matters in terms of developers using it -> apps made that need it. I > > > >> doubt I would use mysql if postgresql ran as well on windows as mysql > > > >> does. >> > > > >>> > > > >>> All in all noteworthy improvements to what is quite a mature and > > > >>> flexible RDBMS. > > > >> >> > > > >> >> > > > >> --------------------------------------------- > > > >> This service is hosted on the Infocom network > > > >> http://www.infocom.co.ug >> > > > > > > -- > Kyohere Luke > > > > Systems Engineer > > > > One2net (U) LTD > > > --------------------------------------------- > > > > This service is hosted on the Infocom network > > > > http://www.infocom.co.ug --------------------------------------------- > > > This service is hosted on the Infocom network > > > http://www.infocom.co.ug > > Regards David Ziggy Lubowa --------------------------------------------- > > This service is hosted on the Infocom network > > http://www.infocom.co.ug > > > > > --------------------------------------------- > This service is hosted on the Infocom network > http://www.infocom.co.ug > --------------------------------------------- This service is hosted on the Infocom network http://www.infocom.co.ug
