Database nerd, freelancer, and amateur chef.

I'm Tobias Petry, a full-stack software developer, database consultant and educator from Germany. I dedicate most of my time to help developers utilize their database better by working on database tools and creating educational material.

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.

Offered Services

  1. Performance Tuning
    I can identify slow queries and suggest indexes or schema changes to fix them.
  2. Migration
    I can assist you in planning a switch to another database or a complex schema migration.
  3. Training
    I can train your developers in many different topics tailored to your needs.
  4. Guidance
    I offer database expertise for all questions and problems that may appear.