PostgreSQL

Anatol Belski

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:

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"

Posted by Anatol Belski in Bash, Linux, PostgreSQL, Web at 11:57 | Comments (3) | Trackbacks (0)

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:

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"

Posted by Anatol Belski in Bash, PostgreSQL, Python at 19:37 | Comments (0) | Trackbacks (0)
(Page 1 of 1, totaling 2 entries)

Quicksearch

Categories

Archives