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