I just switched to Postgres and some of my tests are failing. It seems
that Postgres defaults by ordering data by ID DESC, whereas MySQL
defaults to ordering by ID ASC.
What is the best practice for handling this? Is there a setting in
Postgres you can change? Should I be explicitly specifying the order of
my data in my queries?
In various places throughout my application I am doing things like:
This obviously is not good with the order of the data is not consistent.
I also feel like the first User should return the first user, not the
last one created.
What do you think?