Re: Multi tenancy : schema vs databases
On Sat, Oct 1, 2016 at 4:52 PM, John R Pierce <pierce@hogranch.com> wrote:
On 10/1/2016 12:52 PM, Rakesh Kumar wrote:Do your clients authenticate directly to the database, or to the app server?thru app server.do you run a separate instance of the app for each tenant, or is there one app that identifies the tenant and handles them accordingly ?
-- john r pierce, recycling bits in santa cruz
I would like to comment on the multiple schema vs databases situation.
First of all, 1000's of databases is insanity and just asking for trouble. Next, 1000's of schemas is a nightmare to maintain. I understand the requirement for client data to be "isolated", but in reality, data is never really separated. Once it's on the server, any good hacker with a knowledge of SQL can find it. So, IMHO, the best solution is to isolate by a client ID in the tables of one database. Then make sure you have sufficient and correct security on those tables.
--
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
В списке pgsql-general по дате отправления: