On Wed, Mar 25, 2009 at 7:06 PM, Stefan de Konink <[email protected]> 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 _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
