Results 1 to 13 of 13
  1. #1
    Join Date
    Mar 2007
    Location
    010101010110100
    Posts
    803

    Unanswered: How does mysql stack up against some of the other databases

    Hi all,

    I'm wondering what some of the opinions are on mysql. I have read a lot of material (biased) by a lot of people and propaganda that obviously push one database over another. I have a great respect for the people and their opinions on this forum and thought I may ask for everyone's opinion here.

    I personally never cared much for mysql because it always put an emphasis on speed and never focused on the "quality" or integrity of the data IMHO. I realize that mysql is trying to change that now by adding features such as triggers and sprocs.

    I am in the middle of making a UI in php for a mysql db. This db requires transactions. I have used other databases in the past and have been dreading the point when I would have to implement transactions in this database.

    After doing about 10 minutes of research, I found that as long as I am using Innodb, I am already set up for transactions and it defaults to "REPEATABLE READ"; I do not need to do anything else. Wow. I cannot believe that. Now that is simple indeed.

    I remember using transactions in postgres about 5 or 6 years ago and it was a pain from a programming standpoint. Mysql really has taken the pain out of using transactions. The ease of this database has really prompted me to ask around and see what everyone else thinks.

    I have heard mysql referred to as a “toy database” and a “File system” on many occasions. Does anyone have any opinions on that?


  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Ok, I'll launch the firestorm!

    Today (using MySQL 4.1 or later), MySQL is a real contender in the database world. MyISAM is still a file system, barely better than dBase, but Innodb is a real competitor in the database arena.

    At least in my opinion, versions of MySQL prior to 4.1 were both misleading (they would cheerfully process syntax for things like constraints, but never enforce those constraints), and downright dangerous to your network (extremely noisy and vulnerable to many forms of attack).

    The biggest problem that I see in trying to make these kind of judgements about a database engine is due to the nature of how Open Source works... MySQL is a strong contender these days, but the versions of MySQL that most people use are not. This is because most of the casual system administrator (which includes ISPs) take whatever comes on their distribution, which may be MySQL 3.x! Because of this one problem, I need to qualify my support for MySQL as a database for new users.

    -PatP

  3. #3
    Join Date
    Mar 2007
    Location
    010101010110100
    Posts
    803
    Thanks for the input Pat. I should have mentioned, I am using version 5.X.

  4. #4
    Join Date
    Nov 2007
    Posts
    7

    Wink

    I gotta a very very important question...
    How do you pronounce Innodb and MyISAM?

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by soonerlandrun
    How do you pronounce Innodb and MyISAM?
    eggzackly as dey are written

    kthxbai

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  7. #7
    Join Date
    Nov 2007
    Posts
    7
    eye-no-Dee-Bee

    and

    My-eye-Sam ??

  8. #8
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    in-no-d-b

    my-i-sam
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  9. #9
    Join Date
    Mar 2004
    Posts
    480
    Yeah but how do you pronounce sql?

  10. #10
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    s-q-l

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  11. #11
    Join Date
    Mar 2007
    Location
    636f6d7075746572
    Posts
    770
    Some say "squeal", not me though...

  12. #12
    Join Date
    Mar 2007
    Location
    010101010110100
    Posts
    803
    Or like the people in England "Ess Bloody Kue ell"!! I don't say "squeal" either.

  13. #13
    Join Date
    Mar 2007
    Location
    010101010110100
    Posts
    803
    I have a friend that is a programmer and he always says "squeal". It makes the little hairs on the back of my neck stand right on end when he does that. I think he knows that it irritates me.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •