1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
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>
|