Hacker News Reader

Filtering on relationships is a big issue for us. Each nested node in the query graph (tree?) generates a new SQL query. We seem to committed to that approach at this point, to trying and migrate to a world where we inspect the whole thing, then make 1 query, isn't going to happen.

View on HN

Not trying to specifically shill my own library, but I developed this a while ago before there were any established patterns with filtering on relationships in graphql. https://github.com/tandg-digital/objection-filter

Out of curiosity, would functionality like this implemented in graphql solve your issues?

i know relationships don’t typically have props in a store like neo4j, and moreover you can reproduce that in something like postgres with a foreign key

we had a challenge like what you describe though, and were able to avoid new queries by representing the relationships as objects. in so doing, we leverage row level security and jwt claims, which is an approach to authorization which has high epistemical legibility.

Reply on news.ycombinator.com