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 client's server space, in which some
rules will does not comply - as a "core client database" will not be
available, as an example.
assuming that i have a lot of clients in our self hosted platform, i
could enable multi-tenancy, but can i query or join between different
databases?
fyi, the server is postgres 9.x
thanks a lot,
richard.
On 04/08/2014 10:57 AM, Michael Bayer wrote:
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
<rich...@humantech.com.br <mailto:rich...@humantech.com.br>> wrote:
hi all!
i have a question about sqlalchemy and database design.
i'm developing an app, where each client may receive an alert about
the total space usage of their data (files and database), so, using
postgresql, i can get them (data usage size) using a different
tablespace, database or schema, if i'm not wrong. given these
premises, which is the best way to design my database using
sqlalchemy, having in mind that I need also to integrate the client
databases to the "core" database?
my best regards,
richard.
--
You received this message because you are subscribed to the Google
Groups "sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to sqlalchemy+unsubscr...@googlegroups.com
<mailto:sqlalchemy+unsubscr...@googlegroups.com>.
To post to this group, send email to sqlalchemy@googlegroups.com
<mailto:sqlalchemy@googlegroups.com>.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google
Groups "sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to sqlalchemy+unsubscr...@googlegroups.com
<mailto:sqlalchemy+unsubscr...@googlegroups.com>.
To post to this group, send email to sqlalchemy@googlegroups.com
<mailto:sqlalchemy@googlegroups.com>.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.