You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In my app I use MySQL spatial functions directly in db queries, to filter results based on distance from location (e.g. restaurants near a user). When researching this in the past, there were performance benefits to doing this directly in MySQL as opposed to in my server code (e.g. PHP, Go, etc). e.g. Link
Fast-forward a bit, my app is fully Node.js (for lots of other reasons). I still use raw queries with the MySQL spatial func, however it's difficult juggling raw queries against the high-level stuff my CMS/ORM wants to do. In this case, your library may be much more practical. Aside from the query filtering, I think this lib would be useful since there's lots of mapping of data involved in the app and all the UX/UI that comes with that.
Anyhow, I'm wondering if there are any performance worries ie this library vs MySQL spatial funcs?
In my app I use MySQL spatial functions directly in db queries, to filter results based on distance from location (e.g. restaurants near a user). When researching this in the past, there were performance benefits to doing this directly in MySQL as opposed to in my server code (e.g. PHP, Go, etc). e.g. Link
Fast-forward a bit, my app is fully Node.js (for lots of other reasons). I still use raw queries with the MySQL spatial func, however it's difficult juggling raw queries against the high-level stuff my CMS/ORM wants to do. In this case, your library may be much more practical. Aside from the query filtering, I think this lib would be useful since there's lots of mapping of data involved in the app and all the UX/UI that comes with that.
Anyhow, I'm wondering if there are any performance worries ie this library vs MySQL spatial funcs?
MySQL distance calc example:
The text was updated successfully, but these errors were encountered: