Don't bet on SELECT's order: shuffle your rows and see what folds

Authors: Yaroslav Kurbatov, Backend Engineer, and Travis Turner, Tech Editor Topics: DX, Rails, PostgreSQL, Ruby, Python, Continuous Integration PostgreSQL does not guarantee row order without ORDER BY. Use Rails 8.2 or pg_disorder to shuffle unordered SELECT results and expose hidden order dependencies, flaky tests, and application bugs. This is chaos engineering directed at your database. SELECT * FROM posts carries no promise about the order of the returned posts. Yet, every relational dat...