[Mageia-webteam] [Bug 998] O Brother, Where Art Thou?

Romain d'Alverny 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
> too.
> Using some nosql db would also be a option, but I do not know what exist for
> that.

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 mailing list