cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Gentry <mgen...@masslight.net>
Subject Re: PostgreSQL schemas for multi-tenant application
Date Mon, 27 Jul 2009 15:52:14 GMT
I think multiple DataDomains might be what you want, but I'm not 100%
certain everything you are trying to do.
Also, if you are just starting out, it might be worthwhile to use Cayenne
3.0M6.

mrg


On Sun, Jul 26, 2009 at 10:51 AM, Andreas Hartmann <andreas@apache.org>wrote:

> Andreas Hartmann schrieb:
>
>> Andreas Hartmann schrieb:
>>
>>> 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.
>>>
>>
>> I just noticed that the DbEntity class has a schema property. Would the
>> following approach work?
>>
>> Create a DB entity for each table in each schema, e.g. users_schema1,
>> users_schema2 etc.
>>
>> To run a query:
>>
>> DbEntity entity = dataMap.getDbEntity("users_" + schemaName);
>> SelectQuery query = new SelectQuery(entity, expression);
>>
>
> It seems like this won't work because for each DB entity an object entity
> (i.e. class) would be required.
>
> But I found the section on multiple DataDomains in the documentation. I
> guess this is the way to go?
>
>
> -- Andreas
>
>
> --
> Andreas Hartmann, CTO
> BeCompany GmbH
> http://www.becompany.ch
> Tel.: +41 (0) 43 818 57 01
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message