[OGDev] What are people working on?
Nick Burch
openguides at gagravarr.org
Mon Mar 5 10:53:17 GMT 2007
On Sun, 4 Mar 2007, Kake L Pugh wrote:
> There's still the problem of the lat/long being wrong in the database
> though, and I think this is important. Part of the reason I based
> CGI::Wiki on a database backend in the first place was that I always had
> in mind that people would be able to use SQL to get data out in
> unforeseen ways. Historical reasons aren't really justifications for
> doing anything, of course, but I think I've showed recently (e.g. the
> search thingy I posted to the list) that direct database access is a
> real possibility, and really useful.
Maybe we should do the conversion to wgs84 at page save time, put the
un-converted lat/long into a new field (eg local_lat, local_long), and
make the (current) lat/long fields hold the wgs84 one?
That way, most things that want lat/long will get the wgs84 one (which
they probably expect), we have the local one to hand if needed, and we
only need to do the conversion on page save, not each page view.
Nick
More information about the OpenGuides-Dev
mailing list