Perrin Harkins (p...@elem.com)

On 9/23/07, Matt S Trout <dbix-class@trout.me.uk> wrote:
> You've never implemented a saved search function that allows you to
> 'search within' a saved search?

That's usually not a difficult problem, since you already have a way
to turn criteria from a web form into a search, and you're just adding
one more criterion to the pile.

> You've never done a "view all posts owned by the selected set of users" link?
>
> This sort of thing in DBIC just becomes
>
> $posts_rs = $users_rs->search_related('posts');
>
> whereas (so far as I'm aware, please do correct me if I'm wrong) it's a bit
> more work in RDBO.

I'm not an expert on RDBO, but I believe you would need to call a
different class (the posts class, not the users) and adjust the
criteria you pass, e.g. change "last_name => 'Smith'" to
"user.last_name => 'Smith'".

Any set of ORM tools is going to have different unique features, and a
full abstraction would mean giving up all of the unique features.
However, it looked like Peter was trying to do something at a pretty
high level where hopefully the differences don't come into play much.

- Perrin

On 9/23/07, Matt S Trout <dbix-class@trout.me.uk> wrote:
> Do you have any thoughts on how to paper over DBIC's ability to chain searches
> vs. the lack of that feature in RDBO?

Isn't it primarily a way to build up your search criteria with
multiple small method calls instead of one big one?  It doesn't seem
very relevant to a CRUD app where all the criteria come in at once
from a web form.

- Perrin

On 9/3/07, Robert Carew <Robert.Carew@maf.govt.nz> wrote:
> Has anyone used Catalyst with an Informix database and if so which ORM are
> you using and what advice can you offer?
> Any pointers in either getting DBIC to work with Informix or RDBO with
> Catalyst would be gratefully received.

If you search the Catalyst archives, you'll find some posts on both
Informix and RDBO:
http://www.mail-archive.com/catalyst@lists.rawmode.org/

- Perrin

On 8/23/07, Ash Berlin <ash_cpan@firemirror.com> wrote:
> Don't use a DB as the backing store for a message queue if you will ever
> need to pass a lot of messages thought it - you're just asking for
> trouble doing it that way.

Like most things, it depends.  If you need ACID properties for your
messages, using a database will be a lot easier than building your own
special-purpose ACID database.  And you probably already have some
work invested in making your RDBMS scale, so it doesn't add a new
point of failure.

But sure, if you have the money for commercial IBM stuff, it works.
Some of the open source Java solutions may be viable too.

- Perrin

On 8/23/07, tprinty <tprinty@mail.edisonave.net> wrote:
> Have you looked at memcache?

Don't put your messages into memcached unless you don't mind losing
some.  It is not a database or reliable storage.  It's just a cache.

- Perrin