Boston Linux & Unix (BLU) Home | Calendar | Mail Lists | List Archives | Desktop SIG | Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings
Linux Cafe | Meeting Notes | Blog | Linux Links | Bling | About BLU

BLU Discuss list archive


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

MySQL RANT



> >  * 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.







BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!



Boston Linux & Unix / webmaster@blu.org