So what might be not so good with UUIDs? After watching how people work with our systems for 26 years (most of it without UUID capability) I noticed that they often referred to the record by the Unique LongInt we created for each record. For the first year we hid our unique ID - why would they want that. Then we exposed it to the admins for a year. Then through popular request we exposed it to everyone. Then we not only exposed it but changed the name of the display of the field to JonokeMed #. Referring to record # 150, or 275,983 is much easier than referring to a long UUID.
A UUID just is not a workable solution for that - at least in my mind. Therefore our solution today is that we do use UUIDs for all records for the reason of any possibility of merging records. We have had clients move across the Canada to join up with another client, and they need the records merged. Arrh a lot of work to write that the first time, and then continue to support it with each new table. We use the UUID as the Primary Key record, but still have a Key field. This number is exposed to the end users to use as they wish. On another note, we assign a counter ourselves (not auto generated). There are times where we reset counters and being able to do that is great. Jody Bevan ARGUS Productions Inc. Developer Argus Productions Inc. <https://www.facebook.com/ArgusProductions/> > On Aug 4, 2017, at 7:40 AM, Keith Culotta via 4D_Tech <[email protected]> > wrote: > > The UUID has been the easiest to work with. When a customer needs a > recognizable ID, an auto-incremented Longint can be added to the table. > UUIDs are perfect for avoiding conflicts when updating or exchanging records > between databases. They can also be used as Process IDs or SVG IDs when one > of those is linked to a record. All this can be accomplished with a Longint, > but it's more straightforward with UUIDs. > > Keith - CDI > >> On Aug 4, 2017, at 3:27 AM, stardata.info via 4D_Tech <[email protected]> >> wrote: >> >> Hi All, >> >> Someone can explain when is better use UUID and when Longint field in >> primary key? >> >> Thanks >> Ferdinando ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
