Great post. Just to be pedantic for a moment:
> it gives you results that are 100% correct, which is pretty important!
Not quite 100% correct, as the `ST_Distance_Sphere` function uses a spherical earth model, & in fact the earth is an oblate spheroid :) The slower-but-more-accurate `ST_Distance_Spheroid` also exists if you care about such things.