graphql/dataloader
View on GitHub[QUESTION] Any recommendations for using DataLoader with pivot tables?
Open
#289 opened on Dec 29, 2021
help wanted
Description
Pivot tables are often used in relational databases to define one-to-many relationships.
In my case I'm using Adonis.js's Lucid ORM in my GraphQL resolvers, but things get a little tricky when loading relationships that use a pivot table. For example:
const user = await context.loaders.userById.load(input.id);
const posts = await user.posts().fetch();
// Since I didn't use a loader to fetch posts, I now have to prime the cache manually:
for (let post of posts.rows) {
context.loaders.postById.prime(post.id, post);
}
The downside to this is I lose the simplicity of only using my loaders to grab data, and I have to remember to manually priming my cache even when I might not need the data again.