Slashdot Mirror

← Back to Stories (view on slashdot.org)

IBM Invests In MySQL/Oracle Competitor

Posted by kdawson on from the here-store-this dept.

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.'"

53 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. EnterpriseDB also has Cloud Database service by 1sockchuck · · Score: 3, Informative

    Interesting. EnterpriseDB was also in the news today for its partnership with Elastra, a startup that announced a "cloud server" that lets companies quickly create database applications on Amazon's utility computing platform. "In the future, enterprises will view massive capital investment in on-premise server infrastructure to support database applications as entirely optional," said Bob Zurek, chief technology officer of EnterpriseDB, which uses Elastra to run its EnterpriseDB Cloud Edition. Maybe all that IBM money has their head in the clouds.

    1. 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?

      --
    2. Re:EnterpriseDB also has Cloud Database service by totally+bogus+dude · · Score: 2, Informative

      Akamai don't generally host the data, they just mirror it. Although they are the public face of your site and therefore you need to trust them, if you do start to get nervous about them you can just adjust your DNS so nobody uses their servers -- you're still in control of the first link in the chain, and you're still the original source of the content.

      Having your data on Amazon's servers is more like having your email in a Gmail account. The best you can do is frequently back it up so you have a local copy, but since it's the live data you're always going to be slightly behind, and if the company hosting it decides to deny you access to it for some reason (legal, technical, bullying, incompetence) you're pretty much screwed until you can get the courts to force them to give you access to your data.

      Another difference is that Akamai are caching data which is intended to be public (or at least semi-public), which may not be the case with a hosted database app. If you've got private data you won't be putting it on your website for Akamai to cache in the first place, and if you have a secure "members only" area there's a good chance that content will only be on your own servers, and not served by Akamai. But if all of your data (both public and private) is on someone else's servers, then you're trusting them to a) keep it secure and b) respect your privacy.

  3. 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 chromatic · · Score: 3, Insightful

      What suggests to you that the terms "open source" and "commercial" are antonyms?

      --
      how to invest, a novice's guide
    2. 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.

    3. 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.
    4. Re:MySQL databae supremacy by Omnifarious · · Score: 2, Insightful

      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.

      This is a blatant distortion bordering on an outright lie.

      MySQL community edition is licensed under the GNU GPL (version 2 even) and may be used inside any random commercial entity without having to distribute anything. And if you want to use MySQL in commercial software you may use it as long as you distribute source code for MySQL and any changes you have made to it.

      It is true that the interface libraries are also covered by the GPL. But this can be gotten around easily enough by writing your own interface libraries, or having a GPLed thunk which speaks a proprietary protocol to your proprietary application and then uses the MySQL GPLed interface layer to talk to MySQL.

      Personally, I consider PostgresSQL's license to be less free, and I'm disappointed in IBM for supporting it in any way. Ultimately IBM is throwing away their money by doing this. The article even tells you why PostgresSQL's license is less free. The company distributes proprietary extensions to PostgresSQL. They've essentially forked the code. If their proprietary extensions even become widely accepted and relied upon they have essentially rendered PostgresSQL no longer Free Software.

      I'm surprised that IBM would be throwing away money on such a thing. They are essentially encouraging the development of another little monopolistic company making secret software that could ultimately hurt them very badly.

      --
      Need a Python, C++, Unix, Linux develop
    5. 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.
    6. Re:MySQL databae supremacy by thedarknite · · Score: 2, Interesting

      That may well be true now, because the last time I tried using PostgreSQL was nearly two years ago and it was a configuration nightmare that was poorly documented for windows. But if PostgreSQL is so much easier to use now than MySQL, 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?

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

      --
      A game has objectives and is competitive, anything else is just play
    7. Re:MySQL databae supremacy by Spy+der+Mann · · Score: 3, Insightful

      It is true that the interface libraries are also covered by the GPL. But this can be gotten around easily enough by writing your own interface libraries

      Yeah sure... we all do that (/sarcasm).

    8. Re:MySQL databae supremacy by Niten · · Score: 3, Interesting

      Sadly, there's still the whole WordPress thing -- the darn program was never intended to work with anything other than MySQL at the back end. At one point there was an effort to "port" WordPress to PostgreSQL, but that fork has long since stagnated. And adding support for other databases is not on the WordPress team's short list.

      I wouldn't know the actual numbers any better than the next guy, but it's clear that WordPress is one of the top reasons MySQL retains such a dominant market share in the Web segment. Until WordPress adds support for multiple back-ends, MySQL will always be, at minimum, just as entrenched a product as WordPress is.

      I hope that Movable Type's recent open-sourcing will eventually help effect more widespread adoption of PostgreSQL. Unlike WordPress, MT was designed from the ground up with forward-thinking features like database abstraction; it currently supports the Berkeley Database format, SQLite, PostgreSQL, and MySQL, and adding support for additional back-ends is relatively easy. Perhaps if Movable Type can chip away at WordPress's market share a bit, it will in turn help relax MySQL's stranglehold on the Web market.

    9. 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.
    10. Re:MySQL databae supremacy by Ed+Avis · · Score: 2, Informative

      I think the EnterpriseDB extensions are for companies currently using Oracle who want a cheaper alternative. They do not affect the core Postgres development.

      Note that MySQL AB is also free to distribute proprietary extensions to MySQL, since they own the copyright. And this is much more likely to affect MySQL core development, since you have the same company maintaining the free version and trying to sell proprietary addons.

      --
      -- Ed Avis ed@membled.com
    11. Re:MySQL databae supremacy by LurkerXXX · · Score: 3, Interesting

      As the other poster said, inertia.

      I run a few mysql servers in addition to postgresql and mssql servers. I LOATHE mysql. Yet I use it in a few cases. Why? Because there are a few applications I need to run which were unwisely written to only support mysql. If postgresql or any other database support is ever added to them (or I ever find the extra time to add it myself) I'll switch in a heartbeat. But for now, since I need to run those applications, I am stuck using mysql.

      So don't think every mysql server running out there is running it because the admin thinks it's the best or even just-as-good of a database. (It isn't)

    12. Re:MySQL databae supremacy by asc99c · · Score: 2, Informative

      MySQL is a database that is very well suited to running a web application. That's why. Many web apps are generally going to have many more reads than writes. Additionally, the writes tend to be pretty simple and not require complex locking mechanisms.

      E.g. my photos website uses gallery2 which works easiest on the LAMP stack. The main database queries are simple - what albums are there, does the user have permission to see them, what photos are in this album etc. The updates are similarly easy - add a new album, add a new photo, add a new user. For this, MySQL is perfect, simple and fast.

      However once you start writing more complex systems with tougher constraints things become a lot harder. Typically, you have a record in a state that needs notifying to another system. You need to read that record, send a message to the other system and then modify that record to say the message is sent and the other system then has control over it. For this you need the various locking mechanisms and guarantees from the database or the two systems get out of line. MySQL just isn't the database to use for that sort of application.

    13. 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.

    14. Re:MySQL databae supremacy by 0xdeadbeef · · Score: 2, Funny

      It is true that the interface libraries are also covered by the GPL. But this can be gotten around easily enough by writing your own interface libraries, or having a GPLed thunk which speaks a proprietary protocol to your proprietary application and then uses the MySQL GPLed interface layer to talk to MySQL.

      Wow, freedom sure sounds complicated.

      In other words, "The GPL of MySQL is awesomer because, with a lot of work, you can violate its intent without violating the license!"

    15. Re:MySQL databae supremacy by MrMunkey · · Score: 3, Insightful

      The only feature that has been keeping me from using PostgreSQL in work projects is replication. My company requires that there be multiple backups at all times, and MySQL's replication has done a pretty decent job (mysqldump -u user -p -master-data -databases db1 db2 -create-options > file.sql allows me to create a new slave quite easily). I do know there are projects out there, but they're just not quite ready yet: http://edoceo.com/liber/db-postgresql-replication

      Feel free to let me know if there's another way to do this, because foreign keys would be great :)

    16. Re:MySQL databae supremacy by portnoy · · Score: 2, Insightful

      And yet, I can take the PostgreSQL code, create some new extensions under the GPL, and then license the result as a GPL work. So, um, how again is the BSD license less free than GPL, if I can create a GPL'd work from it?

    17. Re:MySQL databae supremacy by eric2hill · · Score: 2, Informative

      Now that PostgreSQL properly (native binaries vs Cygwin and fast/east installation) supports Windows, only a fool would use PostgreSQL for new projects.
      Did you mean MySQL? :)
      --
      LOAD "SIG",8,1
      LOADING...
      READY.
      RUN
    18. Re:MySQL databae supremacy by h3 · · Score: 2, Insightful

      Serendipity supports Postgres and has for a long time (though I can't say for certain that it did from birth). Which is why I use it. As with other projects of this nature (Drupal comes to mind), though the core supports Postgres quite well, 3rd party plugins sometimes fall into MySQL-only habits, but that hasn't been too problematic for me.

      Frankly, in this day and age, I'm leery of projects that are written to MySQL specifically. To me, it smacks of amateurdom: if you don't know enough to use an abstraction layer (of which there are jillions of options), what does that say about the quality of your code as a whole?

    19. Re:MySQL databae supremacy by DragonWriter · · Score: 2, Insightful

      The GPL is more free because it preserves freedom. The BSD license is less free because it allows that freedom to be taken away.


      So, the GPL is "more free" because it gives the licensee less freedom, and imposes more of the licensor's ideology on the licensee while the BSDL is "less free" because it gives the licensee more freedom, and imposes less of the licensor's ideology on the licensee.
    20. Re:MySQL databae supremacy by smellotron · · Score: 2, Informative

      MySQL might be the right answer, as long as you don't need to use more sofisticated stuff, like triggers or transactions.

      Or complex joins, multi-level joins, or functions that return recordsets (essentially "efficiently-parametrized views"). My last attempt at creating views within views resulted in a LEFT OUTER JOIN somehow transforming itself into an INNER JOIN, forcing me to "inline" the entire SQL query into a single view. Oh yeah, and the performance wasn't so great, and the MySQL "query explanation" capabilities suck, so I had a much harder time improving said performance.

  4. 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.

    1. Re:Interesting... by Cosmic+Debris · · Score: 3, Insightful

      No money to be made on software, eh? Don't tell Steve Mills that. He's been working under the assumption that IBM is one of the world's largest software companies and that it's quite profitable, thank you.

      I know this for a fact. And btw, when did you last check your figures? Take a look at IBM's 2007 annual statement and get back to me.

      Since your thoughts are random, I'll assume you're using Microsoft's Random Number Generator.

    2. Re:Interesting... by khakipuce · · Score: 2, Insightful

      Not only did Sun buy MySQL, Oracle is after BEA (Weblogic, amongst other things). Now, from a Java perspective, Sun used to be the langauge provider, Oracle seemed to have become the de-facto database to run heavy weight Java applications against and IBM Websphere, or BEA Weblogic was the app server.

      I just wonder if these guys are all about to explode the Java App server space (watch out for shrapnel), and try to drive customers down either:
      Sun - Glassfish, MySQL
      Oracle - Weblogic, Oracle database
      IBM - Websphere, PostgreSQL

      What is more concerning is that it seems likely that such fragmentation will cause non-technical management to run for cover under .NET

      BTW whilst Sun has Solaris and IBM has AIX they all have Linux on which to run, and I guess that Oracle just isn't bothered about getting into hardware.

      --
      Art is the mathematics of emotion
  5. db2... by fatp · · Score: 3, Interesting

    Why isn't this a competitor of db2?

    1. Re:db2... by DougReed · · Score: 3, Funny

      Because DB2 isn't really a competitor. It's not really a bad database, but I think only three people in the world is running it. ...my wife being one.

    2. 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.
    3. Re:db2... by TheLink · · Score: 3, Interesting

      It's not rare for IBM to sell stuff which competes against products its subunits make.

      You can have one IBM unit recommending/selling Cisco products which compete against more expensive IBM products by another IBM unit. You need some Sun stuff to work with some Microsoft stuff? IBM will say they'll do it.

      From what I see, IBM is about providing choice, and helping customers make that choice for $$$$ :).

      If there isn't much choice you don't need as much "consulting" and support. For example if your choices are: reinstall, or format and reinstall, I don't think you'll want to pay a lot.

      --
    4. Re:db2... by firefly4f4 · · Score: 2, Insightful

      Why isn't this a competitor of db2?

      For the same reason PostgreSQL and MySQL aren't really competitors to Oracle.

      There might be SOME crossover, but one database system (MySQL, PostgreSQL) is aimed at user performing simpler tasks (web forums, home users) which don't necessarily need all the features of the larger products (transactions, large numbers of simultaneous users, data integrity checking), whereas the other (DB2, Oracle) is aimed at business users who require those full-fledged features.

      Now, I'm not saying that PostgreSQL and MySQL don't provide some of the features, but people will choose what best suits their needs. You won't see banks running PostgreSQL/MySQL on for their financial transactions, just like you most likely won't see DB2/Oracle running as the backend of your (run-of-the-mill) web forum.

      Disclaimer: I work for IBM. These thoughts are my own, and may not represent those of the company.

  6. 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?

    1. Re:Still waiting for a decent GUI by timmarhy · · Score: 3, Insightful
      it's simple. no one in the open source world is dumb enough to WANT to be known as the access db of the open source world.

      postgresql has a couple of brillant gui tools that hold their own easily against sql server managment 2005.

      --
      If you mod me down, I will become more powerful than you can imagine....
    2. Re:Still waiting for a decent GUI by InlawBiker · · Score: 3, Insightful

      Maybe because nobody wants to complain about a missing GUI when the product is free. But anyway I've found 4 GUIs for Postgresql in a quick search, not counting Navicat. I've never used it but it looks very nice. I've used PG Admin, which is great for simple work. Most of these are better than Access, which is just a toy, but not as good as Microsoft's query analyzer (now called "server management studio" I believe).

      I have specialized in database applications with a web front-end for a while now. While they can't touch Oracle yet (or even MS SQL), Postgresql and MySQL are rapidly improving, and beat some of the expensive commercial offerings of not too long ago. A lot of medium-sized applications can exist just fine on either one. Eventually they will find the limitations of either system too limiting and switch, but for starting up they are both good back ends. With an expert at the helm, a serious application running either MySql or Postgresql is very possible.

      At the rate they're improving MS and Oracle should be very concerned. IBM and Sun throwing serious money into the mix is a very interesting development.

    3. Re:Still waiting for a decent GUI by ashridah · · Score: 3, Informative

      Uh. Because we actually do have a product like this?

      OpenOffice.org has support for pulling data from a database.
      It also has support for a forms-like interface.
      It also has it's own vb-alike language. (Still in development perhaps, by the looks of it)

      There are also plenty of other tools. RealBasic, etc.

    4. Re:Still waiting for a decent GUI by fatp · · Score: 2, Informative

      I basically agree with your comment. Actually, I did a lot of search recently for application builder (which run on windows) for PostgreSQL and have the following findings:

      1) OpenOffice.org: Very poor scripting ability... wait for 3.0
      2) pgaccess: Access for PostgreSQL. Looked promising, with Form Editor, Report Editor etc & scripting with TCL. But the project is dead and website is recycled.
      3) bond (http://www.treshna.com/bond/): Looked interesting but I could not run the windows version... never tried linux version :P
      4) rekall, knoda: both are database frontends for KDE. Looked interesting. I hope they will come with KDE on windows

      Also, if your objective is to find something free (as beer), and have plenty of resources, you can have a look on Oracle XE+Application Express. Looks a bit strange at first (with a non-WYSIWYG form builder), but much better after one understand its design concept.

    5. Re:Still waiting for a decent GUI by jaseuk · · Score: 2, Interesting

      Maybe because nobody wants to complain about a missing GUI when the product is free. But anyway I've found 4 GUIs for Postgresql in a quick search, not counting Navicat. I've never used it but it looks very nice. I've used PG Admin, which is great for simple work. Most of these are better than Access, which is just a toy, but not as good as Microsoft's query analyzer (now called "server management studio" I believe).

      You've missed the point with Access. Access is a very simple to use application development environment. Someone with minimal database and programming experience can cobble together straightforward applications. Discounting Microsoft Access as a toy really shows ignorance of the power of the platform, the database engine may have been limited particularly with scaling and multiuser performance, but it's SQL feature set was far superior to MySQL for many years supporting features such as subselects, constraints and foreign keys.

      I'm not an Access fan by any stretch of the imagination, but it has a niche that is not filled by pretty much any other commercial or open-source database in that a "power user" can put together an application.

    6. Re:Still waiting for a decent GUI by ashridah · · Score: 2, Funny

      That's okay. He wanted a tool similar to access....

  7. Commercial open source software by Per+Abrahamsen · · Score: 2, Insightful

    That's not really open source. It is open source, according to the people who invented the term.

    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. MySQL doesn't make you pay a license fee in commercial software, if you distribute your software under an open source (as defined by the people who invented the term) license. Like, e.g., Sun does with their very commercial MySQL product.

  8. Postgres clusters? by the_greywolf · · Score: 2

    What I want to know is can I run a Postgres DB on a cluster of servers? We want to add some failover capabilities to our server cluster, and our current solution is incapable of five-nines availability. Is there a way to cluster them to provide both load-balancing and redundancy with a single database?

    I've heard Oracle has some capability to that end, but I'm not clear on just what it can do.

    --
    grey wolf
    LET FORTRAN DIE!
    1. Re:Postgres clusters? by greg1104 · · Score: 3, Informative

      The subject of this article, EnterpriseDB, is trying to target this market with GridSQL. As it's new in it's current form, impossible to say how reliable systems built with it will be quite yet. Those looking for reasons behind the IBM investment might consider whether GridSQL might one day talk to DB2 databases as well.

      The closest fully open-source PostgreSQL solution to your requirements that's been around a bit is pgpool-II. It think it's still too immature to be considered five-nines quality though, and there are some restrictions you have to observe. A PostgreSQL replication solution that is very robust and proven is slony but it's not a load-balancing solution in the way I suspect you want.

      There's also the Greenplum Database, which isn't free or open-source but is rooted in PostgreSQL technology.

      Good enterprise-grade clustering with load-balancing is still on the PostgreSQL work in progress list rather than being here right now. I expect the core infrastructure piece needed to really make it work well (support for read-only warm-standby slaves) will make it into PostgreSQL 8.4 and be released around a year from now. I started a comparison page of the replication solutions currently available that's on the PostgreSQL wiki now that is trying to track progress in this area. Much like core PostgreSQL support for enabling replication, it still needs some work .

  9. 20% revenue, 40% profit by Per+Abrahamsen · · Score: 2, Insightful

    The software division of IBM accounts for 20% of their revenue, and 40% of their profit.

    See http://www.ibm.com/annualreport/2007/md_4rco.shtml

    Key applications are WebSphere, "Information Management" (db2?), Lotus, Tivoli, Rational, and operating systems.

    Some of this is probably tied to the success of their hardware and service departments, I doubt many people buy IBM operating systems (2% of their total revenue, 12% of their software revenue) without IBM hardware.

    But the non-disclosed revenue from Rational is probably pretty much standalone.

  10. 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.

  11. 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

    2. Re:PostgreSQL ROCKS by tuxbond · · Score: 2, Informative

      I've never understood why the "MySQL" buzzzzzz everywhere. PostgreSQL has been a __real__ DBMS from its beginning. It had support for really huge tables and it has an ingenious way to work around the 2GB file size limit on the old file systems.

      The replication is its weakest point (it was non-existent for a while). The commercial and free packages to bring replication to PostgreSQL were sometime good and others don't. Many projects started it but were down or dorman in a year or so. Hopefully new efforts will finally bring that feature with the same rock solid standing as the other PostgreSQL features.

      Happy to see IBM around!

  12. Postgres: Best Intro of All Worlds by Doc+Ruby · · Score: 3, Insightful

    IBM buying into Postgres through EnterpriseDB is clearly a response to Sun's buying into MySQL. But what's really exciting about the move is that Sun also bought into Postgres, shipping it with Solaris 10 and integrating it with its Java App Server, as an entry-level database. Since Sun is also supporting and bundling MySQL (and therefore using it to drive sales of Sun machines), tools for porting between Postgres and MySQL are likely in the works.

    Now IBM will follow suit, probably offering Postgres as an intro to selling its DB2 database, which will mean IBM tools for upgrading from Postgres to DB2. Meanwhile, EnterpriseDB already offers tools to port Oracle apps to Postgres.

    The next move will probably come from Oracle. To continue the head-to-head competition, Oracle will probably offer tools for porting Postgres (and maybe MySQL) apps to Oracle. It's surprising that Oracle didn't buy a Postgres or MySQL company before Sun or IBM got them, but maybe that's why Sun bought one of each: to keep them from Oracle. Though Oracle did buy the InnoDB corp that makes the MySQL engine with serious DB features, and SleepyCat, the BerkeleyDB corp.

    So as the dust settles, there could finally be a grand unification at work. IBM, Sun and Oracle each have incentive and in-house teams for producing tools to port between Postgres, MySQL and their proprietary high-end RDBMS'es. And since the lower-end (though Postgres competes well with them all) DBs are all open source, there is a good chance the upgrades will be available for freely porting among all of them.

    The age of database lockin might finally be falling behind us. We might finally be free to use whichever DB is best for the job today, not determined by which DB was best for some other job yesterday.

    --

    --
    make install -not war

  13. PostgreSQL runs factories by Colin+Smith · · Score: 2

    MySQL runs web sites.

    Almost literally. I know of at least one large multi billion dollar semiconductor manufacturer which basically runs it's fabs on postgresql.

    --
    Deleted
  14. Re:MySQL license clarification: free as in freedom by TheSunborn · · Score: 3, Informative

    The problem is that the client lib, which applications link with when they need to talk to mysql is also gpl. So I i write a
    c++ program which connect to mysql, I need to release my application under a gpl compability license.

  15. Re:Anyone working on a modern comparison? by greg1104 · · Score: 2, Informative

    Why PostgreSQL Instead of MySQL: Comparing Reliability and Speed in 2007

    I'll have a 2008 update out soon now that PostgreSQL 8.3 has been released.