On Sunday 28 January 2007 5:55 am, Jochem Maas wrote: > > And yes, I agree that MySQL has fairly decent date manipulation routines. > > But at work we do try for database independence when possible, so except > > on specific projects we try to avoid it. > > again we differ :-) I have never bought the 'data independence' story - in > practice it's of little value imho most of the time (granted certain > products do benefit - but what I build doesn't fall into that category) and > I find it crazy to end up with a situation where the most advanced peice of > data manipulation software in a given stack is dumbed down to the lowest > common denominator [of DB engines]. On more complex project I try to cram > as much of the data intregity and business logic in to the database itself > (for which I use firebird mostly) because it means being able to create > different clients to the data without replicating [as much] business logic > (e.g. website and desktop app). besides which the required stored > procedures and triggers are usually hundreds of lines less than their php > equivalent AND more importantly they are intrinsically atomic (in the sense > that database transaction 'should' be). > > rgds :-) Well, business reasons dictate that we keep our code portable when possible at work. I'm not the business person. I just write the code. :-) -- Larry Garfield AIM: LOLG42 larry@xxxxxxxxxxxxxxxx ICQ: 6817012 "If nature has made any one thing less susceptible than all others of exclusive property, it is the action of the thinking power called an idea, which an individual may exclusively possess as long as he keeps it to himself; but the moment it is divulged, it forces itself into the possession of every one, and the receiver cannot dispossess himself of it." -- Thomas Jefferson -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
