Rubyslava / PyVo #40 - Database Edition

ATTENTION: 25.6. IS WEDNESDAY, NOT THURSDAY AS USUAL! We are celebrating our 40th meetup with great speakers from Vienna.

Software, Technology

Submit new post
Thank you for posting.
Share it:

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!

From: June 25, 2014 19:00
To: June 25, 2014 23:59

Kafe Nervosa, 30 Zámocká, 811 01, Bratislava, Slovakia


Software, Technology


Database, PostgreSQL, Relational Databases



Contact email

Contact phone
+421 903 919 128


Submitted by:


Are you the organizer?

Get in touch