MySQL RANT

[doctormo-Re5JQEeQqe8AvxtiuMwx3w at public.gmane.org (Martin Owens)]

> >  * Lack of Date/Time arithmetic caused me to have to implement it in
> > perl (annoyed)
>
> Out of curiosity, what's missing from this list:
> http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html
>
> In other database backends I've dealt with, I can't recall seeing many
> more than this.

Just to fill in here, it isn't that the functionality is missing is
that it's not standard. they have ADDDATE() method instead of DATE +
INTERVAL = DATE arithmetic, DATEDIFF() instead of DATE - DATE =
INTERVAL etc etc. so my perl has to grab all DATE arithmetic and
convert them to mysqlian date methods when it compiles the SQL; so
they can be compatible with postgress and mysql on the object level.

> Just trying to learn more. There's a lot of partisan and/or
> out-of-date information out there, and it isn't always easy to
> separate the wheat from the chaff...

Hell I'd love for them to fix this chaff and whey but you know what
APIs are like. I just wanted to lend a little bit of credibility to
the OPs rant even if I thought it was a bit strong because I know of
far too many web services that supply mysql but not postgress
databases so I had to code for mysql too.

Regards, Martin

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.