hey guys, how do you handle a one to many situation. ie:

data class Movie(
    val id: Long,
    val token: String
)

data class User(
    val id: Long,
    val name: String
) {

    fun movies(userIds: List<Long>): List<Movie> {
        return LongRange(0, 2)
            .map { Movie(it, "movie-$it") }
            .toList()
    }
}

@Component
class UserQueries : Query {

    fun users(): List<User> {
        return LongRange(0, 5)
            .map { User(it, "user-$it") }
            .toList()
    }
}

In a database situation it would be really bad to query users along with their movies because it would issue a single query per user to get their movies. Is there a way to avoid the multiple queries and instead get a list of the user ids and make a single query for all of their movies?

Yes, this is call this

n+1

problem in graphql. There are many different solutions. First off is that you can have your movie service handle batch requests and you don’t send the request until you have resolved all the users. Of course you could also implement caching in the downstream services. But if you wanted GraphQL caching, you can use the Data Loader pattern: https://expediagroup.github.io/graphql-kotlin/docs/server/data-loaders

this seems like it’s mainly just caching

data loader pattern delays "loader" execution AFTER all fields (at a given level) are processed (but not resolved) -> so when the loader kicks off it will have ids from all fields and when it returns then result will be used to construct the appropriate response for the corresponding fields

thanks