[Catalyst] ActiveRecord for Perl

[Christopher H. Laco]

mla wrote:
> Perrin Harkins wrote:
>> On 5/22/07, Adam Bartosik <adam.bartosik at hurra.com> wrote:
>>> What I found missing in DBIx::Class is AR method find_by_sql(sql).
>>
>> Did you ask about it on the mailing list?  Nearly all of the Perl ORMs
>> have support for direct SQL.  I don't know DBIx::Class, but
>> "search_literal" sounds like what you want.
>>
>> I doubt there's anything worth porting in ActiveRecord that one of the
>> many Perl options (DBIx::Class, Rose::DB::Object, Class::DBI, Tangram,
>> Alzabo) doesn't provide.
> =

> If I may ask, Perrin, what do you use?
> =

> Maurice

I'm one of those odd birds that's used CDBI, DBIC and RDBO.
I've converted from CDBI to DBIC and also written an RDBO layer for a
project.

/CDBI smart ass comments deleted/ :-)

They all have their quirks. DBIC does a great job of getting out of your
way. If there's an option, chances are you can set it at the class
and/or object instance level, allowing fair amounts of evil to be
accomplished. :-)

RDBO tickles my fancy if I'm really into triggers at the various stages
of data usage. What I really really missed from DBIC when writing RDBO
was deploy(). The ability to just kick out a db schema into a DB from a
DBIC schema totally rocks.

-=3DChris

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 187 bytes
Desc: OpenPGP digital signature
Url : http://lists.scsys.co.uk/pipermail/catalyst/attachments/20070522/4b0f=
a2c6/signature.pgp