On 10/08/2018 12:36 PM, Andrew Fam wrote:
Yeah it'll be good to leave some ideas here so that ppl don't have to
make painful changes down the line to fit the system later.
The current solutions require too much work and are not that flexible.
On Friday, August 10, 2018 at 10:32:47 AM UTC+8, Mike Dewhirst wrote:
On 10/08/2018 11:45 AM, Andrew Fam wrote:
Hi all, I have a saas solution currently sitting in 1 instance
using a postgres db.
Due to recent expansions, I need to keep the data in the country
of which it came from. e.g Malaysia or Philippines will have a
database of their own.
In addition, some companies are asking for on - prem versions and
I was thinking it might be good for them to own their database
while we keep the application server.
Does anyone have an idea of how to solve this issue and what is
the most elegant way of doing this?
Don't know about your application but mine generates its main benefit
for clients in sharing the public side of their information while
keeping their proprietary info safe. That means some models in the
public schema and some in private/tenant schemas. Django will let me do
that if I understand the router docs correctly. However, some clients
want all their data in their own private database and shared publically
via their own website. That is a retrograde solution so it means when
they discover that they really want to put their public facing info into
the main public database I'll need a REST API so they can publish it.
It is an interesting problem I'm going to have to solve one day.
So no I can't help but I'll watch this thread.
I'm particularly interested in security aspects.
Some background to this.
I have a tenant model that is storing the country using countryfield.
Some models directly link to the tenant model, others reference a
field which is tied to a model with the tenant model.
--
You received this message because you are subscribed to the
Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to django-users...@googlegroups.com <javascript:>.
To post to this group, send email to django...@googlegroups.com
<javascript:>.
Visit this group at https://groups.google.com/group/django-users
<https://groups.google.com/group/django-users>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/be6fb573-50fa-4f48-be37-712d1a279859%40googlegroups.com
<https://groups.google.com/d/msgid/django-users/be6fb573-50fa-4f48-be37-712d1a279859%40googlegroups.com?utm_medium=email&utm_source=footer>.
For more options, visit https://groups.google.com/d/optout
<https://groups.google.com/d/optout>.
--
You received this message because you are subscribed to the Google
Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to django-users+unsubscr...@googlegroups.com
<mailto:django-users+unsubscr...@googlegroups.com>.
To post to this group, send email to django-users@googlegroups.com
<mailto:django-users@googlegroups.com>.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/3dccb4bb-b72a-4b53-a36c-85a99e67e0ae%40googlegroups.com
<https://groups.google.com/d/msgid/django-users/3dccb4bb-b72a-4b53-a36c-85a99e67e0ae%40googlegroups.com?utm_medium=email&utm_source=footer>.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Django
users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/485c759d-523d-edfe-90dd-e2409410d5a7%40dewhirst.com.au.
For more options, visit https://groups.google.com/d/optout.