cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andreas Hartmann <andr...@apache.org>
Subject PostgreSQL schemas for multi-tenant application
Date Sun, 26 Jul 2009 13:10:34 GMT
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


Mime
View raw message