[Catalyst] ActiveRecord for Perl

[Christopher H. Laco]

mla wrote:
> Christopher H. Laco wrote:
>> 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.
> =

> Thanks for sharing your experiences. Other than the the deploy() stuff,
> any other criticisms of RDBO? Now that I'm looking at it again, I'm
> liking the design very much.
> =

> I found this thread that compared some of the differences (might be
> outdated now):
> =

>   http://www.gossamer-threads.com/lists/catalyst/users/3095
> =

> What would cause you to *not* use RDBO on a new project?
> =

> Maurice

Just for giggles, you can compare the two sets of glue:

http://search.cpan.org/src/CLACO/Handel-Storage-RDBO-0.01_02/lib/Handel/Sto=
rage/RDBO.pm
http://search.cpan.org/src/CLACO/Handel-0.99_18/lib/Handel/Storage/DBIC.pm

Same API...different ORMS.


-------------- 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/1678=
7c37/signature.pgp