[Legal-general] Initial Version of OSMPD Database Schema

[Andy Allan]

On Wed, Dec 24, 2008 at 4:48 PM, Sunburned Surveyor
<sunburned.surveyor at gmail.com> wrote:
> I've created my first version of a schema for the OSMPD repository
> database. It follows the same concepts of the database schema
> described on the OSM wiki:
>
> http://wiki.openstreetmap.org/wiki/Database_schema
>
> Most of my modifications refactor the database schema to be more
> normalized and consistent. (For example, the OSM wiki page says that
> node tags are stored in the row for each node, while way tags are
> stored in a separate table. In my schema, the node tags are also

[...]

Hi Landon,

There's nothing wrong with reinventing the wheel in the opensource
environment, but I would encourage you to go the whole hog with the
OSM stack. Remember that there's many more of us working on it that
you can reap the rewards from, rather than struggling with all the
same issues but this time in perl.

In any case, I'd strongly recommend you use the db schema from OSM API
0.6 - it fixes many of the problems that hinder OSM today and has many
added features (such as foreign keys). I'd hate to see you basing a
project off the 0.5 sql schema, again because we've had many devs
pouring over it since it was deployed making drastic improvements that
you'll need to, sooner or later, also do. It may as well be sooner!

Cheers,
Andy