{"action":"created","issue":{"url":"https://api.github.com/repos/balderdashy/waterline/issues/918","labels_url":"https://api.github.com/repos/balderdashy/waterline/issues/918/labels{/name}","comments_url":"https://api.github.com/repos/balderdashy/waterline/issues/918/comments","events_url":"https://api.github.com/repos/balderdashy/waterline/issues/918/events","html_url":"https://github.com/balderdashy/waterline/issues/918","id":65324317,"number":918,"title":"Feature Request: Seek/Keyset Pagination","user":{"login":"JetFault","id":487245,"avatar_url":"https://avatars.githubusercontent.com/u/487245?v=3","gravatar_id":"","url":"https://api.github.com/users/JetFault","html_url":"https://github.com/JetFault","followers_url":"https://api.github.com/users/JetFault/followers","following_url":"https://api.github.com/users/JetFault/following{/other_user}","gists_url":"https://api.github.com/users/JetFault/gists{/gist_id}","starred_url":"https://api.github.com/users/JetFault/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JetFault/subscriptions","organizations_url":"https://api.github.com/users/JetFault/orgs","repos_url":"https://api.github.com/users/JetFault/repos","events_url":"https://api.github.com/users/JetFault/events{/privacy}","received_events_url":"https://api.github.com/users/JetFault/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/balderdashy/waterline/labels/feature","name":"feature","color":"207de5"},{"url":"https://api.github.com/repos/balderdashy/waterline/labels/needs%20community%20feedback","name":"needs community feedback","color":"009800"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-03-30T23:05:35Z","updated_at":"2015-09-22T00:41:28Z","closed_at":null,"body":"This is a feature request to add keyset/seek pagination. So instead of Offsets, which are slower and face problems with duplicates (if you add a new row) or missing items (if you delete a row), provide an 'after' criteria.\r\n\r\nSimilar to [Reddit](https://www.reddit.com/dev/api) and [Product Hunt](https://api.producthunt.com/v1/docs/posts/posts_all_paginate_to_older_posts)\r\n\r\nRelevant Threads:\r\n1. http://use-the-index-luke.com/no-offset\r\n2. http://use-the-index-luke.com/sql/partial-results/fetch-next-page\r\n3. https://wiki.postgresql.org/images/3/35/Pagination_Done_the_PostgreSQL_Way.pdf\r\n\r\nIn article [1], they mention some libs that implement this."},"comment":{"url":"https://api.github.com/repos/balderdashy/waterline/issues/comments/142147730","html_url":"https://github.com/balderdashy/waterline/issues/918#issuecomment-142147730","issue_url":"https://api.github.com/repos/balderdashy/waterline/issues/918","id":142147730,"user":{"login":"mikermcneil","id":618009,"avatar_url":"https://avatars.githubusercontent.com/u/618009?v=3","gravatar_id":"","url":"https://api.github.com/users/mikermcneil","html_url":"https://github.com/mikermcneil","followers_url":"https://api.github.com/users/mikermcneil/followers","following_url":"https://api.github.com/users/mikermcneil/following{/other_user}","gists_url":"https://api.github.com/users/mikermcneil/gists{/gist_id}","starred_url":"https://api.github.com/users/mikermcneil/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mikermcneil/subscriptions","organizations_url":"https://api.github.com/users/mikermcneil/orgs","repos_url":"https://api.github.com/users/mikermcneil/repos","events_url":"https://api.github.com/users/mikermcneil/events{/privacy}","received_events_url":"https://api.github.com/users/mikermcneil/received_events","type":"User","site_admin":false},"created_at":"2015-09-22T00:41:28Z","updated_at":"2015-09-22T00:41:28Z","body":"Thanks for posting, @JetFault.  I'm a repo bot-- nice to meet you!\n\nIt has been 60 days since there have been any updates or new comments on this page.  If this issue has been resolved, feel free to disregard the rest of this message.  On the other hand, if you are still waiting on a patch, please:\n\n  + review our [contribution guide](https://github.com/balderdashy/waterline/blob/master/CONTRIBUTING.md) to make sure this submission meets our criteria (only _verified bugs_ with documented features, please;  no questions, commentary, or bug reports about undocumented features or unofficial plugins)\n  + create a new issue with the latest information, including updated version details with error messages, failing tests, and a link back to [the original issue]().  This allows GitHub to automatically create a back-reference for future visitors arriving from search engines.\n\nThanks so much for your help!"}}