diff options
Diffstat (limited to 'zarb-ml/mageia-webteam/2011-April/000808.html')
-rw-r--r-- | zarb-ml/mageia-webteam/2011-April/000808.html | 108 |
1 files changed, 108 insertions, 0 deletions
diff --git a/zarb-ml/mageia-webteam/2011-April/000808.html b/zarb-ml/mageia-webteam/2011-April/000808.html new file mode 100644 index 000000000..31bcb11c2 --- /dev/null +++ b/zarb-ml/mageia-webteam/2011-April/000808.html @@ -0,0 +1,108 @@ +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> +<HTML> + <HEAD> + <TITLE> [Mageia-webteam] [Bug 998] O Brother, Where Art Thou? + </TITLE> + <LINK REL="Index" HREF="index.html" > + <LINK REL="made" HREF="mailto:mageia-webteam%40mageia.org?Subject=Re%3A%20%5BMageia-webteam%5D%20%5BBug%20998%5D%20O%20Brother%2C%20Where%20Art%20Thou%3F&In-Reply-To=%3C20110427122129.41F6D429F4%40alamut.mageia.org%3E"> + <META NAME="robots" CONTENT="index,nofollow"> + <META http-equiv="Content-Type" content="text/html; charset=us-ascii"> + <LINK REL="Previous" HREF="000807.html"> + <LINK REL="Next" HREF="000809.html"> + </HEAD> + <BODY BGCOLOR="#ffffff"> + <H1>[Mageia-webteam] [Bug 998] O Brother, Where Art Thou?</H1> + <B>Romain d'Alverny</B> + <A HREF="mailto:mageia-webteam%40mageia.org?Subject=Re%3A%20%5BMageia-webteam%5D%20%5BBug%20998%5D%20O%20Brother%2C%20Where%20Art%20Thou%3F&In-Reply-To=%3C20110427122129.41F6D429F4%40alamut.mageia.org%3E" + TITLE="[Mageia-webteam] [Bug 998] O Brother, Where Art Thou?">bugzilla-daemon at mageia.org + </A><BR> + <I>Wed Apr 27 14:21:29 CEST 2011</I> + <P><UL> + <LI>Previous message: <A HREF="000807.html">[Mageia-webteam] [Bug 998] O Brother, Where Art Thou? +</A></li> + <LI>Next message: <A HREF="000809.html">[Mageia-webteam] [Bug 998] O Brother, Where Art Thou? +</A></li> + <LI> <B>Messages sorted by:</B> + <a href="date.html#808">[ date ]</a> + <a href="thread.html#808">[ thread ]</a> + <a href="subject.html#808">[ subject ]</a> + <a href="author.html#808">[ author ]</a> + </LI> + </UL> + <HR> +<!--beginarticle--> +<PRE><A HREF="https://bugs.mageia.org/show_bug.cgi?id=998">https://bugs.mageia.org/show_bug.cgi?id=998</A> + +--- Comment #7 from Romain d'Alverny <<A HREF="https://www.mageia.org/mailman/listinfo/mageia-webteam">rdalverny at gmail.com</A>> 2011-04-27 16:21:29 CEST --- +(In reply to comment #4) +><i> Country/city can already be done with localityName and countryName, but no +</I>><i> schema seems to use it so far. +</I> +Is this complex to add + +><i> Having in ldap would be convenient as this permit us to manage from identity. +</I>><i> But I think a country/city is maybe not the most convenient to store +</I>><i> information about location as we may have hard time to convert this to spatial +</I>><i> coordinates. And there is no ( AFAIK ) schema to store coordinate. +</I> +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 +store). + +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 + +><i> Storing this in postgres would be nicer from a dev point of view, as postgis is +</I>><i> a quite powerful extension to postgres. Spatialite could be used for sqlite +</I>><i> too. +</I>><i> +</I>><i> Using some nosql db would also be a option, but I do not know what exist for +</I>><i> that. +</I> +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) +><i> Another solution would be to add a field for Country in mageia phpbb3 forum +</I> +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: <A HREF="https://bugs.mageia.org/userprefs.cgi?tab=email">https://bugs.mageia.org/userprefs.cgi?tab=email</A> +------- You are receiving this mail because: ------- +You are the assignee for the bug. +</PRE> + + + + + +<!--endarticle--> + <HR> + <P><UL> + <!--threads--> + <LI>Previous message: <A HREF="000807.html">[Mageia-webteam] [Bug 998] O Brother, Where Art Thou? +</A></li> + <LI>Next message: <A HREF="000809.html">[Mageia-webteam] [Bug 998] O Brother, Where Art Thou? +</A></li> + <LI> <B>Messages sorted by:</B> + <a href="date.html#808">[ date ]</a> + <a href="thread.html#808">[ thread ]</a> + <a href="subject.html#808">[ subject ]</a> + <a href="author.html#808">[ author ]</a> + </LI> + </UL> + +<hr> +<a href="https://www.mageia.org/mailman/listinfo/mageia-webteam">More information about the Mageia-webteam +mailing list</a><br> +</body></html> |