[Mageia-webteam] [Bug 998] O Brother, Where Art Thou?
bugzilla-daemon at mageia.org
Wed Apr 27 14:21:29 CEST 2011
--- Comment #7 from Romain d'Alverny <rdalverny at gmail.com> 2011-04-27 16:21:29 CEST ---
(In reply to comment #4)
> Country/city can already be done with localityName and countryName, but no
> schema seems to use it so far.
Is this complex to add
> Having in ldap would be convenient as this permit us to manage from identity.
> But I think a country/city is maybe not the most convenient to store
> information about location as we may have hard time to convert this to spatial
> coordinates. And there is no ( AFAIK ) schema to store coordinate.
We could centralize the Country/City info in LDAP and have a separate db to map
this to coordinates (there are geocoding services that we could cache the
result from - it's only about cities, so that's not hugely extensive data to
Otherwise, yes, having a dedicated small db for this would make it. Do we need
more than these two relationships?
* user lives in place (or even places but that makes it out of LDAP I think,
let's keep it simple)
* place has coordinates
> Storing this in postgres would be nicer from a dev point of view, as postgis is
> a quite powerful extension to postgres. Spatialite could be used for sqlite
> Using some nosql db would also be a option, but I do not know what exist for
I don't have specific knowledge about the best backend for this. So far, I can
just envision the end-result (interactive map + find my neighbours query by
group) and the user info filling.
(In reply to comment #6)
> Another solution would be to add a field for Country in mageia phpbb3 forum
I would keep this out of the forum:
* doesn't require a user to sign in the forum to record this info;
* so we can have simpler, dedicated/optimized queries for extraction.
A small separate app can make it.
Configure bugmail: https://bugs.mageia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
More information about the Mageia-webteam