[OSM-dev] Rantings about API 0.6
Stefan de Konink
stefan at konink.de
Wed Feb 11 13:42:20 GMT 2009
Frederik Ramm wrote:
> Iván Sánchez Ortega wrote:
>>> all this should be mostly handled by the db server with appropriate
>>> foreign key constraints, not by the application code
>> +1
>>
>> Rails guys: we're using InnoDB tables for a reason, you know.
>
> I'm not a foreign keys guru myself but I think it may be difficult to
> have one with the relation_members as designed currently.
I have solved that by splitting the members in 3 distinct tables; but
placed an explicit index so I can always retrieve the members in the
order they were inserted.
Stefan
More information about the dev
mailing list