Certainly a possibility. Ping me when you know the time and place (and I'll try 
to watch the list fir updates).

On Oct 19, 2012, at 5:18 PM, Pascal Robert <[email protected]> wrote:

> Come do a presentation about Cayenne at WOWODC :-)
> 
>> Or use Cayenne 3.1 ;)
>> 
>> On Oct 19, 2012, at 4:16 PM, Pascal Robert <[email protected]> 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      ([email protected])
>>>> Help/Unsubscribe/Update your Subscription:
>>>> https://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca
>>>> 
>>>> This email sent to [email protected]
>>> 
>>> 
>>> _______________________________________________
>>> Do not post admin requests to the list. They will be ignored.
>>> Webobjects-dev mailing list      ([email protected])
>>> Help/Unsubscribe/Update your Subscription:
>>> https://lists.apple.com/mailman/options/webobjects-dev/andrus%40objectstyle.org
>>> 
>>> This email sent to [email protected]
>> 
>> 
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list      ([email protected])
>> Help/Unsubscribe/Update your Subscription:
>> https://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca
>> 
>> This email sent to [email protected]
> 
> 


 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to