Could someone help me understand tradeoffs of not ...
# orm-helpd
Diego Serrano
12/27/2021, 8:05 PMCould someone help me understand tradeoffs of not using GIS for location data? I really want to use Prisma, but this is an important requirement in a platform I am working on
Was wondering if storing latitude and longitude would be enough
j
Jack Reed
12/28/2021, 1:03 PMIt really depends on your use cases. For example, if you need to do spatial queries, PostGIS PostgreSQL extension is really great: https://postgis.net/ . Could you do this and use prisma? Seems like there are some issues currently: https://github.com/prisma/prisma/issues/2789
🙂 1
👍 1
d
Diego Serrano
12/28/2021, 4:08 PMI will probably need to calculate the distance between a user’s coordinates and coordinates stored in the DB. This will be in the future though, but wanted to set myself for success starting now.
Diego Serrano
12/28/2021, 4:10 PMI thought that storing latitude and longitude with the right precision might be enough to get away with it.
Diego Serrano
12/28/2021, 4:10 PMBut it seems like using PostGIS is more proper. Will unfortunately skip on Prisma for now.
Diego Serrano
12/28/2021, 4:11 PMThanks for the answer!
2 Views