PostgreSQL schemas for multi-tenant application

From: Andreas Hartmann (andrea..pache.org)
Date: Sun Jul 26 2009 - 09:10:34 EDT

Next message: Andreas Hartmann: "Re: PostgreSQL schemas for multi-tenant application"

Previous message: sridhar devatha: "Re: Modification and deletion of data objects"
Next in thread: Andreas Hartmann: "Re: PostgreSQL schemas for multi-tenant application"
Reply: Andreas Hartmann: "Re: PostgreSQL schemas for multi-tenant application"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi Cayenne users & devs,

I'm currently designing the DB + ORM layer for a multi-tenant
application, using PostgreSQL 8.3 and Cayenne 2.0.4.

After some research it looks like PostgreSQL schemas are a pretty decent
way to achieve the separation of the tenant data on the DB level.
Unfortunately, it looks like multiple schemas are not supported by Cayenne.

Is this correct?

If yes, what strategy would you recommend for the multi-tenancy? Do I
have to resort to using a tenant ID column in the affected tables?

Thanks a lot for any hints!

-- Andreas

-- 
Andreas Hartmann, CTO
BeCompany GmbH
http://www.becompany.ch
Tel.: +41 (0) 43 818 57 01

Next message: Andreas Hartmann: "Re: PostgreSQL schemas for multi-tenant application"
Previous message: sridhar devatha: "Re: Modification and deletion of data objects"
Next in thread: Andreas Hartmann: "Re: PostgreSQL schemas for multi-tenant application"
Reply: Andreas Hartmann: "Re: PostgreSQL schemas for multi-tenant application"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Sun Jul 26 2009 - 09:20:47 EDT