Live data from Hacker News

World.db - A Free Open World Database and Schema

github.com

11–20 of 23 posts

Re: World.db - A Free Open World Database and Schema

#11
post #2

What's the advantage of this over the geonames database (CC-BY) which seems to be more comprehensive ?

Probably licensing. This one's public domain. It is indeed extremely incomplete.

The GeoNames geographical database is available for download free of charge under a creative commons attribution license.

Is that too restrictive?

Re: World.db - A Free Open World Database and Schema

#13
Why is this a ruby project, and not just a plain files to create the tables, and insert the values?

Also, please teach him something about database normalization. e.g. capital should not be a flag of cities, but a foreign key of regions and countries. Cities, Regions and countries should be combined into one table, with a foreign keys pointing up and down the chain, from world down to suburb level.

Re: World.db - A Free Open World Database and Schema

#14

Earlier quoted context omitted.

Probably licensing. This one's public domain. It is indeed extremely incomplete.

The GeoNames geographical database is available for download free of charge under a creative commons attribution license. Is that too restrictive?

> Is that too restrictive?

For someone who doesn't want to have a "credits" page in their app, sure.

Re: World.db - A Free Open World Database and Schema

#19

Earlier quoted context omitted.

you'd still get CC-BY data from wikipedia, rather than public domain, I believe

Not if it's just data. http://en.wikipedia.org/wiki/Feist_v._Rural

that is interesting, but it would imply that geonames' data copyright is is also invalid, so there would be no need to scrape wikipedia.

Re: World.db - A Free Open World Database and Schema

#20
post #16

If the Heroku app is up to date, there are only 62 countries and 126 cities and all names are in German. I think this should have been mentioned in the Github page.

Agree, somehow incomplete info of the current status of the project. It can be ambitious and in an early stage but just say it!
Post reply on HN