On Fri, 18 Nov 2016 10:22:15 -0800 Jens Alfke <j...@mooseyard.com> wrote:
> You?d have to assign a central ?count server? to hand out consecutive > numbers No. You need only enumerate the sources, and accept that the key is the unique counter from the source plus the centrally assigned source identifier. > You can assign ?peer IDs?, but then you need a sure-fire-unique way > to assign them (using the MAC address is not sure-fire-unique) The sure-fire way to assign them is simple enumeration when they connect to the central server to upload their information. If the "peer" will ever need to retrieve the information, it will need to store its assigned id. Else it's just up to central to keep everything straight. > the system has to keep a persistent counter that can?t ever be rolled > back, even in the case of something like restoring an OS backup. That's just not a problem if each system is in control of its own counter. --jkl _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users