How to find users near a central coordinate (spatial nearest neighbor queries)

Scenario You have a database table of users who have a location specified. Given an input location point, coordinate, or city - find the top N (or all) of the nearest neighbors in range. So for example, if I am in Seattle, return 15 nearest users to my location within a 50 mile range. This is a classic … Continue reading How to find users near a central coordinate (spatial nearest neighbor queries)

Welcome!

Hi there! I'm going to use this space going forward for technical blog features. I will outline interesting things in the world of software development and/or devops. The first several features will be challenges I encountered while building and launching Tourvival. I also wanted to mention that you can find some of my previous writing at this … Continue reading Welcome!