Re: [sqlalchemy] database "design" question

2014-04-08 Thread Richard Gerd Kuesters
thanks again mike. well, most of our software is already message driven, but we still need to "group" information if we want to; ex: search from all our clients databases for some value in a model that's shared between them. thanks a lot, richard. On 04/08/2014 12:07 PM, Michael Bayer wrote:

Re: [sqlalchemy] database "design" question

2014-04-08 Thread Michael Bayer
On Apr 8, 2014, at 11:01 AM, Richard Gerd Kuesters wrote: > thanks mike. i know it's a vague question, but that just the point: i don't > know the answer because it can be both :) > > let me clarify: assuming the application can be self hosted (in our ift), > hence also multi-tenancy can be

Re: [sqlalchemy] database "design" question

2014-04-08 Thread Richard Gerd Kuesters
thanks mike. i know it's a vague question, but that just the point: i don't know the answer because it can be both :) let me clarify: assuming the application can be self hosted (in our ift), hence also multi-tenancy can be used for multiple clients. if not, the same codebase would run in the

Re: [sqlalchemy] database "design" question

2014-04-08 Thread Michael Bayer
this is a vague and open ended question, is this a multi-tenancy application? does each client have their own database? or is that the question?if its multi tenancy, Id probably give each client a different database, why not? On Apr 4, 2014, at 12:58 PM, Richard Gerd Kuesters wrot

Re: [sqlalchemy] database "design" question

2014-04-08 Thread Richard Gerd Kuesters
perhaps this would help? http://techspot.zzzeek.org/2012/01/11/django-style-database-routers-in-sqlalchemy/ i'm willing to use different schemas to my question. if anyone have a better idea, let me know :) best regards, richard. On 04/04/2014 01:58 PM, Richard Gerd Kuesters wrote: hi all!