|
|
Posted by Erwin Moller on 07/27/06 10:54
Geoff Berrow wrote:
> Message-ID: <44c8961b$0$4523$e4fe514c@news.xs4all.nl> from Erwin Moller
> contained the following:
>
>>A simple approach:
>>(Postgresnotation, not mySQL which I avoid)
>
> Last time I checked it mysql was being used for tinyurl.com
>
> http://tinyurl.com/
>
So what?
My choice of database is not based on tinyurl.com using something or not.
;-)
The reason I prefer Postgresql above mySQL has more to do with support of
Foreign Keys (which failed silently in mySQL), transactions, etc.
When I made my pick of prefered database a few years ago, mySQL was no
comparision to Postgres.
Yes I know: Since mySQL offered the use of innoDB in combination with imysql
they solved these serious shortcomings.
Also: I do not say mySQL sucks or anything, it is just that mySQL matured a
short while ago and you'll have to tweak it before you can use FK's and
transactions and the like, but yeah, it can be done with innoDB.
I think the main reason for mySQL's popularity lies in the fact they offered
it on M$ systems, where Postgres was only running on *nix. That too is in
the past by the way: Postgresql is available for years now on M$.
Regards,
Erwin Moller
Navigation:
[Reply to this message]
|