Comparing MySQL and PostgreSQL 2 902
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?
Also (Score:5, Funny)
Re:The most interesting part of the old article... (Score:2, Funny)
Re:The most interesting part of the old article... (Score:3, Funny)
In South Korea... (Score:0, Funny)
(had to do it)
Re:Another question (Score:3, Funny)
Re:Also (Score:5, Funny)
good one (Score:3, Funny)
Re:The most interesting part of the old article... (Score:3, Funny)
As are you. :-p
Re:The most interesting part of the old article... (Score:3, Funny)
Re:The most interesting part of the old article... (Score:3, Funny)
Re:But would Kroger co-release it? (Score:3, Funny)
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.'"
Sorry... (Score:4, Funny)
who to what? (Score:2, Funny)
Is that the only way that MySQL can look favorable? By comparing to version 2 of Postgres?
fnord
Re:PostgreSQL is supreme A LOT (Score:4, Funny)
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.
Re:The most interesting part of the old article... (Score:3, Funny)
Re:Get off it ScuttleMonkey (Score:1, Funny)
Re:Not exactly ... (Score:3, Funny)
Re:My point of view (Score:5, Funny)
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.
Re:Get off it ScuttleMonkey (Score:3, Funny)