Re: PostgreSQL schemas for multi-tenant application

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

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

    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);

    TIA!

    -- Andreas 

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

    This archive was generated by hypermail 2.0.0 : Sun Jul 26 2009 - 09:27:17 EDT