Markus Winand

SQL indexing and tuning tutorial for developers. No unnecessary database details—just what developers need to know. Covers all major SQL databases.

2016169 points13 commentscited by 8Databases & Data details

Uber provides bad advice about PostreSQL vs. MySQL

What’s left of NoSQL if they start adding ACID and SQL support?

SQL indexing: 60% don’t know how to get it right

MySQL and MongoDB are both popular, yet poor representatives of their species

2014cited by 18Databases & Data details

Pagination without OFFSET has many benefits but one problem: there is no tool support. Please help changing this.

2016cited by 11Databases & Data details

OFFSET doesn’t deliver stable results and makes the query slow. Key-set pagination does neither.