[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