diff options
author | Bryan Newbold <bnewbold@robocracy.org> | 2021-11-05 14:16:41 -0700 |
---|---|---|
committer | Bryan Newbold <bnewbold@robocracy.org> | 2021-11-05 14:18:11 -0700 |
commit | c87befeff80f609e0890ec608d9e65186ae528e8 (patch) | |
tree | f9d000d9e09ea89dbf45fe0b33c89ac3d2edd239 /rust/migrations/00000000000000_diesel_initial_setup/up.sql | |
parent | ee840a44990c02012955be860db5933493ea4b8a (diff) | |
download | fatcat-c87befeff80f609e0890ec608d9e65186ae528e8.tar.gz fatcat-c87befeff80f609e0890ec608d9e65186ae528e8.zip |
api: add SQL 'ORDER BY' to many reads to stabilize API array ordering
The hope is to make things like file entity URLs, fileset manifests, and
other arrays in the JSON API "stable", meaning that if you create an
entity with a list of a given order, a read back (in any environment,
including prod/QA, bulk dumps, etc) will return the array with the same
sort order.
This was informally happening most of the time, but occasionally not (!)
Assumption is that these sorts will have little or no performance
impact, as the common case is less than a dozen elements, and the hard
cases are a few thousand at most, and there is already a sorted index.
Diffstat (limited to 'rust/migrations/00000000000000_diesel_initial_setup/up.sql')
0 files changed, 0 insertions, 0 deletions