https://authzed.com logo
Title
v

vganshin

03/11/2023, 5:39 PM
Hello. I wonder if Authzed can provide some hints to generate authorized sql queries? I know, I can get from Authzed list of ids of authorized resources, but that list can be too huge in some cases.
v

vroldanbet

03/12/2023, 8:59 PM
scaling ACL filtering (that's how we refer to filtering lists of elements from e.g. a database with a list of authorized resources/subjects from SpiceDB) is a complex problem. We have various options we are looking to support in the short-mid term.
v

vganshin

03/13/2023, 9:35 AM
I agree, it's complex problem in general. Is there some advices or guides how to implement to it in some specific use cases with current version of SpiceDB? I'm looking forward to SpiceDB ACL filtering support anyway.
v

vroldanbet

03/13/2023, 9:48 AM
We do have ACL Filtering with
LookupResources
and
LookupSubjects
, it just does not scale well for large datasets, so the proposed long term solution is described in https://github.com/authzed/spicedb/issues/207