notum-cz / strapi-plugin-location

This plugin allows users to create location inputs and store latitude and longitude values as geometry types in a PostGIS database. It also provides functionality to filter items based on their location.
MIT License
26 stars 13 forks source link

fix: moving to native geography fields to prevent type casting #183

Closed JannikZed closed 5 months ago

JannikZed commented 7 months ago

this PR changes the column type to geography, as we are only working with coordinates and always typecast in all queries. This change allows to create a GIST database index (could be added to this PR or manually by users) to speed up queries dramatically.

omikulcik commented 5 months ago

Hi, please see the comment on your other PR