I don't know fully what's happening yet (not sure if this is relevant), currently latest svn copy broke a custom function (at a test location) to display posts 1, 2 and 3 years ago (using time() of server) so I'm not upping the real site yet until dust is settled.
On Wed, Sep 17, 2008 at 2:50 PM, Andy C <[EMAIL PROTECTED]> wrote: > > I am not a Habari or PHP developer. Surprisingly, I don't stay up all > night monitoring svn commits. Indeed I am not qualified to do so. > > I just thought the design merited some discussion and I am glad I > aired the topic. > > For the record, I would have favoured a UTC timestamp with a wrapper > function to adjust for the local timezone. > > Unsigned integers work. The functionality works (and more). It doesn't > matter to the end user or most developers. It ain't worth reverting. > > There are some arguments for unsigned integers and it is clear a vote > would have confirmed the current decision. > > This snippet from the wonderful (and now broken) monthly archives > plugin illustrates the point beautifully > > $q= 'SELECT YEAR( p.pubdate ) AS year, MONTH( p.pubdate ) AS month, > COUNT( p.id ) AS cnt > FROM ' . DB::table( 'posts' ) . ' p > WHERE p.content_type = ? AND p.status = ? > GROUP BY year, month > ORDER BY p.pubdate DESC ' . $limit > > Self-documenting, captures all the semantics in five lines, portable > to all database platforms. > > Now, obviously, this can be fixed by coding the equivalent in PHP - > it's only 1's and 0's after all but I doubt the solution would be as > concise and elegant. > > Oh and please don't tell me integers are better for performance. I > work for Oracle. Databases are here to stay :-) > > Habari - the next generation blogging platform (at least until 2038) > > > -- See me at http://am.notsowise.net --~--~---------~--~----~------------~-------~--~----~ To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/habari-dev -~----------~----~----~----~------~----~------~--~---
