Rubyslava / PyVo #40 - Database Edition

Jun 25, 2014 · Toronto, Slovakia
ATTENTION: 25.6. IS WEDNESDAY, NOT THURSDAY AS USUAL! We are celebrating our 40th meetup with great speakers from Vienna. Talks: 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. N things you didn't know about PostgreSQL (Markus Prinz, @nuclearsquid) 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. Event on Lanyrd Invite your friends! Emergency contact: +421 903 919 128 (Jano Suchal)
Event organizers

Are you organizing Rubyslava / PyVo #40 - Database Edition?

Claim the event and start manage its content.

I am the organizer

based on 0 reviews