Re: How to approach converting to CDBI?

[prev] [thread] [next] [Date index for 2005/07/04]

From: Matt S Trout
Subject: Re: How to approach converting to CDBI?
Date: 17:27 on 04 Jul 2005

On Mon, Jul 04, 2005 at 11:45:16AM -0400, Brett Sanger wrote:
> For example, we have a db of office memos.  One commonly accessed
> function is to look at the most recent memos.  This is a simple WHERE
> clause with a LIMIT command.  (Postgres).
> 
> In CDBI view, i'm tackling this with add_constructor because of the
> LIMIT...does that make sense?

Not at all. Use Class::DBI::Sweet as your base class instead of Class::DBI
and you can do

My::Table->search( { foo => $bar }, { rows => 10 } );

to retrieve the first ten rows. Postgres is supported, as are MySQL,
SQLite, and many others.

        -- 
             Matt S Trout           Website: http://www.shadowcatsystems.co.uk
  Technical Director        E-mail:  mst (at) shadowcatsystems.co.uk
Shadowcat Systems Ltd.

How to approach converting to CDBI?
Brett Sanger 15:45 on 04 Jul 2005

Re: How to approach converting to CDBI?
Michael Peters 16:07 on 04 Jul 2005

Re: How to approach converting to CDBI?
Mike Whitaker 16:09 on 04 Jul 2005

Re: How to approach converting to CDBI?
Michael Peters 16:18 on 04 Jul 2005

Re: How to approach converting to CDBI?
Mike Whitaker 16:21 on 04 Jul 2005

Re: How to approach converting to CDBI?
Brett Sanger 16:28 on 04 Jul 2005

Re: How to approach converting to CDBI?
Brett Sanger 16:20 on 04 Jul 2005

Re: How to approach converting to CDBI?
Brett Sanger 17:56 on 04 Jul 2005

Re: How to approach converting to CDBI?
Matt S Trout 17:27 on 04 Jul 2005

Re: How to approach converting to CDBI?
Brett Sanger 17:36 on 04 Jul 2005

Re: How to approach converting to CDBI?
Jonathan Tweed 18:09 on 04 Jul 2005

Re: How to approach converting to CDBI?
Matt S Trout 18:40 on 04 Jul 2005

Re: How to approach converting to CDBI?
Tony Bowden 20:39 on 04 Jul 2005

Re: How to approach converting to CDBI?
Michael Peters 20:48 on 04 Jul 2005

Re: How to approach converting to CDBI?
Matt S Trout 21:49 on 04 Jul 2005