yes.....but there is no API for acos and asin. If you want I have an implementation that calculates distance from two points (lat,long) in kilometers, just in plain python.
If you want to calculate the minimum distance from a specific point to a list of 100000 points saved into the db it's probably not worth it, but for small amounts works pretty fine. Again, mind that that would require to load all the points and sort things out with python and using the db only for retrieval/storing. Il giorno mercoledì 14 marzo 2012 17:42:18 UTC+1, Kenny ha scritto: > > Thank you for reply Wikus. I know I can use mysql. But I am trying to > stick with Sqlite. hehe Does DAL queries support MySql just like Sqlite? > > On Wed, Mar 14, 2012 at 4:18 AM, Wikus van de Merwe < > dupakrop...@googlemail.com> wrote: > >> You can use mysql with web2py: >> http://web2py.com/books/default/chapter/29/6#Connection-strings >> >> >
