[OSM-dev] OSM Fixer [Sequal]

[Matt Amos]

On Wed, Mar 25, 2009 at 7:06 PM, Stefan de Konink <stefan at konink.de> wrote:
> Matt Amos wrote:
>> the issue with things referencing deleted items should go away because
>> the transactions wrap the used-by checks.
>
> True; But isn't Rails doing that now too? [I am talking about the main
> database]

no. the current mysql database uses a mixture of myisam and innodb
tables which prevents us from (easily) adding transactions (or,
indeed, foreign keys). the choice of myisam for some tables is
presumably historical, although there might be some technical reasons
too.

if we were to convert all the tables to innodb we could add
transactions, but this would mean significant API downtime. happy for
us, then, that we're rolling out 0.6 Real Soon Now with all that
transactional and FK goodness and a bunch of other cool stuff too!

cheers,

matt