Hi, I suggest that you check out the LoopBack <http://www.loopback.io>project which comes with a power ORM for populate data stores such as MongoDB, MySQL, Oracle, and PostgreSQL.
1. You can define ACLs to control access based on the model/property. 2. You can create 'dynamic' roles to do record instance level access control 3. It supports multiple types of relations 4. We map relations into REST APIs too You can find more information on the this blog: http://strongloop.com/strongblog/defining-and-mapping-data-relations-with-loopback-connected-models/ More links for your reference: https://github.com/strongloop/loopback https://github.com/strongloop/loopback-datasource-juggler http://docs.strongloop.com/display/DOC/LoopBack Thanks, Raymond On Friday, April 11, 2014 11:43:11 PM UTC-7, Rajesh wrote: > > We use postgres. We are considering using an available ORM like sequelize, > but have the following requirements in our application. > > 1. Support field level permissions (some fields are accessible only > for certain roles). We would like this to be part of the model definition. > 2. Support row level access control (eg. an item can be seen only by > the creator of the item, or if the user belongs to the same territory of > the item). We would like this to be part of the model definition. > 3. We have complex relationships between models - up to four levels > 4. We have several hierarchical models - like territory. > > Is there any ORM that is a good fit for these requirements? If not, what > is the recommended approach for achieving these requirements? Is writing my > own ORM a good idea? > -- -- Job Board: http://jobs.nodejs.org/ Posting guidelines: https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines You received this message because you are subscribed to the Google Groups "nodejs" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nodejs?hl=en?hl=en --- You received this message because you are subscribed to the Google Groups "nodejs" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
