I am looking into using Umbraco as a Points of Interest database, so that Umbraco users have an easy way, by using the standard UI of Umbraco, to define POIs with their lat/long and any additional info, using a normal document type. I also want to be able to perform SQL queries using functions like distance() to return a set of POI records.
In order to do this, I would like to use MySQL as the Umbraco DB, by installing the MySQL spatial extensions.
Umbraco POI
Hi,
I am looking into using Umbraco as a Points of Interest database, so that Umbraco users have an easy way, by using the standard UI of Umbraco, to define POIs with their lat/long and any additional info, using a normal document type. I also want to be able to perform SQL queries using functions like distance() to return a set of POI records.
In order to do this, I would like to use MySQL as the Umbraco DB, by installing the MySQL spatial extensions.
Anyone has experience using this config?
Thanks,
Jaco
is working on a reply...