I've had some problems posting to this group, so if you've seen this before, I apologize.
First, thanks to all the TG developers; I love it. I've gone out on a limb and convinced my company to use it for new applications. Since I'm the only Pythonista in the company, it falls to me to put the infrastructure in place and help the others. I'm using tg1.0.8 and sqlObject, although I could upgrade to SQLAlchemy if that solves my problem. I'm using Adobe's Flex for the client, so all I need is XML out of the TG controller. My company uses the same server but a different but structurally identical MySQL database for each of ~15 facilities. So a database might be payrollxx where xx is a legacy facility id. There are a lot of valid reasons for keeping these databases separate, although ease of maintenance is not one of them. Our applications are trivial, clerical type operations with typical CRUD operations. Not much cpu, database or network loading. A typical scenario would have 3 simultaneous users, who could share a single connection and not notice the speed impact. But how do I go about changing the database used by a sqlObject model bonce the user has selected the appropriate facility. or how do I create a connection pool per facility, so I can have the user fetch the correct set of models. I'm still in the early design stages, so I could switch to SQLAlchemy if that's a better solution. I could also switch to TG 2.0, but my company frowns on using beta software and I would have to keep that under the covers until TG is no longer beta -- and stable. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
