[OSM-dev] Rantings about API 0.6

Iván Sánchez Ortega ivan at sanchezortega.es
Wed Feb 11 13:55:47 GMT 2009


El Miércoles, 11 de Febrero de 2009, Matt Amos escribió:
> > Rails guys: we're using InnoDB tables for a reason, you know.
>
> yes - for transactions. the foreign keys are a plus, but they can't do
> all the checking (relation_members, changeset timeouts, etc...).

For relations: see my reply to Stefan.

For changeset timeouts: triggers, triggers, triggers. Or just initialize the 
closing time of a changeset to a date in the future.

> also, it becomes a pain for the client to distinguish between a mysql
> error because of an invalid foreign key reference, a mysql error
> because of a server code bug and a mysql error because the db server
> died or the network went down.

Can't Rails check the error number returned by MySQL?

-- 
----------------------------------
Iván Sánchez Ortega <ivan at sanchezortega.es>

Q:	How many Harvard MBA's does it take to screw in a light bulb?
A:	Just one.  He grasps it firmly and the universe revolves around him.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part.
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20090211/eccd9b02/attachment.pgp>


More information about the dev mailing list