Come do a presentation about Cayenne at WOWODC :-) > Or use Cayenne 3.1 ;) > > On Oct 19, 2012, at 4:16 PM, Pascal Robert <prob...@macti.ca> wrote: > >> Check: >> >> https://github.com/hprange/multi-tenant-prototype >> >> I think Michael Gargano is using it with good success. Check the "model >> connections to multiple DBs" thread from April 2011 and "Different Database >> Connection per session for the same model" from June 2012. >> >>> We are looking into converting our existing EOF based apps to support >>> multi-tenancy. Today we can support multiple customers in a single schema >>> using relationships to separate the data. EOF works fine in this model. We >>> even implemented the multiple EOObjectStore coordinators for additional >>> scalability. >>> >>> Has anyone figured out how to support separate schema based multi-tenancy >>> with EOF? i.e. each customer gets a separate schema and requests for that >>> customer load data from that schema only? I know we can deploy our app >>> multiple times - each time pointing to a different schema. Ideally though >>> we would be able to share binaries and swap schemas on a per request basis. >>> >>> I am thinking some mojo would have to occur along the lines of the >>> following: >>> >>> • Load the EOModel once - this assumes that all customers would share >>> the same DB structure >>> • DO NOT pre-load any data at start up unless it is stored in per >>> customer caches >>> • As each request comes in - >>> • identify the customer >>> • either create a new connection or grab one from a pool. In >>> the case of EOF I think that implies that there would be separate object >>> store coordinators per customer >>> • Hook the object store up with the model >>> • execute the request >>> • break everything back down >>> >>> Is this even possible with EOF/Project Wonder? >>> >>> Thanks >>> >>> Dov Rosenberg >>> _______________________________________________ >>> Do not post admin requests to the list. They will be ignored. >>> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) >>> Help/Unsubscribe/Update your Subscription: >>> https://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca >>> >>> This email sent to prob...@macti.ca >> >> >> _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) >> Help/Unsubscribe/Update your Subscription: >> https://lists.apple.com/mailman/options/webobjects-dev/andrus%40objectstyle.org >> >> This email sent to and...@objectstyle.org > > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca > > This email sent to prob...@macti.ca
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com