Slashdot Mirror
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."
Will it blend?
Unto the upright there arises light in the darkness...
One of the problems with Postgresql versus MySQL is that it is typically much, much slower and less capable. THis should address those problems.
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.
Conversion Rate Optimisation French / English consultant
There are 4 links to corporations home pages. There's 1 link to someone's blog that contains a broken link to a non-existent plug-in. Not only that, I think this would make a much bigger stink if it were real. So, my thoughts: APRIL FOOLS!
5.1 is old. Wake me up when they've got a true 7.1 setup available.
till they release a DBase III engine...
I'm scared of numbers that can't be written as a fraction. It's an irrational fear.
This would have been a better joke if it was Microsoft adding a SQL Server engine.
They're just rival DBMSes, that's all. It's not actually particularly funny.
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.
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.
If I have nothing to hide, you have no reason to search me
That's the original combined Perl/Python scripting language, BTW, not the Perl 6 virtual machine that ripped off the name.
In a survey of 100 programmers, 111111 thought that duck-typing was a good idea.
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...
Also the fact that Brian has a blackhole engine running next to the pgsql.
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.
The blackhole engine is real..
I compiled and installed the plugin and every time I try it, get the following:
http://uncyclopedia.org/wiki/User:Steve_Ballmer
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?
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.
Effort? You seriously think the /. editors are putting any effort into this? Do you think they EVER put effort into /.?
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 that stores the data in a memcached server...
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...
We're all born with nothing.
If you die in debt, you're ahead.
Is it notable that this story doesn't have a "from the ... dept." line? How common is that?
That's the shit that feds me up
The only thing worse would be a linux plugin for windows.
t ml
Windows Services for UNIX
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.h
are we going to have to start using VACUUM on MySQL now?
Custom electronics and digital signage for your business: www.evcircuits.com
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 probably not the best way to judge a person's verbal skills anyway, although the writing around here does stink sometimes.
On the other hand, I agree with you that America's school system is failing miserably when it comes to linguistic skills. I had a girlfriend who was a college-level English instructor (this was back in the mid-eighties.) A significant fraction of the incoming college freshmen she taught were unable to write in full sentences, and required remedial instruction in order to have a hope of functioning in a college environment. My understanding is that the situation has not improved, and is in fact worse. How our high schools manage to graduate functional illiterates is beyond me. No question the system is in deep trouble.
The higher the technology, the sharper that two-edged sword.
"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 me) - you're bad.
Chimpanzees have better manners.
Richard Steven Hack - This sig is TOO GODDAMN SHORT TO DO ANYTHING USEFUL WITH! MORONS!
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...)
Richard Steven Hack - This sig is TOO GODDAMN SHORT TO DO ANYTHING USEFUL WITH! MORONS!
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" and "Ferrari".
Dewey, what part of this looks like authorities should be involved?
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...
If I have seen further it is by stealing the Intellectual Property of giants.
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.
nice! someone mod that up.
The link to the plugin is working now, check it out.
I'm downloading it now, it's 7mb but only going 10kb/s so I'm not sure what it'll be.
Have you metaroderated recently?
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 at the semantic level. If you add a GIN index, a GiST index, a functional index, etc., then that will not change the behavior of queries; only the performance. Even though it all uses the same "heap" to store the raw tuples, you can even modify that by changing the "fillfactor", etc.
(3) PostgreSQL's optimizer is much more sophisticated than that of MySQL. If (when) MySQL's optimizer chooses a bad plan, it won't matter that PostgreSQL is the storage engine; it will still be slow.
Social scientists are inspired by theories; scientists are humbled by facts.