GEO calculations with MySQL

Geo-enabled or applications using user’s locations are increasing dramatically. I am currently working on an application which collects user’s location data, which led me to do more research and find an efficient methods to achieve the common tasks in a geo-enabled application.

  • Finding distance between 2 points using latitude and longitude.
  • Finding places of interest in a radius. (Example: All the coffee shops in 1 KM radius.

Basics:

ALTER TABLE places ADD coord POINT NOT NULL;
CREATE SPATIAL INDEX coord ON places (coord);

read more

Challenges in accepting online payment in Maldives

paymentgateway

Since the inception of internet service in Maldives, geeks and startup enthusiasts have attempted to create internet based startups in Maldives. A very few startups have been able to sustain while most of them discontinued and stopped their services due to the challenges. One of the major challenges faced by the Software Developers of Maldives is that, an affordable payment gateway solution is not available for them.

read more