71 comments for “Fast nearest-location finder for SQL (MySQL, PostgreSQL, SQL Server)

  1. Benjamin Wöster
    May 17, 2017 at 7:50 am
    • Ollie
      March 14, 2017 at 12:31 pm
      • Will
        March 14, 2017 at 12:56 pm

  2. Jarrod
    February 25, 2017 at 6:38 pm
    • Ollie
      February 28, 2017 at 7:30 pm

      SELECT

  3. Ashif Shereef
    December 2, 2016 at 3:58 am
    • Ollie
      December 2, 2016 at 5:21 pm

      JOINdistance column. A php program might fetch that with row['distance']

      • Ashif Shereef
        December 3, 2016 at 1:17 am
      • Ollie
        August 16, 2017 at 10:33 am
  4. August 16, 2016 at 2:33 pm
    • Ollie
      September 3, 2016 at 8:27 am
  5. Tom
    June 8, 2016 at 4:19 am
    • Ollie
      June 8, 2016 at 10:17 am
  6. Ollie
    April 19, 2016 at 2:48 pm
  7. Johny
    April 18, 2016 at 7:59 am
    • Ollie
      April 19, 2016 at 2:25 pm
  8. April 17, 2016 at 5:00 pm
  9. MD
    April 5, 2016 at 10:57 am
    • Ollie
      September 21, 2016 at 11:58 am
  10. Ollie
    December 13, 2015 at 5:23 pm
  11. John Manny
    October 23, 2015 at 8:50 pm
    • Ollie
      October 24, 2015 at 9:44 am
    • Ollie
      August 20, 2015 at 10:17 am
  12. César
    January 29, 2015 at 10:15 pm
  13. Michael
    November 17, 2014 at 8:33 pm

    • Ollie
      November 23, 2014 at 7:07 am

      WHERE distance <= plumber.service_radius instead of WHERE distance <= constant

      • Michael
        November 24, 2014 at 12:38 pm
  14. Alejandro
    October 29, 2014 at 3:26 am
    • Ollie
      October 29, 2014 at 10:13 pm
  15. Paul
    October 6, 2014 at 5:30 pm
    • Ollie
      October 8, 2014 at 6:55 pm
  16. David B
    July 25, 2014 at 12:52 am
    • Ollie
      July 25, 2014 at 9:06 am
      • David B
        July 25, 2014 at 10:00 am
  17. happy
    June 16, 2014 at 8:17 am
  18. Alex
    June 2, 2014 at 9:20 pm
  19. Martin Kovachev
    May 27, 2014 at 12:11 am
  20. Lei Ho
    May 4, 2014 at 12:17 pm
    • Ollie
      April 12, 2015 at 12:08 pm
  21. Marty
    March 29, 2014 at 12:14 am
  22. Cai
    February 28, 2014 at 1:29 am
  23. February 23, 2014 at 7:43 pm
    • Ollie
      February 23, 2014 at 8:37 pm
  24. February 20, 2014 at 12:38 pm
  25. Oli
    February 15, 2014 at 9:20 pm
    • Ollie
      February 16, 2014 at 8:10 pm
  26. MarkL
    January 2, 2014 at 11:23 am
    • Ollie
      January 2, 2014 at 12:38 pm
      • MarkL
        January 2, 2014 at 2:47 pm
      • Ollie
        January 2, 2014 at 4:49 pm
  27. mak
    December 27, 2013 at 5:39 am
    • Ollie
      December 27, 2013 at 8:48 am
  28. December 6, 2013 at 10:27 pm
  29. Nick
    November 29, 2013 at 6:05 pm
    • Ollie
      November 29, 2013 at 6:27 pm
  30. November 29, 2013 at 12:38 pm

What do you think? Let me know!