a/s/l?

[Paul Richards]

--On Saturday, June 16, 2001 17:01:25 +0100 Andrew Boothman
<andrew at ukug.uk.FreeBSD.org> wrote:

> That's quite a cool idea actually. xearth already has a file with the
> coordinates of some committers on it doen't it? So you'd have a starting
> point already.
> 
> I'm not really sure how you would go about constructing a system like
> that, maybe some PHP? What's Postgresql like? I've used mysql quite a bit
> and am used to that, but my knowledge doesn't really extend beyond the
> basic SQL statements.

I'd use PHP if I was doing it myself, but I don't have time right now.
Postgresql is as easy to use as MySQL, it has the same level of support in
PHP, Perl etc, the PHP API calls are different (functionally similar
though).

It wouldn't be that hard to do this, a simple schema would get us started

Name,
Address details,
entry type (user, company etc)
co-ordinates

and then some way of displaying it on a map, which would be the hard part,
though a straighforward search interface would probably do to get the ball
rolling.

Any students out there looking for something to do over the summer? I'll
"sponsor" the project but I don't have time to do the work myself.


Paul.