How can i use prisma ORM with mysql database (planetscale) and query the nearst objects distances (lat and long)?
I have tryed to search the solution, but i found only ways to solve this on Postgresql database with Postgis
Asked
Active
Viewed 262 times
0
-
Have you looked at this Stack Overflow answer: https://stackoverflow.com/questions/574691/mysql-great-circle-distance-haversine-formula? This SQL query should be useful to query nearest object distances. – Nurul Sundarani Feb 03 '23 at 07:10