> Trivial. Don't use sqlite's "integer primary key", but instead globally > unique identifiers. > > http://cr.yp.to/proto/maildir.html
Nice link, thanks! > > Has good hints on where to get your globally unique identifiers. > > Or translate the original keys to globally unique identifiers within a > transaction before loading into your master database. Works fine if you don't have any overlap between products on the two systems. You might get the same product twice, each with a different global unique number.
