On 8/1/06, Dustin Lee <[EMAIL PROTECTED]> wrote:
Is it possible to configure sqlobject so that it can select from one server and do insert/update/deletes on possibly another server (or generally just choose where any one given sql instruction will be executed)?  The background is that we are moving to a multi-coast/continent replication scheme with mysql so that we can have our app have fast local reads but then do less frequent modifying statements on a single "master".

hi this may be a little unrelated but in TG we haven't found a better way then this.

http://trac.turbogears.org/turbogears/wiki/MultipleDatabases

So basically we have 2 "instances" of SQLObject and your code will have to know which one to use.

So basically the answer is there is no pretty way.

Thanks.

--
Dustin Lee
qhfgva=rot13(dustin)

-------------------------------------------------------------------------
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

_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss



-------------------------------------------------------------------------
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
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to