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."
till they release a DBase III engine...
This would have been a better joke if it was Microsoft adding a SQL Server engine.
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.
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?
PostgreSQL is LESS capable than MySQL? (Slower at some things, maybe, but LESS CAPABLE?)
Leave the crack pipe at home next time.
Richard Steven Hack - This sig is TOO GODDAMN SHORT TO DO ANYTHING USEFUL WITH! MORONS!
"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!
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 scans (which can be ANDed/ORed with other indexes and reorder the tuple fetching in disk order), GIN and GiST indexes, Hash Aggregates, Hash Joins, etc.
However, if PostgreSQL were just a "storage engine" I don't MySQL's storage API would pass enough information about the high-level query down to the PostgreSQL storage engine. That means PostgreSQL couldn't make good choices for plans.
A "storage engine" with a simple API for storing/fetching records is fairly uninteresting from a database performance standpoint.
Granted, PostgreSQL's MVCC is likely to be a win under concurrent access in some situations. But the wide range of performance that PostgreSQL delivers without modification of application queries (or administrator intervention) is where it really shines.
Social scientists are inspired by theories; scientists are humbled by facts.