Re: [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea

On 2016-03-25 19:56, Ted Roche wrote:

Satellite offices. With UUIDs, each app can create *unique* IDs that don't have to be changed when you merge IDs from multiple sources. Solves problems with roaming salesman, remote offices, off-line use, etc.

This is why I went with the app-generated character keys this time around instead of the integer keys I'd used since 13+ years ago. Still, the 16-byte keys should suffice for this.