From: Tom Allison (email_suppressed_at_lugwash.org)
Date: Wed 02-Feb-2005 07:09:45 AM EST
Michael Corral wrote:
> 2005-02-01, [e-mail suppressed] a ecrit:
>
>> At work, we are thinking of changing the database system. We have been
>> using
>> mysql on windows platform (I know, I know), but there are some gliches in
>> regards to different versions. I mean, different member has different
>> version
>> of mysql installed, and when trying to transport and access the databases
>> created by others on other machines, every now and then, you cannot
>> access or
>> manipulate the databases. This seems to be true, also in the interfacing
>> programs written on different machines.
>
>
> You may want to check out this page of MySQL 'gotchas'; it's possible your
> problem(s) could be related: http://sql-info.de/mysql/gotchas.html
> My personal favorite is dividing by zero returning NULL instead of an
> error. February 31 being a valid date is another classic. Throw in no
> support for triggers and very limited support for stored procedures, and
> you'll see why many people have a low opinion of MySQL.
>
I'm encouraged.
Just about every packaged software out there comes with the expectation
that you will be using MySQL and nothing else.
I am working on a web project and were discussion the use of
Apache::Sessions. I figured it would be easy enough to just use a
simple perl Cache::FileCache since it's only tracking user logins
(small, temporary, only handles the active user base).
But it seems that people wanted to use Apache::Sessions::MySQL just
because. Kind of pissed me off that they want to use a database just to
track the association of a cookie (md5 hash) and a username/password pair.
Anectdotally it seems that MySQL is easier to install. That's what I've
been told. I found the installation of postgresql to be very easy.
It's been so long since I used MySQL I can't give a comparitive opinion,
but it's easier than postfix.
And if you are into all that triggers and stored procedures stuff, pgsql
has an established history.
-- *** Sent from [e-mail suppressed] *** http://www.lugwash.org to unsubscribe: `echo "unsubscribe" | mail [e-mail suppressed]`
This archive was generated by hypermail 2.1.5 : Tue 01-Mar-2005 01:00:04 AM EST