Read my latest article: Planet Argon Blog (posted Wed, 17 Feb 2010 15:11:00 GMT)

MySQL is just a toy

Posted by Robby Russell Thu, 11 Sep 2008 18:04:00 GMT

10 comments Latest by Sam Granieri Tue, 16 Dec 2008 01:24:29 GMT

Twitterrific

Are you using PostgreSQL? EnterpriseDB want’s to hear your story at Postgres Rocks

Subscribe to my RSS feed Enjoying the content? Be sure to subscribe to my RSS feed.
Comments

Leave a response

  1. Avatar
    Dick Davies Fri, 12 Sep 2008 08:49:24 GMT

    a million mysql users: I’ve never had a problem with it. postgresql users: Yes, that’s why you’re still a mysql user.

  2. Avatar
    Joe Grossberg Fri, 12 Sep 2008 13:00:30 GMT

    When will PostgreSQL evangelists learn that “good enough” is good enough for 99% of web apps (i.e. low- to medium-traffic, simple data, basic CRUD)?

    People calling MySQL a “toy” is a counter-productive argument because it seems to imply that, if it works for you, your hard work must amount to a “toy” project.

  3. Avatar
    planetmcd Fri, 12 Sep 2008 13:46:15 GMT

    I prefer Postgres by leaps and bounds, but if MySQL works for you, good for you.

    I suppose the real issue here is whether MySQL is your choice because its popular or it fits your functionality level, and whether that matters.

    If I need a lightweight database I tend to go towards SQLite. If I need robust features straight away, I gravitate towards Postgres. MySQL can handle either cases though.

    I think the larger concern for MySQL users should be the dual license nature. What do you do when you want your product to go public? Do you need to buy a license. Currently not, when its a database backing a client server application but what if Sun changes their mind? Do you think your small start up, university, or non profit has the legal staff to challenge Sun’s? This is what scares me away from MySQL. With the availability of Postgres, I have a robust alternative that in many capacities meets or exceeds the functionality of MySQL, without the license issue.

  4. Avatar
    http://paulgresham.com Sat, 13 Sep 2008 06:50:32 GMT

    MySQL is a thin veneer above a set of decent technologies. Sleepycat (berkeley db) and Innodb were actually written by people that did know what they were doing. When MySQL tried to implement ACID, they simply couldn’t do it, they’re were a bunch of script kiddies that have risen off the backs of a talented few.

    Anyhow Innodb and Sleepycat are now owned by Oracle. Whereas the MySQL ‘brand’ and it’s veneer (some installers and an SQL parser) were bought by Sun for US$1Bn. Smell something wrong here? I certainly no longer own any shares in Sun.

    I still don’t understand, why use a system that is guaranteed to fail in such a way as to cause you hard to trace support issues? Job for life? Are you those types of people that just patch things up by hacking the database, think no more of it and go to fix the next error on some other system sitting on top of MySQL? If ‘good enough’ is the benchmark by which you develop software, go ahead and use MySQL, otherwise use a proper database.

  5. Avatar
    Sebastian Tue, 07 Oct 2008 21:18:45 GMT

    I also appreciate postresql, but in fact mysql has many users.

  6. Avatar
    Thomas Sun, 19 Oct 2008 12:30:33 GMT

    Hi,

    I have switched my Rails app from MySQL to PostgreSQL because of the license, and because Postgre has many features which I don’t use yet, and which will keep me busy on rainy weekends.

    With my very own mediocre benchmarks, I tend to see that Postgre is slightly faster than MySQL.

  7. Avatar
    Ed Fri, 14 Nov 2008 14:31:00 GMT

    My take on it:

    Despite superior performance, licensing, and features, PostgreSQL is just a very awkward name for software. I bet it if was called “Moo” or something like that it would be adopted very quickly by the Rails and open-source community.

    How exactly do you say “PostgreSQL”? It looks like gibberish.

  8. Avatar
    ehsanul Tue, 02 Dec 2008 19:02:22 GMT

    Umm, you say post-gres-Q-L, thought everyone knew that. I believe there’s still debate going on about whether the name should be changed, but seriously, that’s such a silly point to make compared to everything else.

  9. Avatar
    Thomas Glasgow Tue, 09 Dec 2008 19:50:01 GMT

    At our self-training video on demand website we are happily using PostgreSQL with our Rails 2.2.2 application. However using the correct Ruby gem for PostgreSQL can be tricky, here is the correct command to type: sudo gem install pg

    We pronounce “post-gre-S-Q-L”.

  10. Avatar
    Sam Granieri Tue, 16 Dec 2008 01:24:29 GMT

    I’m switching from mysql to postgresql in part due to to the licensing and ownership mess, the botched “release” of 5.1, and due to the influence of the Enterprise Rails book by Dan Chak, which could be one of the best Rails/Postgres resources out there. I also don’t like the arguments between sun’s marketing and monty widenus. It’s totally unprofessional

    By licensing mess, I mean the dual gpl/commercial license, and by ownership I don’t lie the fact Oracle owns InnoDB. Also, I think MySql stores database metadata in myisam tables, which is bad

Share your thoughts... (really...I want to hear them)

Comments