[OSM-dev] Data corruption :) II

Dave Stubbs osm.list at randomjunk.co.uk
Mon Nov 24 11:51:02 GMT 2008


2008/11/24 Stefan de Konink <stefan at konink.de>:
> Andy Allan wrote:
>>
>> On Mon, Nov 24, 2008 at 11:06 AM, Stefan de Konink <stefan at konink.de>
>> wrote:
>>
>>> Foreign key constraints are part of the typical database; not an API
>>> matter.
>>
>> Yep, but here's where theory and real-life meet. The new API requires
>> changes to the database schema (e.g. new tables for changesets,
>> changing users columns to changesetids on many tables) and you only
>> get a limited number of times you can take the database off-line to
>> implement things before everyone starts getting pissed off. So API0.6
>> includes more than just changes to the XML API.
>
> Are you saying you are not more pissing people off with bad data than with
> fixing all constraint problems; and adding a foreign key constraints?
>

Pissed off count:

API read-only for a day = 1000 people
Occasional referential integrity problems = 1 (you :-)

Seriously, there aren't that many problems considering. It's clearly
not ideal, hence why it's being fixed. But the fix isn't as trivial as
you make it sound, so it's been agreed to fix a few other problems and
introduce some extra useful features at the same time, thus minimising
down-time for everybody.

Dave




More information about the dev mailing list