[ Feature Request ] Relay-like pagination

[azzamsa]

[ Feature Request ] Relay-like pagination

[heyrict]

Thank you for your feature request.

Well, the short answer is no. I used relay-styled pagination around 4 years ago for this website, but switched to limit-offset style a while later for simplicity. I have no plan to switch back to relay in the near future.

If I remember correct, I added this line to roadmap because I thought it was possible to implement relay-style pagination to diesel with some minor modifications, as I managed to solved dynamic query (passed from async-graphql) in this project, which is quite a complex problem.

As you said there are little resources to follow, I can give you some ideas about how to implement it.
Rust is a low level language and implementing relay specifications is up to yourself. One approach is to translate first and last to select ... limit {first} order by {order_field} {asc/desc} in sql, and before and after to something like ... where {order_field} > {after} order by {order_field} {asc/desc}. If you follow my code, you can change the query parameters in src/gql_schema/*.rs to achieve that, but any backend/ORM that support dynamic query can do the trick. before and after can be encoded as {query_name}:{order_field_value} or whatever unique token you like.
Another approach is to use built-in cursor in postgresql, but I am not familiar with that and cannot give you advice about it.

Going to close this issue.

[azzamsa]

I have implemented the feature here async-graphql/async-graphql#563 (comment), Thanks a lot for the input, Would you like to add any suggestions for improvement?