[Dbix-class] InflateColumn::DateTime

Matt S Trout dbix-class at trout.me.uk
Thu Jun 8 13:52:47 CEST 2006


brian.cassidy at nald.ca wrote:
> Hey Matt,
> 
>> No it isn't, because it stops you being able to do date math on your DB.
>>
>> One of the intentions of this feature is that once it's fully supported 
>> across all the databases we handle it'll make Epoch unnecessary. If the 
>> ::Epoch author's about on this list, shout because I'd appreciate your 
>> input here.
> 
> *shouts*
> 
> My co-worker (Adam) and I wrote that component.  Basically, we agree that auto-inflation of actual date/datetime fields would be a better option. Though, there is likely a place for the component to exist for "legacy" schemas using epoch timestamps.

Both options should definitely be available, though using "real" 
datetimes is I think going to be what you want in most cases. Plus of 
course InflateColumn::DateTime doesn't yet have anything equivalent to 
your ctime/mtime code - wonder if that can be separated out somehow? 
(I've been doing some thinking about audit logging in general recently 
since I suspect I'm going to have to built a component for it for a 
client of ours).



More information about the Dbix-class mailing list