Slashdot Mirror
Comparing MySQL and PostgreSQL 2
Mr. Jax writes "6 years ago Mr Poet submitted the story Comparing MySQL and PostgreSQL. Since then both databases have evolved to wherever they are today.
Are the points raised 6 years ago still valid? What has changed? Are there other things to consider since then (e.g. licensing)?" This is certainly a valid question since both databases have had to evolve with the times. Have these applications been specialized to fit a particular niche market or are they both still strong competitors? What does the horizon look like for the development of these programs, especially considering the recent MySQL partnership with SCO?
I have been wondering, which is better, vi or emacs?
I am TheRaven on Soylent News
You are such a noob :-)
So are you :)
only old comparisons matter...
(had to do it)
how long until
They don't compare very well at all... Oracle doesn' hold a candle to postgres.
"Since then both databases have evolved to wherever they are today." Thank you for that profound insight..
As are you. :-p
How do you think I feel?
Xenu loves you!
Where-as you're a long-timer? ;-)
Would a Kroger executive talk enthusiastically about your new "partnership" with them
But it would make a great story in the Onion...
"Kroger DEO David Dillon said that he was 'very pleased to have the opportunity to supply toothpaste and other oral hygiene products to Quarters, who is widely known for is impeccable white teeth and fresh breath.'"
...does this count as a dupe? Or is there a statute of limitations thing going on here?
~~~~~ BigLig2? You mean there's another one of me?
Comparing MySQL and PostgreSQL 2
Is that the only way that MySQL can look favorable? By comparing to version 2 of Postgres?
fnord
God Fucking Damnit
You're right that InnoDB has supported row-level locking for some time now. PostgreSQL uses MVCC so that you don't need a lock at all most of the time.
Considering how often Slashdot goes down when they have a cluster of MySQL boxes for redundancy, that's hardly an endorsement of quality.
- I don't need to go outside, my CRT tan'll do me just fine.
Sorry billysara, I must have beat you by a few minutes. :)
Hey, I heard SCO buys their office supplies from Staples, OfficeMax, and Office Depot. Quick, boycott Staples, OfficeMax, and Office Depot!
This is important though. MySQL can only redeem itself now by issuing another press release which says that partnering with SCO "made them feel dirty."
So this is what passes for "Score 5: Informative" now?
Invent an imaginary version of postgres to compare to a real version of MySQL, then spout some fictional cons. In that case:
I'm using both, but mainly Postgres. From what I can tell:
Postgres 7.841
Pros:
- Supports african dialects such as Kaliharinese
- Adds extra features when it detects that the user is a Womble
- Compatible with IP/feline
Cons:
- Runs slowly if you try to quieten your hard drives with banana peels
MySQL 4.841
Pros:
- Written entirely by Ooompa Loompas
- Discourages the use of Perl
Cons:
- Supports animal testing. Drips of MySQL are places in the eyes of penguins to check for irritation.
- Shows signs of money contamination, which brings hippies out in a rash
- Does not support transactions.
Nor do the sell mobility. What's your point?
It's not offtopic, dumbass. It's orthogonal.