Re: [RDBO] Rose::DB::Object::Column::Serialize?

2007-06-19 Thread Svilen Ivanov
Michael, Check this thread: http://www.mail-archive.com/rose-db-object@lists.sourceforge.net/msg00260.html I hope that helps 2007/6/20, Michael Reece <[EMAIL PROTECTED]>: > > i am looking to freeze/thaw (or yaml, doesn't really matter..) > unblessed data structures into a mysql column. > > has a

[RDBO] Separate Read and Write Database Connections

2007-06-19 Thread David Lloyd
Is it possible to have separate read and write database connections in Rose::DB::Object? For example, I might have read to: read.db.com ...and...write to: write.db.com ...is it possible to get any updates/deletes and inserts (and other things that change the DB) to write.db.com but have

Re: [RDBO] Classless Rose::DB::Objects

2007-06-19 Thread mla
John Siracusa wrote: > On 6/19/07 9:59 PM, mla wrote: >> Cool. Can I help? Do you already have a general approach in mind? > > The first step is to make a decent SQL abstract abstraction made up of > mutable objects which link back to the relevant bits of RDBO metadata. I'll > probably validate t

Re: [RDBO] Classless Rose::DB::Objects

2007-06-19 Thread John Siracusa
On 6/19/07 9:59 PM, mla wrote: > Cool. Can I help? Do you already have a general approach in mind? The first step is to make a decent SQL abstract abstraction made up of mutable objects which link back to the relevant bits of RDBO metadata. I'll probably validate that piece by re-implementing the

Re: [RDBO] Classless Rose::DB::Objects

2007-06-19 Thread mla
John Siracusa wrote: > On 6/19/07, mla <[EMAIL PROTECTED]> wrote: >> The features I'm interested in are: >> >>o Providing a somewhat consistent interface between these ad-hoc >> result sets and normal RDBO objects. >> >>o Catching field typos which the accessors/mutators would give you

[RDBO] Rose::DB::Object::Column::Serialize?

2007-06-19 Thread Michael Reece
i am looking to freeze/thaw (or yaml, doesn't really matter..) unblessed data structures into a mysql column. has anyone already written a Column class that handles this transparently? --- michael reece :: software engineer :: [EMAIL PROTECTED]

Re: [RDBO] MakeMethods::Generic.pm 'count' interface errors

2007-06-19 Thread John Siracusa
On 6/18/07, mla <[EMAIL PROTECTED]> wrote: > Subselect? > > SELECT count(*) >FROM ( > SELECT DISTINCT a_id, b_id >FROM a_b_map > WHERE a_id = xxx >) s So far, that looks like the best option to me. Can anyone think of anything better? -John ---

Re: [RDBO] Classless Rose::DB::Objects

2007-06-19 Thread John Siracusa
On 6/19/07, mla <[EMAIL PROTECTED]> wrote: > The features I'm interested in are: > >o Providing a somewhat consistent interface between these ad-hoc > result sets and normal RDBO objects. > >o Catching field typos which the accessors/mutators would give you. > (although you could