the outdating is not so the problem for me because I only want to make
my first steps in postgres on this way (I hope I find time).
For regular updating we should wait for our db-server.
But it would be nice if you can tell me how you contact the database, in
which language your scripts are and where they are.
So why doesn't
Tim Alder schrieb:
Nice to see the tool of Peter Körner.
So it seems possible to run scripts on cassini and connect to the
database (postgres or mysql?).
Could somebody please document who it works.
My trys to start my php-scripts from cassini and to start psql were
I also want to develop a little text based tool that gives back all
street names in alphabetic order which are in a bbox or (more difficult)
in a way/relation.
Such a street list is part of each paper city map and the streetnames
could be linked to things like Query-to-map.
Whats the schedule for our database-server? The last date for start that
I know is beginning of august.
A question to Avar: Would it be possible for you to rendering easily
also the name-variations?
We had a talk in Dresden that the "old-name"-tag would be interesting,
especcially in germany with its changefull in history.
But to push this feature a map with it would be nice.
It is possible to connect to the local postgres-db, although it is very
outdated (it's from 2009-07-15) and not updated at the moment. It is
also possible to connect to the sql-servers.
Tools may be written in php, perl or python, although i can't guarantee
that everything will work in every language right now, but i don't see
any problems that can't be resolve by a ticket in jira.
I think i could write a beginners-guide on how to use cassini (I'd
) but at the
moment it's not too useful as the main database is not updated.
I worked around this by once doing an import of all country-nodes from
the (outdated) postgresql-database into my mysql-db and have them
checked regularly against the api. This works for countries (no support
for new nodes, only ~230 nodes to fetch) but if you'd like to do
something similar on a city-level, this wouldn't work anymore.
So what is needed to get the database updated? I don't think we'll need
a root-user to do this, just someone with write-perms on /sql and maybe
a file under /etc/cron.d/. I never set up a postgres-db with
hourly/minutely diff-support but I think I could give it a try, if this
would be ok. On the other hand, if someone already has experience whith
such a setup, he's welcome to do this.
Maps-l mailing list