RLS is one of the shittiest things about Postgraphile and why I decided against for one project and am doing my best to root it out of a current project.
RLS is difficult to unit test, to configure with flags, not portable to secondary stores, and requires knowledge of arcane database features.
When you put some private data on a cache somewhere and query it, now you need to write your access layer twice since the other one is so tightly coupled to the database.
RLS is difficult to unit test, to configure with flags, not portable to secondary stores, and requires knowledge of arcane database features.
When you put some private data on a cache somewhere and query it, now you need to write your access layer twice since the other one is so tightly coupled to the database.