Postgres Engine for MySQL Released

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

Comments

13 Meg GZ file no less

[fruey]

If you're going to get Slashdotted, posting a link to a 13MB file is a bit risky, no?

Anyone manage to dl it? I gave up a few minutes ago.

laugh if you like...

[doom]

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

dept.?

[The Madd Rapper]

Is it notable that this story doesn't have a "from the ... dept." line? How common is that?

Re:should speed up Postgresql

[metamatic]

Actually, it's a useful idea. MySQL is only faster than PostgreSQL for "toy" databases (low concurrency, few transactions needed per second), or if you throw away ACID capabilities.

However, a lot of open source projects use non-portable MySQL "SQL", and hence don't work if you try to use PostgreSQL as your back end. A hack like this that actually worked would let you run crappy open source code on a more scalable database back end.