Linked by snydeq on Thu 21st May 2009 22:55 UTC
Databases Fatal Exception's Neil McAllister questions the effect recent developments in the MySQL community will have on MySQL's future in the wake of Oracle's acquisition of Sun. Even before Oracle announced its buyout, there were signs of strain within the MySQL community, with key MySQL employees exiting and forks of the MySQL codebase arising, including Widenius' MariaDB.
Thread beginning with comment 364894
To view parent comment, click here.
To read all comments associated with this story, please click here.
RE: not an expert
by braddock on Fri 22nd May 2009 03:01 UTC in reply to "not an expert"
braddock
Member since:
2005-07-08

I am not an expert but there must be reasons why people chose MySQL over Postgres.


Around 1998 I moved my development from Postgres to MySQL because I found it did what I needed, was simpler, and less complicated.

Around 2007 I moved my development from MySQL to Sqlite because I found it did what I needed, was simpler, and less complicated.

(Postgres wasn't designed for SQL and had all kinds of bizzare notions - my understanding is it has been redesigned since losing the war)

Remember sleepycat - bought for dinner...

Reply Parent Score: 1

RE[2]: not an expert
by werpu on Fri 22nd May 2009 16:52 in reply to "RE: not an expert"
werpu Member since:
2006-01-18


(Postgres wasn't designed for SQL and had all kinds of bizzare notions - my understanding is it has been redesigned since losing the war)

Remember sleepycat - bought for dinner...


Well Postgres is a redevelopment of ingres the grandfather of all relational databases we know today.
It was started by the ingres father!
I would not say it was not designed for SQL since it was the first db providing an ANSI SQL 97 compliant implementation but I assume parts of its codebase are way older than SQL, if those still exist.
But Postgres has more things going on, it up until now still is the only oss database which can do table inheritance, it recently got recursive joins, I have yet to have a deep inside look at the db, but there is a load of enterprise features hidden under the roof which are worthwhile checking out!

Reply Parent Score: 1