Thursday, June 3. 2010
Using great Geonames database for geographical data handling
This time I needed some geographical data evaluation for one of my current projects. The data used to be opensource and as possible qualitative and complete. After spending some time in front of the famous search engine window there was a solution:
http://www.geonames.org/
That's the first sentence from the site:
Geonames is used by number of sites. Besides data it has also web services and code libraries in many programming languages to access them.
http://www.geonames.org/
That's the first sentence from the site:
The GeoNames geographical database covers all countries and contains over eight million placenames that are available for download free of charge.
Geonames is used by number of sites. Besides data it has also web services and code libraries in many programming languages to access them.
Continue reading "Using great Geonames database for geographical data handling"
Sunday, April 27. 2008
Don't underestimate SQL
Hi there.
The things I wanna to talk about today are - relational databases building. Particularly I would discuss such the attainments of relational sql as join and subselect. For my experiment I'll take PostgreSQL and Python.
So, lets start:
The things I wanna to talk about today are - relational databases building. Particularly I would discuss such the attainments of relational sql as join and subselect. For my experiment I'll take PostgreSQL and Python.
So, lets start:
BASH:
user@host~$ su postgres postgres@host~$ createuser -P test Enter password for new role: Enter it again: Shall the new role be a superuser? (y/n) n Shall the new role be allowed to create more new roles? (y/n) n postgres@host~$ createdb test postgres@host~$ exit
Continue reading "Don't underestimate SQL"