Michael Lackhoff writes:
> On 5 Dec 2006 at 11:02, Perrin Harkins wrote:
>
> > You can usually do this kind of ++ thing in one INSERT...SELECT statement:
> >
> > INSERT INTO invoice (id) SELECT MAX(id)+1 FROM invoice;
>
> That's clever! Though it seems to slightly defeat the point in using
> RDBO: To have Perl, classes and methods instead of SQL, tables and
> columns. Still, I will definitely try it.
I've been exploring Class::DBI, DBIx::Class, and now Rose::DB::Object,
and I've been wondering if I'm in a minority.
I really appreciate all of the things that I get from the ORM
libraries that let me work with my data as Perl objects.
On the other hand the hoops that they jump through to try to
automagically generate queries and hide the relational database
mystifies me, I find that I end up double checking the sql that they
generate to make sure that I haven't shot myself in the foot somehow.
I think you can get a lot of miles out of these libraries whilst still
using the underlying DB for things that it does well.
But maybe I *am* weird and that's why the answer to my first question
on this mailing list was:
get_objects_from_sql
g.
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
