Slashdot Mirror

← Back to Stories (view on slashdot.org)

Postgres Engine for MySQL Released

Posted by CmdrTaco on

SlashRating© 11.9 slashdottit! tm krow writes "One of the unique qualities of the MySQL server is its ability to have multiple storage engine operate concurrently. Companies like Oracle and Solid have contributed their own storage engines to the open source project. With 5.1 MySQL has added the ability to now do this in a loadable fashion, allowing dynamic engines in the same manner as Apache with its modules. Now PostgreSQL can add its self to the list of databases who have contributed a storage engine to MySQL. I'm releasing today a plugin so that you can now plugin the Postgres database engine into MySQL and have it work natively along side other engines."

9 of 78 comments (clear)

  1. BUT... by dark_15 · · Score: 5, Funny

    Will it blend?

    --
    Unto the upright there arises light in the darkness...
  2. should speed up Postgresql by Anonymous Coward · · Score: 5, Funny

    One of the problems with Postgresql versus MySQL is that it is typically much, much slower and less capable. THis should address those problems.

  3. Eh by Spazntwich · · Score: 3, Funny

    5.1 is old. Wake me up when they've got a true 7.1 setup available.

  4. Can't hold my breath... by Epaminondas+Pantulis · · Score: 3, Insightful

    till they release a DBase III engine...

  5. Re:The Lamest April Fools Story Yet by VJ42 · · Score: 4, Funny

    It's like "OMG Postgres!!!!" Perfect tag! :P
    --
    If I have nothing to hide, you have no reason to search me
  6. laugh if you like... by doom · · Score: 4, Interesting
    Laugh if you like, but you can actually do this trick the other way around, if you like:

    There's a project called "dbilink" that uses the fact that you can run perl inside of postgresql to use DBI to talk to other databases. You can use tables from a mysql database inside of a postgres database...

    1. Re:laugh if you like... by dfetter · · Score: 3, Informative

      Pardon the self-promotion, but you can find DBI-Link at http://pgfoundry.org/projects/dbi-link/ and on EPEL for RHEL/CentOS. Oh, and it's not restricted to MySQL. You can use any DBD with a certain minimal feature set, and I'm trying to reduce that minimum.

      --
      What part of "A well regulated militia" do you not understand?
  7. Help Needed: Error 2013 by ballmerfud · · Score: 5, Funny

    I compiled and installed the plugin and every time I try it, get the following:

    mysql> INSTALL PLUGIN postgres SONAME 'libpostgres_engine.so';
    ... where am I? Oh God no. No. NO!
    kill(getpid(), 9)
    kill(getpid(), 9)
    kill(getpid(), 9)
    kill(getpid(), 9)
    kill(getpid(), 9)
    kill(getpid(), 9)
    kill(getpid(), 9)
    kill(getpid(), 9)
    kill(getpid(), 9)
    kill(getpid(), 9)
    kill(getpid(), 9)

    ERROR 2013: Lost connection to MySQL server during query
    --
    http://uncyclopedia.org/wiki/User:Steve_Ballmer
  8. Re:Seriously though...can someone explain it by Just+Some+Guy · · Score: 4, Insightful

    can someone give a quick summary as to why this is hilarious and people are currently LOL

    Have you ever laughed at a hopped-up Dodge Neon with a whale tail and three rows of headlights? Well, imagine that the owner had found managed to buy a Ferrari, rip its engine out, and install it in the Dodge. It would be an interesting hack, but why not just drive the Ferrari in the first place?

    --
    Dewey, what part of this looks like authorities should be involved?