Pagination Done the Right Way (Markus Winand, author of Use The Index, Luke! book)
Fetching results in a page-wise manner is still a very common requirement when working with SQL databases— even when displaying an ‘infinite’ list on the user interface. In this session Markus Winand shows different approaches to fetch a limiter part of a result and explains why the traditional LIMIT/OFFSET method has very poor performance. The preferable approach, named "Key-Set Pagination" or just "the Seek Method," has always better performance and is on top of that also immune to showing duplicate results when new rows are inserted in between fetching two pages.
A few lesser known features and related things of PostgreSQL that turn it from "just an SQL database" into a data platform.
Rubyslava / PyVo is sponsored by JetBrains and Toptal. Get a free yearly licence for a product of your choice: RubyMine, PyCharm or PHPStorm. Win ebooks from Manning Publications and Apress. Beer and food is sponsored by Toptal.
Invite your friends!
+421 903 919 128