Slashdot Mirror


MySQL To Be Ikea Of The Database Market

Rob wrote to mention an article discussing MySQL's intent to become 'the Ikea of databases'. From the piece: "While new entrants into the open source database market, such as EnterpriseDB and Pervasive Software, have made no secret of their intentions to chase Oracle's market share, Mr Mickos said MySQL is happy to leave them to it. 'We are thankful that they are there to define the market, there is no product if you're the only vendor,' he said. "Pervasive and EnterpriseDB are going up against Oracle. We don't want to be in that space, we don't want to take the heat from Oracle. If you're working in a zoo you don't want to be the one who has to brush the teeth of the lion.'"

242 comments

  1. No longer possible by dsginter · · Score: 0, Flamebait

    Now that Postgres has a pretty easy to use Windows installer, the benefits of MySQL are gone (though it befuddles me that *Windows*, of all things is what made MySQL successful in the first place).

    --
    More
    1. Re:No longer possible by bigman2003 · · Score: 5, Interesting

      Yes, Windows brought MySQL to me.

      I host my site on a commercial service, and previously I was stuck with using Access as my DB, unless I wanted to pay big SQL Server bucks. My site crashed 5 or 6 times a day because of the load on the database.

      Finally my hosting service started to offer MySQL, for free...

      My site stopped crashing, and now everything loads a lot faster. (I haven't converted the entire thing over to MySQL, but enough to stop the crashing.)

      If MySQL were not free, I would not have converted. If it were not on Windows, I would not have converted.

      But now I see it as a real possibility for use at work.

      --
      No reason to lie.
    2. Re:No longer possible by Kainaw · · Score: 4, Insightful

      Have you actually performed side-by-side comparisons using your own data? I have on many projects. Some are faster in Postgres. Some are faster in MySQL. Guess which one I use? Both. I use Postgres when it is faster. I use MySQL when it is faster. I refuse to be a blind moron like so many on Slashdot: Postgres is best. No, MySQL is best. Who cares - does it run Linux? No, Debian. That is Linux. I use BSD! Who cares, we're here to bash Windows!!!

      --
      The previous comment is purposely vague and generalized, but all of the facts are completely true.
    3. Re:No longer possible by nighty5 · · Score: 4, Informative

      If you're happy with MySQL than great.

      Its offered at most ASP's for next to nothing.

      But just to let you know PostgreSQL 8.x now offers a native build for Windows - and is extremely powerful.

    4. Re:No longer possible by hey! · · Score: 3, Interesting

      It's not the PG installer, it's the fact that Windows is now part of the official release that matters.

      Still, though, mindshare is a considerable issue. There's a lot more people familiar with MySQL admin and it's quirks than Postgres. And, a lot of F/OSS uses MySQL as a data store by default. While it is not uncommon to have both PG and MySQL as a choice, if there is only one choice out of the two it is more often MySQL than PG, although counterexamples are sure to exist.

      It will be interesting to see how these two projects evolve with respect to each other and how they end up positioned in a few years, now that a lot of the "first cut" elimination criteria have been eliminated (e.g. no subqueries/triggers for MySQL, no official Windows support for Postgres).

      --
      Post may contain irony: discontinue use if experiencing mood swings, nausea or elevated blood pressure.
    5. Re:No longer possible by bringmewater · · Score: 2, Funny

      Windows sucks !

    6. Re:No longer possible by ViceClown · · Score: 1

      Agreed. The installer and releases for windows are excellent, too, in my opinion. Combine that with the free version of http://www.sqlmanagner.net/ and Im one happy camper. I've ditched SQL Server for my own projects and have been happily using Postgresql on Linux and windows. Awesome product, IMHO, especially since the 8.0 release!!

      --
      Have a Happy.
    7. Re:No longer possible by Anonymous Coward · · Score: 0

      "If MySQL were not free, I would not have converted."

      That's actually why I'm using postgres at the moment instead. It's BSD, while MySQL is GPL. I believe it means that any program I write that links against the MySQL client libraries has to be GPLed also...or, you have to pay for a license. I don't object to them choosing the GPL, and I don't write commerical software (I'm a grad student)...but if I have a choice of licenses I prefer LGPL or BSD. If I use a GPL library, somewhere in the back of my mind I have to remember that. With LGPL or BSD, I can (for all practical purposes) forget about licenses and concentrate on more important things...like code.

    8. Re:No longer possible by ThaFooz · · Score: 2, Insightful

      Now that Postgres has a pretty easy to use Windows installer, the benefits of MySQL are gone (though it befuddles me that *Windows*, of all things is what made MySQL successful in the first place).

      The obvious counter argument is now that MySQL 5.0 supports strict data integrity, stored procedures, triggers, cursors, information schema, and database links, the benefits of Postres are gone.

      But that too would be an oversimplification. Really, they're both excellent products, and which one you use is a matter of buisness needs and personal preference.

    9. Re:No longer possible by CoughDropAddict · · Score: 2, Interesting

      If speed is your only criteria about what database is best, you should probably use SQLite. The last time they benchmarked its speed, it was significantly faster than both MySQL and PostgreSQL.

      But the real point of this post is that making speed your only criteria does make you sound like a blind moron. A database is much more than its speed characteristics. Other considerations are: quality of documentation, richness of data types, SQL features supported, options for locking and concurrency, options for writing procedures in the database, facilities for partitioning and controlling the growth of the data store, and much more.

      If these are not considerations for you, you are probably working on toy problems that would work just fine with SQLite.

    10. Re:No longer possible by Anonymous Coward · · Score: 0

      Doh!
      Speed is *not* the prime criteria when it comes to DBs. At least until now MySQL couldn't run any serious applications beyond filesystem replacement with a few indices.

    11. Re:No longer possible by Anonymous Coward · · Score: 0
      My site crashed 5 or 6 times a day because of the load on the database.

      Lucky you. Other people were less lucky with their SQL Sewer database. For them, it would fart 5 or 6 times a day

    12. Re:No longer possible by EraserMouseMan · · Score: 1

      Thanks for the advice. I was not aware that PostressSQL was available for Windows. So, what are the differences in how you install/configure/setup PostgressSQL vs MySQL? I really haven't worked with either. I downloaded MySQL a while back having never used it before and spent about two hours and it didn't seem anywhere near as easy to get going as MS SQL Server so I just gave up. But I'd really love to use one of the two. Could you briefly educate me on the main tradeoffs for each?

      Honestly it seems to me that PostresSQL would be a better choice but I'm just wondering why more people don't see that.

      Thanks in advance.

    13. Re:No longer possible by Anonymous Coward · · Score: 0

      One difference is that whereas MySQL and Firebird have supported Windows for many years, and they both perform on that platform approximately as well as they do on *nix, the PostgreSQL support for Windows is new, and the performance abysmal.

      If you can suffer poor performance on Windows for another year or two until PG's Windows support matures, then PG is probably the best choice (it has the best feature set of the three). Otherwise, Firebird's feature set still dwarf's MySQL's, and it performs well on Windows.

    14. Re:No longer possible by consumer · · Score: 1

      SQLite is not as fast as MySQL for anything I've tried it on, especially simple read/write access. The test you're linking to is ancient.

    15. Re:No longer possible by MemoryDragon · · Score: 2, Informative

      Actually the windows performance of postgres is pretty up to par to the unix performance you have to tweak the settings like you have to do it in unix (read the various postgres performance guides). The performance used to be bad, but not anymore, since the cygwin layer has been dropped.

    16. Re:No longer possible by temojen · · Score: 1

      Actually, I built postgres on cygwin for a friend back in 1999 and even then it wasn't too bad (for his small database (~5000 products, ~300 customers)).

    17. Re:No longer possible by Anonymous Coward · · Score: 1, Insightful

      The obvious counter argument is now that MySQL 5.0 supports strict data integrity, stored procedures, triggers, cursors, information schema, and database links, the benefits of Postres are gone.

      Except that these features have been in Postres for a longer period of time and therefore have seen more stress testing. (Nothing against MySQL's QA.)

    18. Re:No longer possible by Sxooter · · Score: 1

      Wow, I can't believe some idiot modded your post as flamebait. It seems well thought out and truthful.

      I'd just like to point out that the performance of a database when handling only one user or running one batch file is generally considered uninteresting. It's how it behaves when 100, 1000, or 10000 people are hitting it at once that counts. And it's ability to be placed on bigger, faster hardware to handle load.

      In this category, MySQL quickly falls behind. PostgreSQL fairs quite a bit better, and Oracle rules the roost. This from an ardent PostgreSQL supporter, who thinks that, as time approaches infinity, PostgreSQL's performance will surpass Oracle's.

      --

      --- It is not the things we do which we regret the most, but the things which we don't do.
    19. Re:No longer possible by einhverfr · · Score: 1

      First of all, if you are running your high-load database on Windows, you are screwed regardless of which RDBMS you use (reasons have to do with FSYNC behavior). Most people want PostgreSQL on Windows for development and it is quite good for that. If you only run PostgreSQL on your Windows box, then you can make it work well. However, again, I don't recommend it for I/O specific reasons.

      There are some load-sensitive performance issues in PostgreSQL 8.0 on Windows, but many of these have been fixed in 8.1 beta.

      --

      LedgerSMB: Open source Accounting/ERP
    20. Re:No longer possible by einhverfr · · Score: 1

      I was not aware that PostressSQL was available for Windows. So, what are the differences in how you install/configure/setup PostgressSQL vs MySQL?

      In both cases, you run a Windows Installer? The current installer project for PostgreSQL also includes PGAdmin III (a GUI admin tool).

      Now, as for configuration, you should take a look at a couple of things:

      1) PostgreSQL uses a set of text-based configuration files (pg_hba.conf and postgresql.conf) and it is worth being familiar with these though for development use the default settings are probably OK.

      2) You will want to become familiar with server variables and query plans if you want to do performance tuning.

      3) User rights maintenance is fundamentally different in MySQL, PostgreSQL 8.0 and PostgreSQL 8.1 Beta.

      ** MySQL has users, no groups
      ** PG 8.0 has users and groups, but no nested groups
      ** PG 8.1 beta has users and groups as instances of nestable roles.

      Also, take a look at my web site White Papers Section for a paper on migrating from MySQL to PostgreSQL.

      --

      LedgerSMB: Open source Accounting/ERP
    21. Re:No longer possible by einhverfr · · Score: 1

      But probably not too many concurrent connections....

      That was the biggest limitation of the Cygwin builds.

      As for the WIndows builds of PG8, it is more scalable but still has some performance issues under high load that are mostly resolved in Pg 8.1 beta, but I would still stear away from Windows for production databases because of issues in how FSYNC works. When I worked at Microsoft, I saw so many more cases of SQL Server db corruption based on power outages than I have ever seen on the PostgreSQL forums (every case in the PostgreSQL forums I have seen has been due to bad hardware).

      --

      LedgerSMB: Open source Accounting/ERP
    22. Re:No longer possible by temojen · · Score: 1

      Yeah, not too many concurrent connections. Fortunately I convinced him to scrounge up a used Pentium to run it on (he was a small independant retailer, and used it for his till & special orders tracking).

    23. Re:No longer possible by EraserMouseMan · · Score: 1

      This is awesome! Thanks for the advice!

  2. Ikea, eh? by VitrosChemistryAnaly · · Score: 3, Funny

    Well then where my steaming plate of Swedish meatballs? Huh? Where are they?

    And how can I deck out my house in mid-century modern MySQL? I'd like to see that.

    Pfft, yet another tease.

    --
    "It's a tarp!" -- Dyslexic Admiral Ackbar
    1. Re:Ikea, eh? by SomeoneGotMyNick · · Score: 5, Funny

      And how can I deck out my house in mid-century modern MySQL? I'd like to see that.

      There's a large supply of tables to choose from. You even put them together yourself. Just name them Coffee, Kitchen, End, etc.

    2. Re:Ikea, eh? by computerdude33 · · Score: 3, Funny

      Ikea?

      Oh, you mean Pikea.

      --
      computerdude33's stuff: My blog of wonder.
    3. Re:Ikea, eh? by loconet · · Score: 1

      Not to mention that installation is way too easy..

      --
      [alk]
    4. Re:Ikea, eh? by Achoi77 · · Score: 1
      For people that don't recognize what parent is referring to, IKEA (the one near my home anyways) has a little dining/cafeteria section, where they sell -among other foodstuffs- Swedish meatballs. They are pretty tasty.

      I suppose using the term 'steaming pile' is more commonly associated with excrement, but then again parent was going for funny. Well, now it's not that funny any more since I've had to explain the joke. Sorry!

    5. Re:Ikea, eh? by Anonymous Coward · · Score: 0

      No no no, they should be named: "Billy", "Lars", "Sven"

    6. Re:Ikea, eh? by Anonymous Coward · · Score: 0

      Well then where my steaming plate of Swedish meatballs? Huh? Where are they?

      And how can I deck out my house in mid-century modern MySQL? I'd like to see that.


      They are intent on becoming the Ikea OF THE DATABASE MARKET... not intent on actually becoming ikea!

    7. Re:Ikea, eh? by Philodoxx · · Score: 1

      And with the right combination of joins and foreign keys, those tables can be made to suit any occasion.

      --
      Oh, a lesson in history from Mr. I'm my own grandpa.
    8. Re:Ikea, eh? by uacheesehead · · Score: 1

      That is the worst metaphor I've ever heard. MySQL = Ikea? Lame.

    9. Re:Ikea, eh? by Jesus_666 · · Score: 1

      There's a large supply of tables to choose from. You even put them together yourself. Just name them Coffee, Kitchen, End, etc.

      I think Eksjö, Björkudden or Nygård would be better names.

      --
      USE HOT GRITS WITH STATUE OF NATALIE PORTMAN (NAKED AND PETRIFIED)
    10. Re:Ikea, eh? by Crayon+Kid · · Score: 1

      Plus, don't wanna be the one who brushes the lion's teeth? How about being the one that wipes his ass?

      --
      i ate crayons when i was a kid and now i have two braincells and the blue ones taste nicer
  3. Does that mean... by drunkennewfiemidget · · Score: 5, Funny

    That every installation comes with an Allen key and crappy instructions?

    1. Re:Does that mean... by Biking+Viking · · Score: 1

      Does this mean... that once you query the DB, you have to walk through all the tables before you can exit?

    2. Re:Does that mean... by program21 · · Score: 2, Funny

      Not only crappy instructions, but products with minimal evidence of quality control? Database tables that wobble? I wonder what that would look like ...

      --
      This has been a test. Had this been a real emergency, we would have fled in terror and you would not have been informed.
    3. Re:Does that mean... by PeeAitchPee · · Score: 3, Funny

      I need tungsten to live . . . TUNGSTEN!!!!

    4. Re:Does that mean... by Anonymous Coward · · Score: 0

      Take a look at MySql.

    5. Re:Does that mean... by Dr.+Evil · · Score: 2, Insightful

      I don't know how they manage Ikea in your area, but comparing MySQL to Ikea is an insult to Ikea.

      I'd describe Ikea something like this:

      Choose two:

      • Practical
      • Inexpensive
      • Attractive

      Whereas MySQL would be something like this:

      Choose three:

      • Streamlined features
      • Fast
      • Lossy
    6. Re:Does that mean... by sakri · · Score: 3, Funny

      oh great, now my wife is gonna start nagging me about installing mysql??

    7. Re:Does that mean... by program21 · · Score: 1

      There's more to Ikea furniture than just "practical," "inexpensive," and "attractive," though having recently spent a whole weekend putting together Ikea stuff for a friend, I will agree that these qualities do apply.

      I would also add "difficult-to-follow instructions" to that. Sometimes a picture is worth a thousand words, but when the pictures are instructions, and scale isn't accurately maintained or portrayed, it's a real pain to figure out which pieces and/or screws are meant, sometimes.

      Then I would also add "poor quality" to the list. A few of the items look/act good (namely, the couch and the chair, which required minimal assembly; the table also works well), but between three bookcases, two CD shelving units, and a TV stand with cabinets, you can really see the problems of Ikea furniture/self-assembly. The two bookcases that are next to each other have a gap between them that grows larger as you get higher; the glass doors of the third bookcase don't line up (though this is a construction issue, sure, but it's effectively impossible to get them lined up accurately) and one doesn't close all the way; the TV stand has legs of varying lengths, with the middle one being the longest, so it's very easy to spin it around or wobble it.

      And that's my rant about Ikea.

      --
      This has been a test. Had this been a real emergency, we would have fled in terror and you would not have been informed.
    8. Re:Does that mean... by Anzya · · Score: 1

      Personaly Im realy impressed by Ikea and their instructions.
      To make instructions that doesnt use any words are quite a good feat and I cant remember that I have ever had problem putting one of their furnitures together.
      And since I'm from sweden I have assembled my fair share of Ikea stuff :)

      Ikea spends lot of money on their instructions and there are many companies that are far worse than Ikea so I dont feel its right to complain about them.
      And as allways you get what you pay for

      --
      "This message was brought to you by Sarcasm and Troll Feeders United (or STFU, for you un-hip people)."
    9. Re:Does that mean... by Doctor+Memory · · Score: 1

      Actually, Ikea's "expensive" stuff is pretty good. I think I spent around US$90 for a large bookcase (74"x96"?). Three moves later, it's holding up just fine. Compare this to the local big box office retail bookcase I bought for US$25, that looks like crap (smudged finish, chipped corner). And it's only three months old!

      Maybe that's what MySQL is trying to get at: if you spend the bux to get a high-end version, it's great, but if you stick with the low-end version, your tables will wobble :).

      --
      Just junk food for thought...
    10. Re:Does that mean... by aconkling · · Score: 1

      That every installation comes with an Allen key and crappy instructions?

      I'm not targeting the OP of this comment; there are plenty of other comments like it. However, it seems like it's just a case of a bad and misleading headline--something we see a lot of on many of these e-news sites [sigh]. If you look at what it says in the article, Mr. Mickos is simply talking about large companies (yes Ikea, but also RyanAir and Virgin Mobile) that have targeted "service and innovation" (to quote the article). While one may question the quality of Ikea products, I think the point is that they're widely popular and while you could spend more money for a "better" (in one way or another) piece of furniture, many--many--are quite happy to buy from Ikea and look no further. It meets their needs and they don't need anything more. Kinda like MySQL v. Oracle... wait, this is starting to sound familiar....

    11. Re:Does that mean... by ScottyH · · Score: 1

      Dude, Ikea instructions rock. I actually feel excited about assembling something so that I can see the interesting ways they present the steps.

    12. Re:Does that mean... by StressedEd · · Score: 1
      ...your tables will wobble :)


      Oooo... stop it!! First three rules of comedy; no puns, no puns and no puns. :-)

      --
      Be nice to people on the way up. You will meet them again on your way down!
    13. Re:Does that mean... by XdevXnull · · Score: 1

      If you create your own captions to some of the instructions, they're freaking hi-larious.

      1) "After assembling, please do not immediately have sex with your new Billy."
      2) "Instead, it is important to carress it and get it in the mood."

      --
      "I'm a Laver, not a Phyto[plankton]"
    14. Re:Does that mean... by slim · · Score: 1

      Personaly Im realy impressed by Ikea and their instructions.

      Me too. I've put together quite a lot of flatpack stuff in my time, and in general Ikea's is by far the best designed and has the clearest instructions. Parts are often designed so you cannot put them in the wrong place (cf. all the differently shaped connectors on the back of a PC).

      I always use a hex bit in a socket screwdriver to assemble flatpack furniture. Recently, fixing metal leg attachments to a TV bench, I was perplexed to see that the instructions wanted me to tighten two screws in most of the way, then position keyhole-shaped holes in the leg attachment over the screws, then tighten the screws the rest of the way. Why not just push the screws through normal holes into the screw-hole in the conventional manner?

      Then I realised - if I'd been using the allen key provided, the legs would have prevented me from doing a full turn of the key. Ikea's designers had specified keyhole shaped holes in the leg attachments so that allen key users wouldn't get frustrated. THAT is attention to detail.

      I'm also always impressed at the way they constantly refine their designs to shave off every last wasted penny. By moving house a lot, I've bought various configurations of Billy shelving, and I've noticed that as time goes on, fewer and fewer of the chipboard surfaces are laminated. By the time the unit is built, of course, the unfinished parts are always out of view. It's efficient and (in an engineering sense) elegant.

      Ikea's cheapest products can be a bit shakey -- that's why they're so cheap. Spend a little more and you get terrific quality for the money.

      (I speak of Ikea in the UK -- I don't know how prices or product lines are in the States).

    15. Re:Does that mean... by stuntpope · · Score: 1

      And hope your installation doesn't get Bork, Borked!

    16. Re:Does that mean... by Christopher_G_Lewis · · Score: 1

      And in a couple of years you throw it out to get a real piece of furniture?

    17. Re:Does that mean... by ksheff · · Score: 1

      why do you keep on buying Ikea products if they are poor quality?

      --
      the good ground has been paved over by suicidal maniacs
    18. Re:Does that mean... by program21 · · Score: 1
      why do you keep on buying Ikea products if they are poor quality?

      I don't. I helped a friend put some together, but they had already been purchased and it was my first, and thus far, only, experience with Ikea furniture (but given the variety of products and high incidence of problems, it's exceedingly unlikely this was a "bad batch" or some such thing).

      Indeed, I accompanied this friend to Ikea (she wanted to pick up a few other, non-base furniture stuff) and I made a point of refusing to purchase anything, including a hot dog, on the grounds that I wasn't going to give any money to a company that produces products of such poor quality.

      --
      This has been a test. Had this been a real emergency, we would have fled in terror and you would not have been informed.
    19. Re:Does that mean... by Dr.+Evil · · Score: 2, Informative

      Not to say all the stuff is great, but there are some tricks to putting it together properly. It sounds like you might have nailed the back on to the bookshelves before making sure they were completely straight. The backs keep them rigid, some of their stuff has grooves to minimize how crooked you can make them by putting the backs on wrong, but for some peices, you can be off by a half-centimeter or so even if you're careful. It's not in the instructions, you just have to have put one together crooked to realize it. I can only check this with a square or nailing in the upper half of the backing, then lifting the peice upright before lining it up straight then nailing in the rest of the back.

      I'm not sure about how you aligned the glass doors, but once the thing is in place, I loosen off the screws so that the doors are loosely held, then I close the doors carefully and use something like a spatula to pry the doors into the right spot, then I open up the doors and tighten them appropriately.

      But if the back isn't on quite straight, the glass doors will never look quite correct.

      I haven't done a lot of their stuff, but every time you do one, you learn a little bit more about what can go wrong. You might have just taken on too big a job for a first-time assembler :-)

  4. to become the ikea of databases? by Anonymous Coward · · Score: 0

    I think they already are - and I don't think thats good thing.
    I would rather try to become the mercedes benz of databases...

    1. Re:to become the ikea of databases? by mark2003 · · Score: 1

      Why?

      IKEA is the world's largest furniture seller and makes much more money than any of the more upmarket furniture sellers.

      Something you generally learn pretty quickly in IT (or should) is that you make what the customer wants - no point building a Rolls Royce if the customer wants something cheap to get the shops and back.

  5. So Varients Will Have Nordic Names? by geoffrobinson · · Score: 3, Funny

    Do you want the Svansbo or the Dalsfor installation?

    --
    Except for ending slavery, the Nazis, communism, & securing American independence, war has never solved anything.
    1. Re:So Varients Will Have Nordic Names? by WWWWolf · · Score: 1
      Do you want the Svansbo or the Dalsfor installation?

      Yeah, Swedish stuff will do. Can't use much of Finnish stuff, really, they'd only be known for the specific terminology uttered by the installers - leading to "Perkele" databases.

  6. Acknowledgement? by joshsnow · · Score: 4, Insightful

    Pervasive and EnterpriseDB are going up against Oracle. We don't want to be in that space, we don't want to take the heat from Oracle. If you're working in a zoo you don't want to be the one who has to brush the teeth of the lion.

    That should nip the "MySQL is a replacement for Oracle under all circumstances" posts that always appear whenever MySQL is discussed on slashdot. It should, but it won't.

    OIn a different note, isn't the "Ikea of databases" space already a little overcrowded? There's Firebird, McKoi, One$DB/Daffodil DB, Cloudscape, Postgres etc. Guess MySQL already pretty much own that space, so this is just a reaffirmation that they're sticking to their knitting. Doing what they do best. Very wise.

    1. Re:Acknowledgement? by mmkkbb · · Score: 5, Funny

      No NO NO!

      PostgreSQL is the Pottery Barn of the Database market.
      McKoi and Cloudscape are Pier 1 and Crate and Barrel, respectively.

      --
      -mkb
    2. Re:Acknowledgement? by should_be_linear · · Score: 1

      That should nip the "MySQL is a replacement for Oracle under all circumstances" posts that always appear whenever MySQL is discussed on slashdot.

      In my experience there is lot more of "PostgreSQL 8 is a replacement for MySQL under all circumstances".

      --
      839*929
    3. Re:Acknowledgement? by superid · · Score: 3, Funny

      Everybody makes fun of the poëpli databses....

    4. Re:Acknowledgement? by budgenator · · Score: 1

      Most posts I remember is when MySQL hits the wall, you're ready for replacement with Oracle, when Postgres hits the wall and you're ready for Oracle replacement, you've got three steps farther than you would have with MySQL. I suppose that changing a database is relativly easy, changing databases well is relatively hard. If your astute enough of a DBA or database programmer to do both, then you'd know that neither MySQL nor Postgres is a replacement for Oracle and vica versa.

      --
      Apocalypse Cancelled, Sorry, No Ticket Refunds
    5. Re:Acknowledgement? by UnknowingFool · · Score: 1
      No NO NO!

      PostgreSQL is the Pottery Barn of the Database market. McKoi and Cloudscape are Pier 1 and Crate and Barrel, respectively.

      What I find interesting is that you would know the difference between all those places. I know I don't. :P

      --
      Well, there's spam egg sausage and spam, that's not got much spam in it.
  7. Like Ikea... by waif69 · · Score: 4, Insightful

    ...you can take it home without a big transport, you have to figure out what they mean by odd instructions and you have to perform the assembly yourself, but when you are done you can save a bundle if your time is not that valuable.

    1. Re:Like Ikea... by bill_mcgonigle · · Score: 1

      And Ikea furniture tends to break if you put something too heavy on it and the drawers don't have very good runners.

      Trouble is, when Ethan Allan is priced the same as Ikea it's hard to justify Ikea, except "everybody goes to Ikea".

      --
      My God, it's Full of Source!
      OUTSIDE_IP=$(dig +short my.ip @outsideip.net)
    2. Re:Like Ikea... by EvilTwinSkippy · · Score: 1
      Trouble is, when Ethan Allan is priced the same as Ikea it's hard to justify Ikea, except "everybody goes to Ikea".

      And Smaeland, your forgot Smaeland!

      --
      "Learning is not compulsory... neither is survival."
      --Dr.W.Edwards Deming
  8. Enterprise features? by lowe0 · · Score: 5, Insightful

    Since when are stored procedures, triggers, and views (freaking VIEWS) enterprise features? Log shipping or automatic failover are enterprise features. Procs and views are basics.

    1. Re:Enterprise features? by LDoggg_ · · Score: 1

      How about sequences? Last time I checked it wasn't even on the roadmap.

      Auto-increment is nice, but not when you have child records that you'd like to write in one transaction.
      This seems like such a trivial feature to add.

      You could create a table with just a single auto increment field and then insert null and get the last inserted id per connection, but it seems like such a hack to do so.

      --

      "If they have both, tell them we use Linux. And if they have that, tell them the computers are down." -Dave Chapelle
    2. Re:Enterprise features? by Anonymous Coward · · Score: 0

      Not to mention SQL...

    3. Re:Enterprise features? by consumer · · Score: 1

      Since simple web databases (e.g. the one storing your comments) don't actually need them.

    4. Re:Enterprise features? by Anonymous Coward · · Score: 0

      Simple web databases do actually need them, it's just that simple web programmers who don't actually understand SQL have been brainwashed to think that they should just re-invent the wheel.

    5. Re:Enterprise features? by Anonymous Coward · · Score: 0

      Easy to say, if you don't even *HAVE* them.

      Take views for instance. Ever done this in a programming language?

        function lengthInches() {
          return $this->length*12;
        }

        function lengthFeet() {
          return $this->length;
        }

      Pretty obvious right? In fact, a language that didn't let you do that would be extremely brittle. You could never refactor. You could never create more than one interface for a given piece of code. In fact your code would just "freeze" in place after a while, and change would be very difficult.

      Now think about SQL databases. It's rather difficult to take your existing database that has fields like (BookID, FirstName) and interface it with, e.g., a Rails app that wants to see (id, first_name). What do you do? Do you change all your tables (yeesh) .. do you rewrite the app (yeesh again, especially with rails).

      Or do you just do what Codd intended 30+ years ago and create a second view of the data?

      This is so blindingly simple and useful I'm always surprised that people call it an "enterprise" feature. It is a *fundamental* feature. Are methods and classes enterprise features? Sure, if you don't *have* them and you want to justify to yourself that you don't need them.

      I'm glad to see MySQL adding views and *updateable* ones at that. We're still stuck with crappy non-relational SQL, but at least it's a step in the right direction.

    6. Re:Enterprise features? by EvilTwinSkippy · · Score: 1
      Since when are those things enterprise? You are obviously not remembering the days of DBASE!

      (As I curl into a fetal position thinking about re-indexing files...)

      --
      "Learning is not compulsory... neither is survival."
      --Dr.W.Edwards Deming
    7. Re:Enterprise features? by EvilTwinSkippy · · Score: 1
      Amen. Peeps, there are control freaks out there (myself included) that really DON'T want my database engine massaging the data. I just want it to store what I give it, and recall what I ask of it quickly.

      Anything more sophisticated than that is handled by the program. Mostly because any of us who have been doing the for a while know that when you are tracing a problem, haveing Peter outguess Paul leads to disaster. Documenting my software is hard enough without explaining the "data gnomes" that live in the stored procedures.

      And don't bother arguing with me. I've been there. I've been working with this crud since the days of DBASE and do-it-yourself hash tables in C. If that makes me a fuddy duddy... well so be it. I get my paycheck at the end of the week whether you agree with me or you don't.

      --
      "Learning is not compulsory... neither is survival."
      --Dr.W.Edwards Deming
    8. Re:Enterprise features? by gfody · · Score: 1

      I just want it to store what I give it, and recall what I ask of it quickly. ..and using a relational database engine for this task is the right tool for the job?

      --

      bite my glorious golden ass.
    9. Re:Enterprise features? by gfody · · Score: 1

      most rdbms's align themselves with a relational normalization theory that deem auto-increment columns or sequences a hack anyways. I know exactly what your talking about though.. being able to have multi-dimensional autonumber columns would've saved me a lot of trouble.

      Supposedly anytime you find yourself using these autonumber columns there would be a "proper" solution w/o them if you step back and revise your schema.

      What confuses me is that in all the examples for showing off 3rd, 4th, 5th normal form they love using autonumber examples for splitting tables into relationships and showing how less redundant it is afterwards. I wish relationships that as simple as replacing redundant values with id's would just be handled transparently by the server.

      --

      bite my glorious golden ass.
    10. Re:Enterprise features? by bernjuer · · Score: 0

      You obviously don't work at the same place as I do. A large share of our customers still uses an application compiled with Clipper Summer 87 - and they get their quarterly updates.

    11. Re:Enterprise features? by Anonymous Coward · · Score: 0

      You seem to be assuming only a single app will ever access the database. In reality, other departments are going to build their own maintenance or synchronization or reporting apps, making no reuse whatsoever of your code, often in different languages, without even looping you in until something breaks. Consistency checks that aren't enforced by the database itself simply aren't going to happen, and the lifetime of a build that relies on the actual table schema (rather than updateable views) will be measured in months at best.

    12. Re:Enterprise features? by Anonymous Coward · · Score: 0

      Log shipping? You mean like, automatically synching a slave server from the transaction log of a master? We've been doing that with MySQL for bloody ages.
      Next silly question?

  9. Brushing the teeth of the lion? by Anonymous Coward · · Score: 2, Funny

    I think Mysql is cleaning up the donkey poop, myself.

  10. If mySQL is the IKEA of databases then... by eltoyoboyo · · Score: 1

    I would like to see a list of other database manufacturers listed with their retailer equivalents..... Seriously though, IKEA is a store full of very interesting, but not entirely useful gadgets. The Scandinavian connection seems to be about the only one I can make. mySQL has taken a less "gadgetey" approach to DB setup and maintenance. They have taken much criticism over the years for not including the Stored procedures, views, and triggers. These now all appear in version 5.0.

    --
    Have you Meta Moderated t
    1. Re:If mySQL is the IKEA of databases then... by Decaff · · Score: 1

      They have taken much criticism over the years for not including the Stored procedures, views, and triggers. These now all appear in version 5.0.

      Which isn't out yet.

      From the point of view of anyone who wants a stable database, having these features in a preview version that the company does not recommend for general use yet means that these features are effectively absent from the product.

      So, MySQL STILL does not have stored, procedures, views and triggers in a form that is usable.

    2. Re:If mySQL is the IKEA of databases then... by rimmon · · Score: 2, Funny

      "Seriously though, IKEA is a store full of very interesting, but not entirely useful gadgets."
      Interesting but not entirely useful gadgets like, hmmmmm, beds, tables, chairs, couches, wardrobes, cupboards, kitchens, plates, forks, pots and pans, curtains, mirrors, carpets...? :)

  11. Re:Can someone explain the license (GPL) to me? by DarkArctic · · Score: 1

    I don't think that lawyer fully understood the requirements of the GPL. (I'm no lawyer, so anyone correct me if I'm wrong).

    From what I understand if you distribute the product then the source code from any product that's a derivative work of a GPLed product has to be available. That doesn't mean that if you modify something for internal use you have to tell the whole world that you change it and hand out the code. As long as it's still just internal you can keep it "closed" from the outside world.

    As for anything compiled with GCC having to be licensed under the GPL, that's just a load of bull. Anything compiled with GCC is not considered a derviative work, it's a separate product. You can license it however you want.

  12. Ikea as a business model, not a customer model... by mykepredko · · Score: 1

    I've already seen a comment stating that if you follow the Ikea model, you get an allen key and crappy instructions and this is just part of an experience in which walking out costs more than you expect, the product is of questionable quality and often hard to find exactly what you are looking for.

    None of which are attributes you want in a database product.

    I think the comment is noting that Ikea is a profitable enterprise and one that is admired by the business community, but for the most part the customer experience is lacking and not one I would think that would attract most people to.

    Of course, YMMV, does replicating the Ikea experience make MySQL more attractive to anyone?

    myke

  13. Re:Can someone explain the license (GPL) to me? by Anonymous Coward · · Score: 0

    So you are selling a derivative?
    If you are only using it inhouse, you need not distribute the code you wrote.

  14. MySQL to change name... by Anonymous Coward · · Score: 0

    ... to skitig.

  15. I hope they do well by MagicMerlin · · Score: 3, Interesting

    I'm a PostgreSQL fanboy, but I hope these guys pull it off. A lot of poeple don't realize that what's good for one open source project is good for all of us (historical emotional baggage aside).

    The 5.0 release looks to be the biggest in the history of the database. I say good luck to them. Has anybody played around with their functions implmentations?

  16. MySQL's stance on competition is like Nintendo's. by Anonymous Coward · · Score: 4, Insightful

    Unlike Nintendo, I think the MySQL people have a point though. You wouldn't want a $100k Oracle DB for a website that can be handled by $5k of white boxes running MySQL, just like you probably wouldn't expect a stuck-up billion dollar business to use an open source DB.

  17. It has a lot of small pieces... by Masa · · Score: 1, Redundant

    ... and it will be pain in the ass to set up?

  18. Semi-disposable Swedish furniture? by Anonymous Coward · · Score: 0

    Semi-disposable DBMS? Sounds about right.

  19. Better the lion than the orang-utan by hotdiggitydawg · · Score: 1

    If you're working in a zoo you don't want to be the one who has to brush the teeth of the lion.

    True, but you don't want to be the one who has to wank off the orang-utan either.

    Come to think about it, in light of MySQL's recent partnership with SCO this may not be a bad analogy after all...

  20. Is that a good thing? by jurgenaut · · Score: 5, Funny

    I would search through benchmarks and wonder, "What kind of database defines me as a person?" We used to read pornography. Now it was debug prints. I had it all. Even the opteron optimized version that can take over 2Gb / process, but it still maxes at 4Gb due to 32bit pointers - proof it were crafted by the honest, simple, hard-working indigenous peoples of wherever. I am Jack's wasted memory.

    1. Re:Is that a good thing? by Anonymous Coward · · Score: 0

      The first rule of MySQL club is to not talk about MySQL club.

    2. Re:Is that a good thing? by spongman · · Score: 1

      The second rule of MySQL club is a foreign key constraint with cascading deletes. oops.

  21. Foot in mouth by PhotoGuy · · Score: 2, Interesting

    Wow, what a dumb, dumb statement.

    With all the ground work that MySQL has made, it is starting to be seriously considered an enterprise grade system. I can just see managers using some of these quotes to show that it's really just a toy, not a real DB like "Oracle." Would have been better just to say nothing.

    --
    Love many, trust a few, do harm to none.
    1. Re:Foot in mouth by Anonymous Coward · · Score: 0

      But it IS a toy. "Enterprise grade", hahaha.

    2. Re:Foot in mouth by pubjames · · Score: 1

      Wow, what a dumb, dumb statement.

      It's not a dumb statement if the enterprise space is genuinely one they don't want to be in. I imagine it could open up all kinds of potential legal issues that they may not want to have to deal with.

    3. Re:Foot in mouth by Doctor+Memory · · Score: 1

      No kidding, what a bunch of mixed metaphors. Competition is like brushing teeth? WTF?

      --
      Just junk food for thought...
  22. My experience with Ikea... by Anonymous Coward · · Score: 0

    has been stuff that was cheap and easily broken. I wonder if MySQL will be the same way.

  23. Pictogram Read Me Files by digitaldc · · Score: 1

    "It's realizing that simplicity does not mean a lack of sophistication," he added, noting that while some competitors might like to boast about 3,500 settable database parameters, MySQL would rather offer 35 settable parameters and hide the complexity from the end user.

    If MySQL is the Ikea of DB market, does this mean they will start using Pictograms in their read me files?

    --
    He who knows best knows how little he knows. - Thomas Jefferson
    1. Re:Pictogram Read Me Files by jedidiah · · Score: 1

      The problem with this mentality of course is the fact that an RDBMS server is not a word processor. IT'S A DEVELOPMENT ENVIRONMENT. Generally, you're not going to be satisfied with only 35 knobs because you are probably doing something different enough from the next guy that you'll care about the extra knobs.

      --
      A Pirate and a Puritan look the same on a balance sheet.
  24. Futurama vs Pi-Kea by djdavetrouble · · Score: 1

    "Enjoy your affordable Swedish crap." - Robot from Pi-kea (4ACV04 - Less Than Hero)
    (robot limps off with one wheel missing and cabinet door hanging open)

    --
    music lover since 1969
    1. Re:Futurama vs Pi-Kea by Dachannien · · Score: 1

      Those Swedes know how to put in almost everything you need.

  25. "Ikea Of The Database Market" by MouseR · · Score: 2, Funny

    Expensive, hard to setup, crumbles after a couple of years?

    1. Re:"Ikea Of The Database Market" by Anonymous Coward · · Score: 0

      Documentation all pictures and no text.
      Doesn't help anyways, because library "screw b" is missing.

  26. Re:The database for homosexuals? by Afecks · · Score: 1

    Nice troll, but I think you meant 'everywhere' not 'everyone'. But I really don't get what they mean by the 'Ikea of databases'. Does that mean it is over priced, stupid looking and meant for people with more dollars than cents?

  27. haven't really seen many of those posts... by SuperBanana · · Score: 2, Interesting
    That should nip the "MySQL is a replacement for Oracle under all circumstances" posts that always appear whenever MySQL is discussed on slashdot

    That's something of a straw man argument; I don't see sort of comments modded very high, probably because plenty of mods have had to deal with mysql in the business world, and the rest have seen enough critical commentary over the last few years to know not to drink the kool-aid.

    I saw lots of posts modded high mentioning all of MySQL's various critical flaws, as well as a number of posts mentioning PostgreSQL is better (a number explaining for non-DBAs why, say, things like transactions are important), maybe how the author moved to PostgreSQL and likes it better...but I can't ever remember having seen a single post saying "I used PostgreSQL and went to MySQL", except by people with the vocabulary and English skills of a 16 year old, think transactions are for wussies, are impressed at how fast MySQL handles simple queries on small datasets, and like that they don't have to worry about case sensitivity in their queries.

    The most poignant comment I saw said that while everyone else had forged ahead, MySQL was just catching up to "state of the art" half a decade ago or more. We're not really talking luxury features- more "features a proper database should have".

    I don't have the link to the story handy, but it was just yesterday, I believe. I strongly encourage anyone who hasn't read that thread to do so now.

    1. Re:haven't really seen many of those posts... by Overly+Critical+Guy · · Score: 1

      That's something of a straw man argument; I don't see sort of comments modded very high, probably because plenty of mods have had to deal with mysql in the business world, and the rest have seen enough critical commentary over the last few years to know not to drink the kool-aid.

      It doesn't matter if they're not modded up (sometimes they are); they're still posted. That's not a straw man argument.

      --
      "Sufferin' succotash."
  28. What's going on with MySQL? by Nicopa · · Score: 4, Interesting

    Why all these crappy slashdot posts about MySQL we have been seen lately? They speak as if MySQL where an uncontested champion in the free-software database arena. This is far from true. Many articles doesn't even mention PostreSQL. Many of them says "Now MySQL is a big player because it's got... transactions" (!).

    I think there's interest here in building up the idea that MySQL is important. There's currently no reason to use MySQL, because other products already do what it does and better.

    1. Re:What's going on with MySQL? by Anonymous Coward · · Score: 0

      There's currently no reason to use MySQL, because other products already do what it does and better.

      Well if you're writing webapps in PHP/Perl and want them hosted on any hosting company you have a reason to use it. Sure some support Postgre but not all and not as many as support MySQL.

      Same goes for a certain mainstream OS we all love. If you want to interact with the masses don't expect to use the best.

      Infact it's betamax all over again :)

    2. Re:What's going on with MySQL? by archen · · Score: 1

      Well there are some darlings of the open source world that everyone loves to tout even if they aren't the best for every situation. MySQL is of course the best example in the database arena (vs Postgresql). Apache is another good example. You hear lots of people all worshiping Apache, and many bitching about its resource usage and the brain dead configuration file, but no one EVER suggests you give lighttpd a try (seriously, it's a great web server if you don't need the kitchen sink).

      I think it's just a side effect of OS envangelism where everyone cites the same example, and the competing OS projects are sort of washed out in the buzz.

    3. Re:What's going on with MySQL? by photon317 · · Score: 2, Insightful


      Agreed. I used MySQL a few times back in the day, just because it was extremely easy to set up for extremely trivial tasks. But, IMNSHO, PostgreSQL is *the* ultimate opensource general purpose RDBMS (or O-RDBMS really). If you compare them by real-world attributes (supported features, robustness, performance, etc), PostgreSQL owns the competition, and even gives Oracle's RDBMS a good run for its money. For my purposes, this is how Oracle vs PostgreSQL stacks up right now:

      Oracle: expensive, difficult and convoluted to install and maintain, lots of add-ons that PostgreSQL has no desire to match (application servers, Forms, etc), probably better performance on very large databases on very large hardware (but not by much anymore), integrated storage management (as of 10g), and built-in masterless clustering for scalability and availability.

      PostgreSQL: free, easy to install (in the case of a modern linux distro, just use the OS package management), very good performance even on complicated things that only Oracle used to be good at, may not scale well beyond 4-8-ish way machines. No built-in clustering, but something may eventually come of the handful of add-on projects that currently do limited forms of clustering.

      I don't even see the point of MySQL for anything anymore, unless you're using it for reasons of popularity and/or habit (It's what we already use for 10 other projects, it's what I learned first, it's what I'm comfortable with, it's what most of our new hires will know better, etc). The bookstore shelves reflect MySQL's historical popularity too. Even at stores around here with good technical book selection, the ratio of MySQL books to PostgreSQL books on the shelves is ~ 10:1, and you can rarely find a specific PostgreSQL book you're looking for in stock.

      --
      11*43+456^2
    4. Re:What's going on with MySQL? by Anonymous Coward · · Score: 0

      You're obviously a PostgreSQL fanboy. Do you have any real Oracle experience? How about DB2? Thought not. You used an old version of MySQL. Well done, good job. Now, I don't want to upset you blinkered world view, but each DB has its merits and lends itself to certain applications better than others.

      I have an application that runs on all of the above, bar DB2. It's primiary function is rapid dataprocessing with limited transactions. Something like Yahoo Finance is a close example. MySQL is significantly faster than the other two. A performance tweaked PostgreSQL is very slow at handling 1000s of data aggregations, it's not even viable when we get into 10s of thousands. Try using count(*) and GROUP BY over a big dataset. PostgreSQL ends up on its knees, looking like something written in VB.

      So according to you, we should not be using the DB that's 3-20x faster than your one-size-fits-all approach.

      Fanboy's like you are a hindrance to open source. Grow up! Use the right tool for the job in hand, and leave your playground politics for your personal projects.

    5. Re:What's going on with MySQL? by Anonymous Coward · · Score: 0

      Oh yes, and you're so much better than parent, you MySQL fanboy... Whatta moronic conclusion on your part. You obviously never bothered setting up PostgreSQL in openmosix environment. Or maybe it's too hard for you? The thruth is, that for any type of large enterprise no matter how fast dbms is out of the box, sooner or later you need to scale it beyond its core performance abilities. Properly clustering Postgres (or MySQL, or ) in the end will give you performance you're looking for, so it does indeed come down to the features. And even comparing to MySQL 5.0, PostgreSQL beats it hands down.

    6. Re:What's going on with MySQL? by Anonymous Coward · · Score: 0

      Do you find complex queries from mysql fast? I've never been able to get any decent performance from mysql while using multiple subselects, a half-dozen joins, or large table scans & temp space...

    7. Re:What's going on with MySQL? by Vellmont · · Score: 1

      I still haven't been able to figure out why MySQL is more popular than Postgres. I suppose if you don't use the features that postgres provides you don't care much, but why invest yourself in a technology that's more limiting? At this point I'm curious if MySQL popularity is fading, and Postgres is gaining all the converts.

      --
      AccountKiller
  29. Finally a group that "gets it" by shrapnull · · Score: 2, Insightful

    That just proves to me that he completely understands the user space of MySQL.

    Thousands of webmasters and home-based coders don't want a competitor to Oracle, we want something that gets he job done quickly, efficiently and affordably.

    This idea that every product has to become a behemoth and compete for world domination is the stake through the heart of many a project. Being content with distributing in bulk to an extremely thankful user-base is what it's all about as far as I'm concerned with MySQL. This ensures that most open-source projects will continue to be MySQL oriented, LAMP will continue to dominate the OSS Content Management Services market, and for those that determine it's just not "good enough" for what they want to do there are plenty of alernatives to expand your feature set.

    K.I.S.S. is what MySQL has always been about, and I give the guy props for admitting they'll never have the desire nor ability to compete with Oracle.

    --
    If you're half as beautiful naked, you'd be 4 times as beautiful with twice as many clothes on.
    1. Re:Finally a group that "gets it" by TCM · · Score: 1

      K.I.S.S. is what MySQL has always been about

      K.I.S.S. implies - at least in my book - correctness, something MySQL has never been about until maybe recently.

      --
      Of course it runs NetBSD. BTC: 1NT7QvbetmANwaMzhpVL6
    2. Re:Finally a group that "gets it" by spezz · · Score: 2, Funny
      K.I.S.S, in my book implies that you want to rock and roll all night.

    3. Re:Finally a group that "gets it" by jocknerd · · Score: 1
      Thousands of webmasters and home-based coders don't want a competitor to Oracle, we want something that gets he job done quickly, efficiently and affordably.


      http://www.sqlite.org/ would be a better choice for these users.
    4. Re:Finally a group that "gets it" by Christopher_G_Lewis · · Score: 1

      Crap. I always thought A.C.I.D. was what you wanted your database to be about :-)

    5. Re:Finally a group that "gets it" by russellh · · Score: 1

      I think they do want that. At least for their servers.

      --
      must... stay... awake...
    6. Re:Finally a group that "gets it" by EvilTwinSkippy · · Score: 1

      Database (n): A non-volitile cache between your application and your backup medium.

      --
      "Learning is not compulsory... neither is survival."
      --Dr.W.Edwards Deming
    7. Re:Finally a group that "gets it" by Christopher+B.+Brown · · Score: 1
      More precisely, thousands of webmasters want something that appears simple.

      Something that will stuff in data, whether it's valid or not, because writing code that responds to errors reported back by the database is far too complex for their "simple" needs.

      "The whole world's a BLOG" is the typical sort of user space for MySQL(tm), and if that is what the product's owners perceive, I think that means they are plenty perceptive about its limitations.

      --
      If you're not part of the solution, you're part of the precipitate.
    8. Re:Finally a group that "gets it" by Anonymous Coward · · Score: 0

      > Database (n): A non-volitile cache between your application and your backup medium.

      Not a bad definition, but just a partial one.

      It's also a place to consolidate data - sometimes to integrate multiple systems. In this case it isn't merely a cache, it's like the hub that the applications hang off.

      At other times it's a restatement of process or resource status, reorganized to enable analysis. In this case, it isn't a cache - the dbms is the engine, the data the fuel that enables insights. The application? that would be the dashboards, reports, scoring tools, etc. But in this kind of an application the data is usually consider primary and the applicatin secondary.

    9. Re:Finally a group that "gets it" by Anonymous Coward · · Score: 0

      That just proves to me that he completely understands the user space of MySQL.

      Yes, the uniformed and the terminally ignorant.

      Thousands of webmasters and home-based coders don't want a competitor to Oracle, we want something that gets he job done quickly, efficiently and affordably.

      Then you'd be far better off with PostgreSQL. If you weren't an idiot, then you'd already know that.

    10. Re:Finally a group that "gets it" by Anonymous Coward · · Score: 0

      You omitted "correctly" from your list. That's the attitude that keeps leading us to complain about MySQL in the first place. If I wanted quick garbage I'd use a random number generator.

  30. Re:Ikea as a business model, not a customer model. by arkanes · · Score: 1
    You know, thats kinda funny, cause none of that matches my experience with Ikea at all. The Ikea store near my home (in Houston) is very nice, well laid out, chock full of helpfull people, and tremendously family friendly - how many other furnitore stores have complete childrens play centers to drop your kids off at while you shop?

    We have some Ikea bookshelves, and the design is a little questionable, but my desk is fantastic. I had a great experience at the store itself.

    On a final, slightly flamebait note, my MySQL experience has none of those characteristics :P

  31. argh! by Anonymous Coward · · Score: 0

    it's not even a *real* database, people! wait, you don't have VIEWS? in the next major release? wtf!!!

  32. Re:Does that mean... (Yes, it does!) by Anonymous Coward · · Score: 0

    The Ikea of the database market: Cheap, more than a little flimsy, and nothing you should brag about in company that has a clue, but impressive to teenagers and a lot of college students.

  33. MySQL is by MemoryDragon · · Score: 1

    The IKEA of the database market, way to overpriced and the stability is pretty much the same (aka falls apart under heavy load) The only thing missing is polish programmers and that the customer has to plug the db together them/theirselfs...

    1. Re:MySQL is by Anonymous Coward · · Score: 0

      Ikea is Swedish, not Polish. Their products tend to be of a higher quality than other similar shops. I think they are also a lot more innovative than their competitors. Take a look at their light fittings for example - they seem to have spent a lot of time not just making them look nice - but also easy to install. Anyone who has tried to install an ikea ceiling rose will tell you that!. While some of their products may be more expenive than others they also have a good range of products which are much cheaper than you will find elsewhere.

    2. Re:MySQL is by MemoryDragon · · Score: 1

      Actually Ikea is swedish but their main manufactories are in poland due to cost reasons, and the quality varies, lots of their stuff is due to the wood used not very stable and basically breaks down under heavy load, some of their stuff is good though. General rule though is, you get what you pay for, in case of Ikea often crap, and it is generally cheap but also very often way too expensive for the quality you get. The comparison to MySQL is valid in this regard, evn in hype dimensions, you can get better solutions than MySQL (Firebird and Postgresql) really for free, the problem is that MySQL constantly hypes their semi crappy stuff while Postgres and Firebird do not have the hype but the quality on their side.

  34. Re:Ikea as a business model, not a customer model. by duffbeer703 · · Score: 1

    People dig Scandinavian stuff. Everyone overpays for Haagen-Daas because it sounds like its a Viking snowcone or something.

    MySQL should rename itself to some trendy nordic name. Some schmuck would probably pay more for it than Oracle or DB2

    --
    Conformity is the jailer of freedom and enemy of growth. -JFK
  35. Re:MySQL's stance on competition is like Nintendo' by Anonymous Coward · · Score: 0

    I work for a Fortune 500 that had revenues of over $5 billion last year. We keep some pretty important data in a MySql database with an Access front end.

  36. Meatballs! by Anonymous Coward · · Score: 0

    Awesome!!! I hope this means I can use my database to order Swedish meatballs! I love the Ikea Cafeteria!!!

  37. Ikea always makes me think of Fight Club now. by ChaseTec · · Score: 3, Funny

    You are not your relational database!

    --
    My Hello World is 512 bytes. But it's also a valid Fat12 boot sector, Fat12 file reader, and Pmode routine.
  38. Good attitude by Anonymous Coward · · Score: 1, Insightful

    This is an attitude that Linux enthusiasts could learn from. Stop worrying about taking on Microsoft and building a system that can convert everyone, and focus on building something that just works really well for the people that actually use it.

    1. Re:Good attitude by jedidiah · · Score: 1

      Actually, a mentality of "taking on Microsoft" would be of considerable use here since MySQL is much more like Access or MSsql than Oracle. It's the puny database for people that don't have the interest or resources to do proper database programming or management. It's basically a glorified embedded database. Treating it as such would be more useful.

      --
      A Pirate and a Puritan look the same on a balance sheet.
  39. MySQL - built by prisoners by DrSkwid · · Score: 1

    No surprise you end up wondering where your data went !

    --
    There are places where the networks are not touching,and there are places where they are-Boeing's Lori Gunter
  40. PostgreSQL and 200K hits per day by tcopeland · · Score: 0, Offtopic

    I've been using PostgreSQL on a low-end site - RubyForge, 3.3M records - and it's comfortably handling 200K hits per day.

    Maybe I can turn on logging for a day to count the queries; that would provide another data point.

  41. Re:Does that mean... (Yes, it does!) by Black-Man · · Score: 2, Interesting

    Ahh... c'mon. Some of their stuff is expensive - check out the kitchens next time your in the store. I can't see a college student spending that kind of money.

  42. Sounds Right by Anonymous Coward · · Score: 0

    Cheap crap, takes a long time to get put together, isn't what you thought it would be, breaks early, replaced with something of higher quality.

  43. Query Types by PhYrE2k2 · · Score: 4, Informative
    Have you actually performed side-by-side comparisons using your own data?


    Bingo. I couldn't agree with you more. MySQL is fairly lightweight, easy to use for many newbies, and provides some pretty advanced features for most tasks. It has its quirks to be careful of, but ultimately does its job as a DBMS. MySQL is extremely quick on the read, but suffers from locking issues and concurrency issues on the write. So it's fantastic for the Web- which is why you see it so often on hosting providers and other similar providers- it's quick to put Web content into. It's quick to hold userIDs/passwords that aren't updated frequently. It's quick in anything where reads are heavy and writes are sparse. Service providers like it because it's not too resource intensive for read-heavy uses (web sites) and it has a great user model (store users in a database, provide per-database permissions and hide all other customers from seeing other people's databases) for many-user systems.

    PostgreSQL does a fantastic job with sites needing more complexity. If you need to start with transactions, need good read/write performance, and feel that data integrity is key (generally things dealing with dollars, accounting systems, online applications, booking systems, etc) then of course the way to go really is PostgreSQL if supported. If it's not (as it is with many hosts), there's always some MySQL transactional support with row-level locking, but it almost seems like a hack. (as a note, PGSQL8.1Beta2 provides support for 'roles', but to my knowledge still doesn't hide other people's databases).

    Anyway- Each has it's ups and downs. Service providers love MySQL because it's fast, cheap, easy, and keeps users seperate. PostgreSQL I've seen abused a bit too much for things it's not to be used for, and that has a huge performance hit. Why the bickering? Everyone thinks their tool is bigger :)

    -M
    --

    when you see the word 'Linux', drink!
    1. Re:Query Types by Tolkien · · Score: 1

      *copies and pastes for future decision-making purposes*

      That -- I did not know, thanks. :)

  44. So by Anonymous Coward · · Score: 0

    After you've assembled everything yourself you have some configuration files left unused.
    And next time you move it all falls apart.

  45. And of course... by superdan2k · · Score: 4, Funny
    ...there's going to be the renaming of the product with Swedish words that sound vaguely sexual in English:
    • Schloönge
    • Loob
    • Vügeena
    Ad nauseum...
    --
    blog |
    1. Re:And of course... by aclarke · · Score: 1

      No kidding. For instance, here's an ideal one for the /. crowd...

    2. Re:And of course... by Anonymous Coward · · Score: 0

      Not to ruin your joke, but those fake swedish words are more like german. Are you sure you're not making the typical Switzerland/Sweden mismatch?

  46. Wal-Mart of DBs? by doublem · · Score: 3, Funny

    So I guess this would make Microsoft SQL Server the Wal-Mart of Databases.

    It's the one a lot of people go to because they can't be bothered to shop around.

    (Please note, the above is intended as humor. I earn my living working with SQL Server, and happen to think it's a fine product, but there are a lot of products that use it because it's Microsoft and for no other reason.)

    Of course, all this begs the question, is Oracle the Target or the Sears of Databases?

    The Sears hardware and appliance lines make me suspect Oracle is the Sears, but Target is bigger than Sears, which would reflect Oracle's install base better.

    --
    "Live Free or Die." Don't like it? Then keep out of the USA
    1. Re:Wal-Mart of DBs? by dmaxwell · · Score: 1

      Of course, all this begs the question, is Oracle the Target or the Sears of Databases?

      Nope. I'd say Oracle is the Bloomingtons of Databases.

    2. Re:Wal-Mart of DBs? by j-cloth · · Score: 1

      Nope. I'd say Oracle is the Bloomingtons of Databases.
      Agreed. If you have to ask the price, you can't afford it.
      No such items exist in Sears or Target.

    3. Re:Wal-Mart of DBs? by stuntpope · · Score: 1

      Rather, the Needless-Markup (Niemann-Marcus) of databases.

    4. Re:Wal-Mart of DBs? by Anonymous Coward · · Score: 0

      Yeah MS SQL is definitely cheap, but Wal-Mart is also inexpensive...
      Don't think MS SQL is the place you want to go for an inexpensive database.
      LOL

    5. Re:Wal-Mart of DBs? by MemoryAid · · Score: 1
      I've used Microsoft Access a fair amount, although not for anything demanding. I can say the same for Slashdot, as well. With my background, Microsoft has always seemed less like a Wal-Mart and more like a Target, especially around here.

      I guess that leaves Sears for Oracle.

      --
      Language students: Don't try to learn English here. This ain't it.
    6. Re:Wal-Mart of DBs? by doublem · · Score: 1

      Damn, and me wihtout mod points.

      You need some "+x Funny" for that one. :)

      --
      "Live Free or Die." Don't like it? Then keep out of the USA
  47. The IKEA of database? by burtdub · · Score: 2, Funny

    UPDETE TEBLE SET Cuoontry = 'Sveden' VHERE Neme-a = 'Svedeesh Cheff';

    1. Re:The IKEA of database? by Joe+the+Lesser · · Score: 2

      INSERT 'chicky' INTO 'baskey' WHERE 'value' == '2'
      ***
      mysql error-- "BJORK BJORK BJORK"

      --
      "I only speak the truth"
      Karma: null(Mostly affected by an unassigned variable)
  48. 'the Ikea of databases' by god64 · · Score: 1, Funny

    does he mean because of important features and tools missing or what?

  49. Name of the Zookeeper by Anonymous Coward · · Score: 0

    What's the name of the Zookeeper who brushes the teeth of the Lion?

    (drum roll please)

    Stumpy!

  50. Re:Ikea as a business model, not a customer model. by Anonymous Coward · · Score: 0

    Curiously enough, Haagen-Dazs isn't even Scandinavian, but was rather created by an American who wanted the product to have a European-like name (with umlauts and crazy dipthongs)- which of course supports the parent poster's thesis. So when you nosh on a pint, give thanks to The Bronx, birthplace of Haagen-Dazs ice cream. It should also be noted that the Wikipedia article for Haagen-Dazs contains a referential link to here, which is awesome.

  51. Top quality fiberboard! by HitScan · · Score: 1

    So, if you INSERT INTO "table" ('object') VALUES ('water'); in a MySQL table, the database completely disintegrates?

    --
    HitScan
  52. Lions vs elephants by magarity · · Score: 1

    If you're working in a zoo you don't want to be the one who has to brush the teeth of the lion.
     
    You also don't want to be the one who has to clean up after the elephants, if you know what I mean.

    1. Re:Lions vs elephants by fishbowl · · Score: 1


      "If you're working in a zoo you don't want to be the one who has to brush the teeth of the lion."

      Why not? Sounds like one of the more exciting jobs -- and you'd have the respect of a [i]lion[/i].

      --
      -fb Everything not expressly forbidden is now mandatory.
  53. from a business perspective... by Anonymous Coward · · Score: 1, Insightful

    it makes little sense for MySQL to be going after Oracle directly. They have little or no street cred in oracle's markets and they can't compete on features or quality.

    Instead, it makes sense for them to continue to gobble up the low end marketshare while improving their product. Over the years, mysql meets more and more of the needs of Oracle users. Companies like oracle need to constantly climb the feature ladder to distinguish their high end product from MySQL's low end offerings. Without a substantial innovation from Oracle, MySQL eventually matches them on features and quality, gains the requisite street cred, and it's bye bye oracle as we know it today.

    Maybe this is what Open Office and other groups should be doing. Don't target the central corporate workspace. Go after the adhoc environments: home users, small businesses, cash strapped schools. Improve the product until it is feature competitive with Office, get the requisite street cred, and then take the traditional MS Office marketshare.

    1. Re:from a business perspective... by Forbman · · Score: 1

      replace "Postgres" in the parent post, and you make more sense.

      It is FAR easier to migrate an Oracle DB to Postgres than to MySQL. You don't have to redo stored procs in an application layer, etc. is a big one.

  54. Sour Grapes by Anonymous Coward · · Score: 0
    That makes it official: MySQL will never be what PostGreSQL and Oracle are.

    Glad that's over; back to work.

  55. In related news... by kongjie · · Score: 1

    CEO Marten Mickos was diagnosed with an advanced case of metaphoritis.

  56. Does this mean by the_thunderbird · · Score: 0

    That MySQL will sell software with things missing, like ikea sells its funiture with screws missing?

  57. Re:funny by Hiro+Antagonist · · Score: 1

    Well, it *does* eat every resource in sight...

    --

    --
    I Hit the Karma Cap, and All I Got Was This Lousy .sig.
  58. Tools for the job by ajs318 · · Score: 1

    MySQL does what it does well, and doesn't pretend to do what it doesn't do.

    As a flexible but quirky set of persistent array extensions for most known programming languages, including the Three P's, it works really well. Unfortunately, the fact that it uses a bastardised dialect of SQL has led people to mistake it for a relational database management system.

    MySQL makes it easy to write web pages with changeable content {such as message boards, diaries, online auctions and personal rant sites}; and with the addition of phpmyadmin, it even becomes a kind of MS-access replacement. You will have to do a lot more work in the application layer if you want to emulate stored procedures and triggers, or if you don't want to run afoul of graceful degradation. But in the 90% of cases where you don't need SPs and triggers, and where you'd rather let a few characters go missing than seize up with a fatal error, it performs just fine. And because it uses SQL {albeit with a broad regional accent}, it can provide a n00b with a sort of gentle introduction to real databases.

    The bottom line is, you can't expect to tow a four-berth trailer round the twisty mountain roads with a one-litre Ford Fiesta. But for someone who just wants to drop the kids off at school and then nip into town to buy another pair of shoes, a 4x4 with a three litre engine and six gears is overkill. And you don't see many high performance sports cars with L-plates either.

    --
    Je fume. Tu fumes. Nous fûmes!
    1. Re:Tools for the job by Anonymous Coward · · Score: 0

      There's no such thing as a "90%" case of not needing stored procedures. If your application accesses a database, you should ALWAYS use stored procedures.

    2. Re:Tools for the job by Anonymous Coward · · Score: 0

      > MySQL does what it does well
            - except for the silent errors
            - and data truncations
            - and locking of tables when you make a simple alteration
            - etc, etc

      > , and doesn't pretend to do what it doesn't do.
            - except when they tell developers that you really don't need transactions anyway
            - or views or subselects or triggers or ...
            - and except for when they were telling everyone last year that they were ready to take on
                oracle and run enterprise databases

      > Unfortunately, the fact that it uses a bastardised dialect of SQL has led people to mistake it
      > for a relational database management system.

      agreed - though I do believe that they can become a serious contender in the RDBMS marketplace - and one with credibility - they need to shed the habit of deceiving people with inferior and non-standard features.

      > and where you'd rather let a few characters go missing than seize up with a fatal error, it performs
      > just fine

      I really can't think of a place where i'd want my disk drives, os, or database to make that decision for me. I make those decisions in the application layer: I seriously expect services to just work.

      > The bottom line is, you can't expect to tow a four-berth trailer round the twisty mountain roads
      > with a one-litre Ford Fiesta. But for someone who just wants to drop the kids off at school and
      > then nip into town to buy another pair of shoes, a 4x4 with a three litre engine and six gears
      > is overkill. And you don't see many high performance sports cars with L-plates either.

      Agreed. But, sooner or later most shops end up with another database for those serious challenges. And when that happens it won't be mysql. So, why not use the serious database in both places? You don't save any money with mysql (postgresql is freer, and oracle/db2 are cheaper if you have to pay mysql's confusing licensing). Mysql is simpler than oracle/db2/sybase/sql server - but once you've got to support backups, failovers, recoveries, replication, etc - you'll usually find it easier to just become an expert on a single product than two anyway.

  59. Re:Can someone explain the license (GPL) to me? by Anonymous Coward · · Score: 0

    Dude, don't feed the troll.

  60. That's odd by kindbud · · Score: 1

    I thought IKEA was the Oracle of furniture stores.

    --
    Edith Keeler Must Die
    1. Re:That's odd by EvilTwinSkippy · · Score: 2
      I'm having a funny scene involving Neo and the kitchen staff at Ikea playing through my mind.

      Neo: It's not the one?
      Oracle: Sorry kid. You've got the right product, but you are waiting for something.
      Neo: Like what?
      Oracle: Like for this coupon to be valid. It's not good for another week.

      --
      "Learning is not compulsory... neither is survival."
      --Dr.W.Edwards Deming
  61. Re:Can someone explain the license (GPL) to me? by Anonymous Coward · · Score: 0

    i think it would be very very very interesting to track down the poster of this. i'm starting to see this chunk o crap text appear more and more often... seems that viral marketing can be applied in more than one way.

  62. Ikea's self-described business model by alibee · · Score: 1

    So, here's the good thing about having parents in the furniture business -- I've heard all about Ikea's business model, in which they actually sell crap furiture for cheap with the hope/understanding that people will redecorate their houses *every year*.

    So what MySQL is saying is that we'll want to do the same thing? Rebuild our dbs completely every year, with new tables, blah blah?

    1. Re:Ikea's self-described business model by mattis_f · · Score: 1

      Of course. And that's also why I like Ikea - it allows me to redecorate my home every year, for the kind of money that would only allow me to get new furniture every five or so years at other stores...

      It's a feature, not a bug. :-)

      But I agree that the analogy with MySQL is somewhat ... lacking. I'm not enough of a technophile to change my DB because it's gone out of fashion. :-)

  63. Oh for the love of crap... by Ron+Harwood · · Score: 2, Insightful

    I don't care if MySQL is VHS compared to the postgres beta max... I'm sick and tired of people coming along and and trying to convert people to whatever their favourite technology is like it's the one true religion.

    Give it up... I don't care if you like PG, Ruby on Rails or stink on shit for that matter. I'll use what I feel is right for my projects. The only thing this kind of "evangelism" generates is animosity towards whatever product/technology/turd you're pushing on others.

    1. Re:Oh for the love of crap... by Angostura · · Score: 1

      I don't quite understand why you feel animosity towards a post which is simply telling you that PostgreSQL has native Window builds.

      you come across as the one who has the religion, not him.

    2. Re:Oh for the love of crap... by D'Sphitz · · Score: 1

      Yup, all the preaching around here is retarded, especially when it comes to MySQL or and *gasp* PHP (OMG BUT IT HAS VARIABLE VARIABLES!!!!). If you really like Lisp or Ruby then you use it, what's to gain by trying to convert me? Do you get referral bonuses or something?

  64. MySQL should never say never by jitterysquid · · Score: 0, Troll

    Didn't MySQL say things like "we'll never try to be ACID compliant" and "stored procedures and triggers are for people who don't know what their doing"? Do they enjoy the flavor when they eat their own words?

    1. Re:MySQL should never say never by Anonymous Coward · · Score: 0

      And remember: FOREIGN KEYS are not needed! :)

  65. I am Jack's snarky remark by Infonaut · · Score: 1
    How can you talk about being like Ikea and not expect to get a boatload of horrifically derivative remarks? ;-)

    --
    Read the EFF's Fair Use FAQ
  66. Re:MySQL's stance on competition is like Nintendo' by Anonymous Coward · · Score: 0

    Let us know how the job search goes when somebody finds out. Idiot.

  67. Ikea = Garbage by Anonymous Coward · · Score: 0

    My family has been selling juvenile furniture for over 53 years and I can tell you that Ikea = utter garbage. If you like low quality cardboard, Ikea is the thing for you or if you can't afford anything decent. If you like real wood that will actually last and hold up, go to a real furniture store.

    1. Re:Ikea = Garbage by vague · · Score: 1

      I believe they think more in terms of what kind of money it has made it's creator. Ingvar Kamprad is now one of the riches men alive.

      (And there are many reasons, one of them is that we live in a consumerist society where most young people don't actually want to inherit their parents furniture (which their parents, having a home of their own and a great many years of expected lifespan ahead of them, need for themselves anyway), or even use the furniture they bought themselves 10+ years ago. Furniture are now disposable fashion/lifestyle items.)

      I shop at IKEA because there I pay about one fourth of what I would do in a proper furniture store, I presently have limited funds, and I don't necessarily see myself using the same furniture in 15 years. That said, their sofas just look too cheap to bear.

      --

      -
      Listen. Strange women lying in ponds distributing swords is no basis for a system of government.

  68. Re:MySQL's stance on competition is like Nintendo' by big_ugly_face · · Score: 0

    you probably wouldn't expect a stuck-up billion dollar business to use an open source DB

    you mean, billion $ business like ... *cough* Google ? ;-)

  69. InnoDB by consumer · · Score: 1

    If you use InnoDB tables with MySQL, it doesn't have the locking issues you refer to. It uses the same MVCC locking approach that PostgreSQL and Oracle use.

  70. Re:MySQL's stance on competition is like Nintendo' by Anonymous Coward · · Score: 0

    It's not my problem, and not my head on the chopping block if something goes wrong. We currently have a task force analyzing the migration to SQL Server. However, 50% of the task force are financial analysts, which is partially why we are in this situation in the first place.

  71. Re:Ikea as a business model, not a customer model. by Anonymous Coward · · Score: 0

    Also, neither double vowels ('aa') nor the letter 'z' (not to mention the 'zs' mess) are common in scandinavian languages. It sounds more like dutch or german to me.

  72. Real-world tests by jgardn · · Score: 1

    Did you do real-world tests or did you just run a few queries and pull out a stopwatch?

    Did you test when data was in the buffer or when the data was clean? Do you even know how to flush the buffer on both databases?

    One thing I've noticed consistently is that MySQL begins to slow down as there are more processes running. That's why I never use it for the backend of a website.

    Compared to PostgreSQL, which, with only 1 or 2 processes is slower than MySQL, but it begins to shine as your load approaches reality. It also does tremendously well if it is overburdened. I haven't seen a system running PostgreSQL brown out due to overload. I think it's sweet spot is consuming about 75% of your box's resources.

    I can't think of a role where I would use MySQL at all.

    --
    The radical sect of Islam would either see you dead or "reverted" to Islam.
  73. Re:Ikea as a business model, not a customer model. by Anonymous Coward · · Score: 0

    double vowels are not that uncommon in finnish.

    ok, so it doesnt count as its not scandiavia proper, but norway does have their share of them too.

  74. Re:The database for homosexuals? by Afecks · · Score: 0, Flamebait

    I'd like to know where you get your statistics from. Unless you are gay and also speaking for your gay friends.

    Ignoring your obvious lack of facts, just because a certain group majority tends to like something doesn't mean it's "for" that group. Ikea put out a commercial showing two gay men shopping for furniture. That's not trying to promote their furniture for gays. That's showing that they have a progressive view of things and that their furniture is for everyone. Of course gay people took kindly to that show of acceptance and in turn it strengthened their opinion of Ikea positively.

    For your sake I hope it was a troll. If you didn't intend your remarks to be inflammatory then you are just plain ignorant. So if I were you, I would stick with it being a troll. No wait, if I were you I'd kill myself (outside) and stop stinking up my mommy's basement.

  75. He's (CEO MySQL) lying... by TarrySingh · · Score: 1

    coz he's seen Larry go crazy buying companies liek mad. He's the one who wait till the Lion dies of hunger. But I'm sure Larry ain't no fool. MySQL wil be the Oracle Lite version very soon!

    --
    Scott McNealy to Michael: "Suck my Sun!" Michael Dell to Scott : "Lick my Dell!"
  76. So that would make them... by PhotonSphere · · Score: 1

    ...MyKEA?

  77. MySQL isn't appropriate for anyone by jgardn · · Score: 1

    As an experienced web developer, and having extensive experience with both databases, the "quirks" in MySQL quickly become unbearable. What do you mean my backup wasn't consistent? What do you mean the data I just incremented one operation ago is back to its old value? Why, when I clear the table, do I get old ids that should now be bad?

    The fact that PostgreSQL does it right, and does it the way you expect it to be done, and does it better, means that I choose it every time. The fact that only PostgreSQL cares about backing up your data consistently, providing a consistent transaction, and allows you to do row-level locking, means that only it is up to the task you will inevitable have for it.

    As you grow and understand what databases really are, you will begin demanding it do more work for you. With MySQL, you can't grow. With PostgreSQL, you can grow as much as you like.

    I've never understood the complexity argument. Apparently, you don't need transactions and sequences and consistent backups if your just doing something simple. I thought things should _just work_ for beginners. Why are you suggesting something that _doesn't just work_ for beginners?

    Question: Do you have data? Answer: Yes. Suggestion: Since you have data, you need to use PostgreSQL.

    --
    The radical sect of Islam would either see you dead or "reverted" to Islam.
    1. Re:MySQL isn't appropriate for anyone by Anonymous Coward · · Score: 0

      "I once heard MySQL has problems, like, 40 billion versions ago. Therefore MySQL is a total waste of time."

      I think I managed to summarize your entire post. Wait...I think I have a more succinct version:

      "I'm totally full of crap."

      Better?

    2. Re:MySQL isn't appropriate for anyone by fatboy · · Score: 1

      I love seeing posts on /. like this. MySQL? Your using it right now. :)Hehehe.

      --
      --fatboy
    3. Re:MySQL isn't appropriate for anyone by Anonymous Coward · · Score: 0

      MySQL STILL has major problems. It swallows constraints defined on the column level quietly, even on innodb tables. It still, by default, truncates values to fit in a given numeric type. It still, by default, lets you try to define a FK relationship from / to a myisam table without so much as a peep. It still allows you to insert dates that aren't real. Most of the problems listed on the gotchas page still apply.

  78. Great now we'll have Nofen Glocken Blop SQL trans by gmezero · · Score: 2, Funny

    We'll need to hire the Swedish Chef to figure out what the hell everything means now.

  79. Re:Ikea as a business model, not a customer model. by Anonymous Coward · · Score: 0

    It should be noted that "here" should be here.

  80. Berkley and SQLLite by oliverthered · · Score: 1

    I can't see any reason why people would use MySQL even for small single access databases, Berkley DB is faster and SQLLite can be faster and is much better, and for everything else there's PostgreSQL. I suppose there's a fair amount of money invested in newbie HOWTO's for MySQL and that can be the only reason for people (and many ISP's) to even bother installing MySQL.

    --
    thank God the internet isn't a human right.
    1. Re:Berkley and SQLLite by ocelotbob · · Score: 1

      Mysql has berkely db support built into it for those concerned about speed. If you need transactions, InnoDB is quite good. MySQL is widely used because it is so adapatable; chances are, the MySQL team has already developed a DB setup for what you need. People like MySQL because it's flexible.

      --

      Marxism is the opiate of dumbasses

    2. Re:Berkley and SQLLite by Anonymous Coward · · Score: 0

      If you don't need transactions, /dev/urandom is a much faster way to generate garbage.

    3. Re:Berkley and SQLLite by oliverthered · · Score: 1

      People like MySQL because it's flexible.

      Not really, it doesn't have enough features to be flexible in any kind of usefull way (when compaired with the other options)

      --
      thank God the internet isn't a human right.
  81. OT: Valuable time by freeweed · · Score: 1

    you can save a bundle if your time is not that valuable

    I can't speak for everything IKEA sells, but for a lot of things, the $100 (or more) I saved is more than worth the 15 minutes it took me to assemble the thing.

    Kinda like Linux. Personally, the 2 or 3 extra hours I might spend fussing with Linux is still worth the $300 saved on a Windows license.

    To most people I know, $100/hour or more is a damn good wage :)

    --
    Endless arguments over trivial contradictions in books written by ignorant savages to explain thunder in the dark.
    1. Re:OT: Valuable time by init100 · · Score: 1

      Kinda like Linux. Personally, the 2 or 3 extra hours I might spend fussing with Linux is still worth the $300 saved on a Windows license.

      Now, somebody will probably say that configuring Linux takes a lot more than three hours unless you are experienced. But then I would claim that Windows could take quite some time to configure correctly, not to mention periodic reboots to clear bogus file locks, where Windows claims that a file is locked even if I haven't used it.
    2. Re:OT: Valuable time by freeweed · · Score: 1

      Yup. And I'd agree with both points.

      ANYTHING takes experience to be able to do it quickly and efficiently. Personally, I'm about as good with Windows as I am with Linux, and I find they both take about the same time, from a fresh install to usable. Linux because I have to mess around with the odd driver or X setting or something, plus apt-get a few packages. Windows because I have to play the CD shuffling game, plus run through some installers, change some settings, secure it, etc. For me, 2-3 hours is about what it takes to get either system up to usable status.

      Same thing with IKEA furniture. I have better tools than they do (small Allen wrenches, ick), and a fair bit of experience with self-built furniture. I can put together a bookshelf or a desk in a few minutes, while many people take a lot longer.

      Then again, I'm horrible with cars. It'd take me a full day just to change the oil or replace a tire, even if I had the proper tools. Much easier to just pay someone the $50, because my time is worth more than that.

      I guess the point is, I spend my time doing the things I can do efficiently, but otherwise I'd just as soon pay someone to do it for me.

      --
      Endless arguments over trivial contradictions in books written by ignorant savages to explain thunder in the dark.
  82. MySQL ... considered an enterprise grade system. by temojen · · Score: 1

    Right... Around this enterprise, we like strict ACID, Nested queries, Standard SQL syntax and semantics, and 24/7/365 availability. On mature systems, not the latest development release. Without having to carefully choose our table types.

  83. Oracle acquires Innobase OY; terms undisclosed :D by Anonymous Coward · · Score: 0

    Market Pulse: Oracle acquires Innobase OY; terms undisclosed
    Friday October 7, 1:49 pm ET
    By Katherine Hunt

    SAN FRANCISCO (MarketWatch) -- Oracle Corp. said Friday that it has acquired Finland-based Innobase OY, an open source software company. Terms of the transaction weren't disclosed, Redwood City, Calif.-based Oracle said.

  84. Ikea - cheap and easily breakable by ncg · · Score: 1

    Does this mean that MySQL will become easily breakable like its cheap furniture counterpart, and that Craigslist will be inundated with used and crappy MySQL databases?

    Perhaps this also means that MySQL will not handle data moves very well, and becoming rickety over time.

    Maybe it will baby-sit your children in a virtual ball bin. (perhaps the only perk of IKEA).

    Poor analogy. They should really work with a PR agency before they associate their name with a place that harbors inferior quality merchandise.

  85. i think i see the analogy by Anonymous Coward · · Score: 0

    just like ikea, you will get it because it's cheap and light, it will break soon after, and then you'll replace it with more durable furniture like PostgreSQL.

  86. Re:Does that mean... (Yes, it does!) by Anonymous Coward · · Score: 0

    Looking at Ikea's web site, I see $101 sinks and $99 faucets, carts going up to $129, etc. The most expensive item they list is a $239 cabinet that is the base for a sink (largely made of particleboard). If you think those are expensive, check the price range for any other major home retailer's sinks. I'm liking this MySQL:IKEA analogy more and more...

  87. Like Amelio making Apple the Maglite of computers? by Anonymous Coward · · Score: 0
  88. Someone should be disbarred for that.. by Anonymous Coward · · Score: 0

    Let me just start off by suggesting that you should have read the GPL before taking such drastic advice from a lawyer that clearly was either incompetent, ignorant, or perhaps just with a malicious axe to grind. The GPL was written by a non-lawyer, for general consumption and understanding; it is not particularly long, nor particularly hard to understand. That said..

    Although we met several technical challenges along the way
    (specifically, Linux's lack of Token Ring support and the fact that we
    were unable to defrag its ext2 file system), all in all the process
    went smoothly. Everyone was very pleased with Linux, and we were
    considering using it for a great deal of future internal projects.


    Er.. Linux has had support for token ring hardware for a very long time. Glancing briefly at the configuration for the kernel I'm currently using, I see that it still does. (If there are some nuances to "token ring support" I'm not aware of, then perhaps you're correct.. but it is misleading to phrase it the way you did.) Also, there are freely available utilities to defragment ext2. These two points suggest to me that you may have skimped on the research phase of your project, but anyway..

    So you can imagine our suprise when we were informed by a lawyer that
    we would be required to publish our source code for others to use. It
    was brought to our attention that Linux is copyrighted under something
    called the GPL, or the Gnu Protective License. Part of this license
    states that any changes to the kernel are to be made freely available.
    Unfortunately for us, this meant that the great deal of time and money
    we spent "touching up" Linux to work for this investment firm would
    now be available at no cost to our competitors.


    First, it is the GNU General Public License (not "Protective"). I'll resist the urge to go off on an educational rant about the philosophy of free software, and the karma contributing back to a project which cost you nothing. But there's still alot wrong with what you said.

    You are required to distribute the source WITH THE PRODUCT. You aren't required to give the source to anyone you do not give the product to. If you are using the product internally and do not sell it on the market, your source modifications can remain internal as well. But more importantly, how much of your overall project was implemented in the kernel? I assume you were building some sort of application on top of Linux; despite FUD about the word "viral" connected with the GPL, the conditions on the Linux kernel do not taint your copyright of applications that run on it.

    Furthermore, after reviewing this GPL our lawyers advised us that any
    products compiled with GPL'ed tools - such as gcc - would also have to
    its source code released. This was simply unacceptable.


    It is exactly as acceptable as it is true. (You really need to hire better lawyers.)

    Although we had planned for no one outside of this company to ever
    use,


    'Nuff said, and see above. You just doubled your engineering costs based on some very poor advice. Given the amount of time you say went into this, you should probably sue the firm these lawyers work for to get compensation. (Find better lawyers to handle this one.)

    I think the biggest thing keeping Linux from being truly competitive
    with Microsoft is this GPL. Its draconian requirements virtually
    guarentee that no business will ever be able to use it. After my
    experience with Linux, I won't be recommending it to any of my
    associates. I may reconsider if Linux switches its license to
    something a little more fair, such as Microsoft's "Shared Source".
    Until then its attempts to socialize the software market will insure
    it remains only a bit player.


    If your associates take such advice without talking to real lawyers, I feel bad for them. Your misunderstanding of the GPL is tragically grave. The fact that you call "shared source" "more fair" probably indicates a more systemic lack of understanding about how licenses and copyrights work. You *really* need to hire real lawyers next time; I cannot stress that enough.

  89. Re:MySQL ... considered an enterprise grade system by KluZz · · Score: 1

    Despite the risk of sounding like a religious fanatic: Amen!

  90. Re:The database for homosexuals? by rindeee · · Score: 1

    I've never seen the commercial. Every gay guy that I know/associate with shops Ikea. It's a common joke among them (my group of peers, gay and straight alike). I'll inform them of your having taken offense to it on their behalf, I'm sure they'll feel that the world is a much safer place for it. And please, waste some more of your precious karma on me.

  91. Maybe it has something to do with... by jadavis · · Score: 2, Informative

    http://www.oracle.com/corporate/press/2005_oct/inn o.html

    Perhaps MySQL is saying "We aren't competing with Oracle" because Oracle has MySQL in a difficult position. Oracle just purchased InnoBase, the makers of InnoDB. They get to "renegotiate" the terms next year. MySQL may end up having to drop the InnoDB storage engine, and transactions along with it. After all, it's Oracle's option.

    --
    Social scientists are inspired by theories; scientists are humbled by facts.
  92. Re:Oracle acquires Innobase OY; terms undisclosed by jadavis · · Score: 1

    Here's the link for those interested:

    http://www.oracle.com/corporate/press/2005_oct/inn o.html

    The license for InnoDB is up for renewel next year... guess that means that Oracle has a very strong position against MySQL. Maybe that's why MySQL is issuing press releases saying that they're not a competitor. MySQL may have to actually drop the InnoDB storage engine -- at Oracle's discretion.

    --
    Social scientists are inspired by theories; scientists are humbled by facts.
  93. What, you mean junk? by ClogHammer · · Score: 0

    Something that will collapse under the least bit of pressure? Something made of ground wood and resin, hidden under a real smooth facade? Crap for everyone means everyone has crap.

  94. Re:TUNGSTEN!!! by dtungsten · · Score: 1

    I'm here. What to you want? :)

  95. What IKEA means... by Anonymous Coward · · Score: 0

    Idioten Kaufen Einfach Alles

  96. Oracle bought part of their product, so they can't by Christopher+B.+Brown · · Score: 1
    According to this Oracle Press Release on InnoDB Acquisition, Oracle has purchased Heikki Tuuri's company that was responsible for providing the "ACID engine" for MySQL(tm).

    That would make it really awkward for MySQL AB to say anything to the effect that they intended to somehow compete with Oracle. It would presumably be grounds for terminating the ability for MySQL AB to continue to sell their product with a transactional engine...

    --
    If you're not part of the solution, you're part of the precipitate.
  97. Mmmmm, meatballs by wsanders · · Score: 1

    If only I didn't have to spend 45 minutes stuck in traffic and hiking 1/2 mile across the parking lot to get them.

    Come to think of that, it's just like MySQL?

    Now, when will I see it in the frozen food section at Safeway?

    What was the question?

    --
    Give a man a fish and you have fed him for today. Teach a man to fish, and he'll say "WHERE'S MY FISH, YOU IDIOT?"
  98. I'm Jack's RDBMS by maluke · · Score: 1

    subj.

  99. MAXDB! by Anonymous Coward · · Score: 0

    MySQL has obtained the rights to the old Adabas, SAP DB, and renamed it MAXDB. This database does have views, and is industrial strength, and has a long history, so the bugs are long gone. Give it a try.

  100. Re:Zoos by EwokMolester · · Score: 0

    Thanks for modding me down, just because you don't understand something doesn't make it 'redundant' for everyone else. Bell-end!