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

Re:

[account_deleted]

Comment removed based on user account deletion

Re:

[Agret]

The link to the plugin is working now, check it out [tangent.org].
I'm downloading it now, it's 7mb but only going 10kb/s so I'm not sure what it'll be.

Re:

[kirun]

A clue for you:

mysql> select * from april;
Empty set (0.00 sec)

Re:

[Splab]

Also the fact that Brian has a blackhole engine running next to the pgsql.

Re:

[Anonymous Coward]

The blackhole engine is real..

BUT...

[dark_15]

Will it blend?

Re:

[Renfield Spiffioso]

This is database smoke; don't breathe this.

should speed up Postgresql

[Anonymous Coward]

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

Re:

[metamatic]

Actually, it's a useful idea. MySQL is only faster than PostgreSQL for "toy" databases [tweakers.net] (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.

Re:

[jadavis]

A hack like this that actually worked would let you run crappy open source code on a more scalable database back end.

A lot of PostgreSQL's performance comes from it's cost-based optimizer that chooses the correct plan based on statistically sampling your real data periodically. In other words, as your data changes, your plans change accordingly without administrator intervention. MySQL's optimizer is much more primitive.

Also, PostgreSQL has much more sophisticated options when planning, like bitmap index sc

Re:

[Master of Transhuman]

PostgreSQL is LESS capable than MySQL? (Slower at some things, maybe, but LESS CAPABLE?)

Leave the crack pipe at home next time.

Re:

[clambake]

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

Yes yes, this is true, PostgreSQL *IS* so much faster than MySQL, that's well understood... But that's just a small drop in the ocean compared to the much LARGER problem about comparing the two which is that PostgreSQL is a relational database while MySQL is a fancy way to access flat files.

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.

Re:

[BinarySkies]

Forget putting your own rear end on the line with deploying botnets to DDoS public sites, simply post a link to a large downloadable on a slashdot article and you get a very similar, yet much more legal effect :D

Re:

[tronicum]

I downloaded about ~ 300 kb (very slow) and did a zcat on the tar. So far it looks like automake stuff, so it looks like source code.

13 MB is quite a lot if you compare it to 22 MB for the source of MySQL itself. I also wondered that he took "create table april "... as example. That points toward a prank...

Re:

[krow]

Turns out I had not done a "make clean" in the PG directory, so it was a lot larger then what it needed to be. I've updated the tgz with a smaller file.

Re:

[Anonymous Coward]

They're just rival DBMSes, that's all. It's not actually particularly funny.

Re:

[Anonymous Coward]

The joke (which, like most jokes sounds lame when you explain it) is that MySQL has so many storage backends, why not use another database as a storage backend? Compatibility is not the issue, but rather the odd notion of designing a database system just to store data in some other database system. It would be similar to writing an entire file system that stored all the data in a specially formatted MS Word document.

Re:

[Wdomburg]

If that's an odd notion, then MySQL is odd already. Solid and Berkley existed as databases long before they become options for MySQL table backends. There would be some value to having a MySQL interface to the arguably more capable (for certain tasks) Postgres storage engine.

Re:

[vidarh]

MySQL can already use another database as a storage backend through federation. The "benefit" a PostgreSQL storage engine would be that you could pick and choose whether PostgreSQL or InnoDB, MyISAM and all other other backends fits the requirements of your app the best without changing your database environment.

It may have been an April Fools joke this time, but I wouldn't be the slightest bit surprised if someone actually went ahead and implemented this. There are far weirder MySQL backends, such as one

Re:

[jadavis]

The "benefit" a PostgreSQL storage engine would be that you could pick and choose whether PostgreSQL or InnoDB, MyISAM and all other other backends fits the requirements of your app the best without changing your database environment.

(1) MySQL's "storage engines" cause different behavior at the semantic level. If you change storage engines, there's a good chance your queries will behave differently. What used to work may now fail.

(2) PostgreSQL has sophisticated performance options which *are* transparent a

Re:can someone explain it

[symbolset]

This evolution would bring together the legendary speed of postgresql with the phenomenal consistency and standards compliance of MySQL.

Which is to say, it's completely backward -- a fusion of the worst of each.

Re:Seriously though...can someone explain it

[Just Some Guy]

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?

Re:

[shaitand]

Fair enough, why would you put a crappy dodge Postgres backend on a Ferrari like MySQL?

Re:

[Just Some Guy]

Fair enough, why would you put a crappy dodge Postgres backend on a Ferrari like MySQL?

Well, that's not what I'd meant, but I suppose that still works for certain values of "Dodge [dodge.com]" and "Ferrari [tinypic.com]".

Re:

[brer_rabbit]

nice! someone mod that up.

Colt

[Joseph_Daniel_Zukige]

Friend used to soup up the Dodge Colt, bore the engine and stuff, for a fast quarter-miler.

The engine was a Mitsubishi at the time.

Some guys would pull the engine and mount it on a funny car chassis, IIRC.

And I always wanted to put an airfoil on the back of my Colt station wagon. And an air ram on the front.

Re:

[Iron Condor]

It's kinda like someone making an add-on to firefox to allow it to use IE as a render engine in a given tab.

Oh, wait...

Re:

[turing_m]

It's more like a vim (or even emacs) plugin for notepad.exe. Or a lifetime ticket to a well equipped free weight gym included in the price of a bowflex. Or Michael Bay directing a movie where the protagonist goes to a cinema and watches the Godfather in its entirety. Or GWB outsourcing his presidential duties to a random guy on the street. Or MacDonalds grinding up filet mignon to make patties. Or...

Re:The Lamest April Fools Story Yet

[VJ42]

It's like "OMG Postgres!!!!"

Perfect tag! :P

Eh

[Spazntwich]

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

Can't hold my breath...

[Epaminondas Pantulis]

till they release a DBase III engine...

Re:

[xarak]

When I were young, we 'ad a DL/I and a beating a day we considered ourselves LUCKY.

SQL Server Engine?

[Zebra1024]

This would have been a better joke if it was Microsoft adding a SQL Server engine.

Re:

[Master of Transhuman]

One word: FoxPro.

MySQL teh suck?

[Urusai]

I thought with MySQL going all corporate and proprietary-like, the bandwagon was jumping ship. MySQL always sucked anyway, unless you were operating a flat file type database. In conclusion, quit swinging on MySQL's nuts. Thank you.

Re:

[isorox]

The only ways mysql gets into corporate machine are
1) Grass roots simply installing it
2) Snr Mgmt being dazzled by golf and wine weekends

I can get my techliterate boss to point to a costly Mysql enterprise support package in those high up meetings where nothing really gets decided, but decisions float down from, and we are fine to dump Oracle for the latest 2000 queries/day intranet site.

In reality the support will be mostly Usenet, but it keeps the suits happy knowing that it must be good because it has a

Re:

[SirTalon42]

Effort? You seriously think the /. editors are putting any effort into this? Do you think they EVER put effort into /.?

As long as it supports Parrot

[itsdapead]

This sounds like the ideal database backend for Parrot [slashdot.org].

That's the original combined Perl/Python scripting language, BTW, not the Perl 6 virtual machine that ripped off the name.

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

Re:

[dfetter]

Pardon the self-promotion, but you can find DBI-Link at http://pgfoundry.org/projects/dbi-link/ [pgfoundry.org] 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.

Re:

[conchur]

Surely reducing the minimal feature-set isn't a step forward?

Re:

[dfetter]

> Surely reducing the minimal feature-set isn't a step forward?

DBI-Link adds on the ability to access external data sources for read and write. It doesn't reduce any of PostgreSQL's capabilities :)

Re:

[Master of Transhuman]

Badly worded, of course, but what he meant was that the number of features the TARGET database needed to be usable with DBI-Link was being reduced.

In other words, he's trying to get DBI-Link to work with MORE databases in the future.

Oh, wait, were you being funny?

Never mind.

Re:

[ScrewMaster]

Why would you say that Americans despise immigrants? I mean, of all nations America is the one that has traditionally been a haven for immigrants from all cultures. We don't like the illegal ones, to be sure, but that has little to do with their English (given that the bulk of them can't speak it at all anyway and show little interest in learning.) It has more to do with the fact that their presence here is disruptive and causing major socioeconomic problems. In any event, hastily-written Slashdot posts are

Re:

[Master of Transhuman]

"of all nations America is the one that has traditionally been a haven for immigrants from all cultures"

The operative word here is "traditionally".

Once the immigrants got here, they immediately began discriminating against NEWER immigrants. Look at the histories of the Irish, the Italians, the Poles, the Russians, the Chinese, the Vietnamese, the Middle Easterners, the you-name-it.

That hasn't stopped.

It's human nature - if you're not one of "us" - for no matter how small a set of "us" (down to order 1 for m

MySQL vs Postgres

[Redbaran]

Thank goodness this was just a joke! For a second I thought we wouldn't be able to have flame wars over which one was better!

The only thing worse would be a linux plugin for windows.

Re:

[SirTalon42]

Actually I think CoLinux (http://www.colinux.org/ [colinux.org]) would be closer...

Re:

[Lennie]

You mean coLinux [colinux.org] ?

Microsoft's ahead of you...

[argent]

The only thing worse would be a linux plugin for windows.

Windows Services for UNIX [microsoft.com]

Microsoft has been using this internally as a "killer app" for converting UNIX sites to Windows by not converting them to Windows for years:

http://www.securityoffice.net/mssecrets/hotmail.ht ml [slashdot.org]

Help Needed: Error 2013

[ballmerfud]

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

dept.?

[The Madd Rapper]

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

Re:

[Agret]

In Soviet Russia department writes you.

Yeah but...

[guruevi]

are we going to have to start using VACUUM on MySQL now?

Re:

[turing_m]

I suspect that it would be automatically configured to use autovacuum.

Re:

[suggsjc]

Probably, but luckily Dyson is working on a Roomba killer. At least this way will have some competition in the automated database garbage collection tools.

Anybody see the "Ballmer joins Linux Foundation"

[Master of Transhuman]

story? That was much funnier than this one.

The only funnier one would be "Richard Stallman hired as Microsoft open source evangelist."

(Now I wait for the FSF fanatics to tell me the difference between "open source" and "free" software - because they can't take a joke either...)