[Buildbot-devel] the aftermath (was Re: SF bay area get-together?)

[Stephen Davis]

On Aug 6, 2008, at 6:55 AM, Axel Hecht wrote:

> Regarding just hand-coding SQL, I know jack, but I saw that sqlite has
> rather rudimentary support for things like dates, and that text is not
> length limited. Both seem rather strong constraints when trying to
> write portable code.

SQLite has some date functions but no inherent "date" type, like  
Oracle and others.  I think the most portable thing you can do is to  
use ISO9601 formatted text strings "yyyy-mm-ddThh:mm:ssZ" (I can't  
remember if there's a fractional second part).  These are ASCII- 
sortable so you can order by them and stuff like that.  Not nearly as  
good as a built-in type but fairly workable.  I would also like to  
think that other databases would accept dates in this format thus  
reducing the portability concern a tad.

I'm curious what other people think of this scheme.  It made sense  
while I was thinking about just now but I've never actually used a  
schema like that. Has anyone had much experience dealing with dates in  
SQLite?

stephen

P.S.  I'm a big fan of SQLite but I live in a C++ world so I have no  
experience with Python bindings to it.