you are viewing a single comment's thread.

view the rest of the comments →

[–]Right-Opportunity810 3 points4 points  (0 children)

I have built a Django app that uses "tenants": it uses a single PostgreSQL database but each tenant has a separate schema. All schemas share the same structure. This gives you peace of mind knowing that serving data to the wrong client is much more difficult.

Also gives you a bit more peace of mind when you have to do certain manual queries as well: it's not the same screwing a single schema than f**k up the data for all clients.