I'm pretty sure you can pass a connection around and set a connection when you create and instance and that it will use that connection for the life of that instance. I'm not sure if you can change the connection once you have an instance. I haven't had to do this, but it's something I think Ian and I talked about before. Sorry I don't more specifics.
-- Rick On Tue, 1 Aug 2006, Jorge Vargas wrote: > 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
