Writing on software, databases and freelancing.

All of my long-form thoughts on programming, databases, freelancing, project management, and more, collected in chronological order.

How to optimize ORDER BY RANDOM()

Optimizing random order is hard because no index can be used. But there are some creative ways to make it fast with different tradeoffs.