Can I use multiple SQLite databases within a TurboGears application? If so, how? Similarly (I think?), how would I use multiple schemas in Postgres?
I have looked around and found some maybe-related discussion, but I haven't been able to find a direct answer. Part of the problem I'm sure is that I'm brand new to TurboGears, SQLObject, et al. If an answer has already been posted somewhere, I would appreciate a pointer to it. More detail: I have written a buzzword-enabled bicycle trip planning application that displays results on a Google Map. The current version doesn't use a framework, but I am very interested in seeing if I can make effective use of one. Out of the many choices, TG is what I'm trying first, and I really hope it works out so I can stop spending so much time reading about frameworks and actually start becoming more productive. Getting started was easy and I partially migrated the current version, but now I've run into this issue. The app does two basic things: geocoding and routing. These operations are performed on data of distinct geographical regions. The schema for each region is slightly different from the rest. Right now I have one DB per region spread out into subdirectories of my model. I like this separation for various reasons. For example, I can add a new region without having to risk corrupting existing regions and I can easily pass around the DB for a region. I'm sure there is a way around having multiple DBs, say by using table prefixes and dumping regional data when I need to, but that seems kind of clunky to me. OTOH, it may be that I just don't know what I'm talking about. Any ideas or pointers would be greatly appreciated. ~wyatt Live version: http://tripplanner.bycycle.org/ Non-TG dev version: http://dev.bycycle.org/tripplanner/ TG dev version: http://dev.bycycle.org:8080/ (except that I don't seem to be able to reach it from the outside world) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
