A note on the synchronization issue - I decided to store a GUID in each record, so that if someone adds a new record to your website data, when you synchronize with your local data (which might have the same integer id key), the code can check if it’s actually the same record, and renumber one of them if not (and any related records). That way it can still just use an integer for the key field.

There was some discussion about using GUIDs as primary keys for Rails, but ugh, that would not be pleasant…

Tags: No Tags