Re: [RDBO] Rose::DB::Object::QueryBuilder set operations

2006-06-06 Thread John Siracusa
On 6/7/06 12:08 AM, John Siracusa wrote: >> I do intend to work with subqueries and am thinking about how to incorporate >> them or else cheat with some post-processing. > > You may have to cheat for now since QueryBuilder has no support for > subqueries (other than as liter SQL clauses) Er, make

Re: [RDBO] Rose::DB::Object::QueryBuilder set operations

2006-06-06 Thread John Siracusa
On 6/6/06 10:49 PM, Perrin Harkins wrote: > According to the docs, 'COLUMN' => { in_set => 'A' } generates the SQL > "A IN COLUMN". This seems like the reverse of normal usage, e.g. "name > IN ('john','paul')". Can anyone explain what this might be used for? It's used for the SET column type sup

Re: [RDBO] DBIx::Class or Rose::DB::Object or other???

2006-06-06 Thread Kurt Hansen
John Siracusa wrote: >On 6/6/06, Kurt Hansen <[EMAIL PROTECTED]> wrote: > > >>Any other key things I should note? Also, will the speed advantage of >>RDBO be maintained, or are both such young modules that it's hard to say >>where the speed advantage will end up? >> >> > >The speed advantage

[RDBO] Rose::DB::Object::QueryBuilder set operations

2006-06-06 Thread Perrin Harkins
Hi, I'm looking at using Rose::DB::Object::QueryBuilder on its own (without the rest of RDBO) to generate some SQL. It looks like this should work fine. However, I'm finding the in_set and in_array methods very confusing. According to the docs, 'COLUMN' => { in_set => 'A' } generates the SQL

Re: [RDBO] DBIx::Class or Rose::DB::Object or other???

2006-06-06 Thread John Siracusa
On 6/6/06, Kurt Hansen <[EMAIL PROTECTED]> wrote: > I'm trying to understand what the differences are and which > are relevant for my environment. So far, this is what I've picked up > (yes a bit slim): > > 1. RDBO is faster. > 2. DBIC has a Class::DBI compatibility layer that will make the > tran

[RDBO] DBIx::Class or Rose::DB::Object or other???

2006-06-06 Thread Kurt Hansen
Hello, Last summer, I started developing new applications using Class::DBI rather than my own home grown DBI modules. A few weeks ago, I saw a reference on the mod_perl list to the benchmark page: http://rose.sourceforge.net/wiki/index.php/RDBO/Benchmark Rather than sticking with Class::DBI, I

Re: [RDBO] Rose::DB::Object subclass instances within Safe compartment

2006-06-06 Thread Ethan Rowe
John Siracusa wrote: > If related objects are fetched by the Manager due to require_objects > or with_objects parameters, they should be attached as full-fledged > objects. Can you can show me an instance (sample code) where this is > not the case? That's good to know; I was making something of

[RDBO] Rose::DB::Object subclass instances within Safe compartment

2006-06-06 Thread Ethan Rowe
Hi. Has anybody out there ever tried passing Rose::DB::Object subclass instances into a Safe compartment? This is almost certainly an issue specific to Safe and not specific to the Rose:: family in general, though I think the Rose::DB::Object internals are "late-binding" with sufficient frequ