[Dbix-class] Calling all database champions

[John Napiorkowski]

--- Matt S Trout <dbix-class at trout.me.uk> wrote:

> On Sat, May 26, 2007 at 08:30:29AM -0400, Jason
> Kohles wrote:
> > On May 23, 2007, at 8:04 PM, Tom Lanyon wrote:
> > 
> > >
> > >Jason,
> > >
> > >Just curious, what column type are you using that
> includes  
> > >'timestamp' as well as other chars?
> > >
> > PostgreSQL has more than one timestamp type, which
> may show up in the  
> > column_info as:
> > 
> > timestamp with time zone
> > timestamp without time zone
> > timestamp
> > timestamptz
> 
> And none of those need special handling?
> 
> Peopl who champion a specific DB engine, how would
> this work for you?
> 
> I'm getting increasingly tempted to just sod it and
> apply jason's patch
> when he sends out a test case or two for it and
> we'll see what happens.

They do need tweaks to the timedate
inflation/deflation but I usually do it by hand and
not rely on the standard timedate inflators.

I thought about offering a patch for this but to be
honest it seems like it would get messy to have each
inflator/deflator have to deal with each and every
database issue.  seems like something that should go
into storage.

I don't know who the Postgresql champion is, but if
you don't have one I'll volunteer.

My 2 cents is I don't object to the patch mentioned
since most of the time it does what you want, unless
you are doing fancy stuff with multiple timezones in
the database.  I typically normalize to GMT and then
set a TZ offset as a table attribute for when I need
to manage users or stuff in different timezones.

--john

> 
> -- 
>       Matt S Trout       Need help with your
> Catalyst or DBIx::Class project?
>    Technical Director    Want a managed development
> or deployment platform?
>  Shadowcat Systems Ltd.  Contact mst (at)
> shadowcatsystems.co.uk for a quote
> http://chainsawblues.vox.com/            
> http://www.shadowcatsystems.co.uk/ 
> 
> _______________________________________________
> List:
>
http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
> Wiki: http://dbix-class.shadowcatsystems.co.uk/
> IRC: irc.perl.org#dbix-class
> SVN:
>
http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
> Searchable Archive:
>
http://www.mail-archive.com/dbix-class@lists.rawmode.org/
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com