Re: [RDBO] Streamlining documentation

2007-05-19 Thread David Lloyd
John, > The only tricky > part would be how and where to link to the reference docs (or the tutorial, > I supposed). Errr, the academic world has had appendices and bibliography for years if not centuries :) DSL - This S

[RDBO] Tables Without Primary Keys

2007-05-29 Thread David Lloyd
Hi There, Is there a way to cope with a table that does not have a primary key? DSL - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No

Re: [RDBO] Tables Without Primary Keys

2007-05-29 Thread David Lloyd
Cees, >> Is there a way to cope with a table that does not have a primary key? > > Can you not just make all the columns belong to the primary key? That > will work unless your schema allows you to create two identical > records in the database (not something that is often useful). I could do

[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] How to get transactions right

2007-06-27 Thread David Lloyd
Michael, > If yes, my question is, how all the RDBO internals work with such a setup. If > I remember correctly > RDBO wraps complex saves or deletes within a transaction. Would this lead to > something like > nested transactions? Is this possible at all, with sqlite (I am using now) > and p

Re: [RDBO] suggestions for enchancement

2007-11-27 Thread David Lloyd
Ron, Ron Savage wrote: > You mean like SQL::Abstract? > http://search.cpan.org/~nwiger/SQL-Abstract-1.22/ I was thinking the same thing...does that not do what the OP wishes it to? DSL - SF.Net email is sponsored by: The F

Re: [RDBO] suggestions for enchancement

2007-12-04 Thread David Lloyd
Ok, so does Hibernate from the Java World, or JPA from Jave EE 3.0 actually do what we want? I suspect it does... DSL - SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop