Slashdot Mirror


IBM Invests In MySQL/Oracle Competitor

stoolpigeon writes "IBM has made a move to support open source RDBMS PostgreSQL by investing in EnterpriseDB, a company that supports PostgreSQL as well as selling their own proprietary extensions to the database product. IBM participated in a $10 million funding round, though the article doesn't say how much they invested. In the past EnterpriseDB has primarily advertised itself as an Oracle competitor, though the article says, 'Derek Rodner, EnterpriseDB's director of product strategy, explained that Postgres Plus 8.3 also adds in new application quick starts which are supposed to help with installation issues. They will also help in EnterpriseDB's battle against MySQL for open source database supremacy.'"

15 of 204 comments (clear)

  1. geeks want to do it right by Anonymous Coward · · Score: 5, Funny

    Question: how do you properly pronounce "PostgreSQL"?

    1. Re:geeks want to do it right by totally+bogus+dude · · Score: 5, Informative

      http://www.postgresql.org/docs/faqs.FAQ.html#item1.1

      PostgreSQL is pronounced Post-Gres-Q-L. (For those curious about how to say "PostgreSQL", an audio file is available.)
  2. MySQL databae supremacy by scorp1us · · Score: 4, Insightful

    Now there's an oxymoron!

    MySQL, while it has come a long way, still has a ways to go to rival PostgresSQL, technically speaking. By the time you enable all the atomicity, and PostgreSQL feature set, you arrive at worse-than PostgreSQL performance.

    MySQL, while it has come a long way, still has a ways to go to rival PostgresSQL, legally speaking. PostgreSQL is BSD. MySQL is anything but. Sure, the community edition is free, but it cannot be used with commercial software. In fact, there's a special "open source exception" to the license. That's not really open source. Open Source would never make you pay server licensing fees for use in commercial software, it would only make you distribute your source at worst.

    --
    Slashdot's rate-of-post filter: Preventing you from posting too many great ideas at once.
    1. Re:MySQL databae supremacy by Daimaou · · Score: 4, Interesting

      I completely agree. PostgreSQL used to be a bit slow, but for the last few years, there just isn't a reason to choose MySQL over PostgreSQL. PostgreSQL's license is certainly better and all the great features and SQL standards compliance makes it a no brainer, I think.

    2. Re:MySQL databae supremacy by MrNaz · · Score: 4, Interesting

      2002 called. It wants its MySQList retort back.

      MySQL is no longer easier to use than PostgreSQL. PG is now availabe for Windows with a nice packaged msi installer. It is as easy or easier to install under Linux/BSD/other POSIX, and is (if you assume the same level of experience with both system) far easier to administer.

      Not only that, MySQL's community consists of many newbies, which makes getting help on complex issues difficult. PG on the other hand has a vibrant community consisting of highly skilled DBAs and the PG core developers themselves. I've often had help from the PG core dev team members. Finding similarly skilled MySQL help is like trying to find Dodos in Manhattan.

      --
      I hate printers.
    3. Re:MySQL databae supremacy by jo42 · · Score: 4, Funny

      MySQL, while it has come a long way, ... Yep. It even supports "--i-am-a-dummy" startup option.

      Joke you not.
    4. Re:MySQL databae supremacy by MrNaz · · Score: 4, Insightful

      why is MySQL still that default database for hosted websites, and why do most open source web applications that I've looked at recommend a LAMP/WAMP stack?

      Inertia.

      Incidentally, you do know that Slashdot runs on MySQL don't you?

      Yes, which is why they need to do such a large number of crazy voodoo tricks to scale.

      --
      I hate printers.
    5. Re:MySQL databae supremacy by GooberToo · · Score: 4, Insightful

      This used to be true but no longer. The most recent release series of PostgreSQL stomps MySQL in almost every area of performance. I say, "almost" because it's possible some corner cases still exist. Now that PostgreSQL properly (native binaries vs Cygwin and fast/east installation) supports Windows, only a fool would use PostgreSQL for new projects.

      MySQL uses lots of non-ANSI SQL, teaching poor SQL habits. MySQL is feature poor compared to PostgreSQL, requiring involved work arounds to do what is easy in most other RDBMs. PostgreSQL's performance now completely rocks across the performance and scalability (PostgreSQL always was ahead here) spectrum.

      The only thing preventing MySQL users from migrating to a superior platform is poor, non-ANSI SQL learned from using a crappy MySQL platform in the first place.

  3. Interesting... by jonaskoelker · · Score: 4, Insightful

    Here's a few random thoughts:

    Having recently seen Sun buy MySQL, this looks a lot like a "me too"-move. That's not to say that it doesn't make business sense.

    Last I checked, IBM makes its money from two things: hardware and support. Note that software is not one of them; the software is (to them) merely what enables them to sell their bread and butter. It's also costing them money to develop and maintain software that drives sales.

    That's why they've invested money in Linux, and that's why they're investing money in Postgres: offering software with a good track record and a good reputation drives sales better, and cost is driven down as the software is open source.

  4. Still waiting for a decent GUI by bogaboga · · Score: 4, Insightful
    I love all these Open Source databases but what troubles me most is the absence of a decent [fully] programmable GUI to "slap" onto the actual database back-end. I would like readers to think of Access which is on top of Microsoft's jet database engine. It works and works beautifully but I loath Microsoft's products.

    Can one tell me why we (in the open source world), do not have a single product that competes with Access in terms of functionality, ease of use and ease of programming business logic?

  5. Re:EnterpriseDB also has Cloud Database service by TheLink · · Score: 4, Insightful

    Yeah, if I'm the owner of a company and not just some "Slash and Burn" CEO, I wouldn't want to have my core assets hostage to some third party _company_.

    Having it in the hands of a trusted _person_ is different. If that person works for a different company, it's harder to ensure it's always that same trusted person who manages it.

    Whereas if that trusted person works for you and the assets are in your company, it's a bit easier eh?

    --
  6. Re:db2... by afidel · · Score: 5, Interesting

    DB2 just doesn't scale down as well as some of the others so it doesn't get as much exposure to the masses, if you check out things like the TCP-H results you'll notice at the 10TB level DB2 is #1 and #3, it's typically used for very large databases running on IBM big iron. It's yet another IBM technology that kind of sits in the corner running some of the largest financial systems in the world without getting a lot of exposure.

    --
    There are 4 boxes to use in the defense of liberty: soap, ballot, jury, ammo. Use in that order. Starting now.
  7. di bi tu by Per+Abrahamsen · · Score: 5, Funny

    I asked my local IBM sales representive since they now sell PostgreSQL, and he gave the pronunciation in the subject line.

  8. PostgreSQL ROCKS by mcrbids · · Score: 4, Informative

    As the CTO of a rapidly growing, million-dollar company that provides ASP-model information management software, I can attest that PostgreSQL is just... awesome.

    It quickly and easily scales into the hundreds of millions of records with good support on commodity hardware and incredible reliability. It provides excellent data-integrity checks - it's like programming with a safety net built in! Its license is open to commercial development, the support is great, and rarely needed. We rely HEAVILY on foreign keys, constraints, and the like to ensure clean data, with a schema now at almost 200 tables, fully normalized. PostgreSQL handles 12-table joins with flair. Bonus - its syntax is highly compatible with ANSI SQL, meaning that porting a project developed on PG will easily port to Oracle or DB2, even when you use a rich database schema!

    Could it be better? Yeah - replication options are weak, especially in our environment, where we have a database schema that changes daily. But even in this case, this is mitigated by hourly database snapshots created a la cron - the performance hit is minor, and the recovery time in the (very rare) event of a failure is quick. And as a former sysad, I can attest to the number of times MySQL replication got it all wrong and had to be rebuilt from scratch.

    Really, I just don't understand why MySQL still gets all the press - in nearly every metric that matters, PostgreSQL wins hands-down.

    --
    I have no problem with your religion until you decide it's reason to deprive others of the truth.
    1. Re:PostgreSQL ROCKS by sirket · · Score: 4, Interesting

      I love postgres- use it to handle millions of queries per day- but let's not kid ourselves: postgres replication in the form of slony blows. I have a master DB and it plublishes to a dozen read only databases. Managing that with slony just plain sucks. The simple fact is that setting up replication with mysql is dirt simple and that's part of why people use it.

      I'm thinking of giving EnterpriseDB and their custom replication engine a try.

      -sirket