News for hackers. Stuff that matters.
Re:Our Multi-Tenancy Journey with Postgres Schemas and Apart... by geocar on Tuesday December 06, 2016 @10:07AM (#13115089)
Querying across multiple schemas can be useful, for example if:

• You want easy administrative controls for impersonating a customer

• You want to run business queries across multiple customers

• You integrate authentication with your database, so you don't need a separate service to tell your application "which" database endpoints to use with your username.

• You want to simplify sysadmin job of managing a single database instead of thousands of databases.

And so on. Sometimes these things are worth giving up the "simple" isolation.

There are no comments on this comment yet.