Re:What ORMs have taught me: just learn SQL (2014)
by zimpenfish on Monday December 18, 2017 @12:23PM
(#15953311)
As best I can tell, Postgres lets you do this albeit constraining your boolean checks to things you can efficiently do in the database. But then I can definitely see how this could get unwieldy very quickly.
https://www.postgresql.org/docs/9.5/static/ddl-rowsecurity.h...
Re:What ORMs have taught me: just learn SQL (2014)
by icebraining on Monday December 18, 2017 @12:40PM
(#15953467)
I know about row-level security, but I don't think the rules can be dynamically loaded.
The kind of rules we use are boolean expressions that identify which rows the user's groups can read/write/delete. The ORM automatically combines all the rules as a single expression and applies it to the query.