On Fri, Nov 24, 2017 at 9:51 AM, R Smith <rsm...@rsweb.co.za> wrote: > I'm not even a big fan of Integer IDs, I think codes / UUIDs are best, but > obviously the speed/size gain with an integer key (especially INTEGER > PRIMARY KEY row-id alias in SQLite) can't be ignored. > > Disclaimer: This is only my opinion, well, I'm not completely alone in it, > but it is still an opinion and not a general SQL prescription.
Many opinions on this everywhere, and discussed a few times on this list as well. Here's one among a million: https://blog.codinghorror.com/primary-keys-ids-versus-guids/ --DD PS: I use guids are surrogate keys (always with a companion natural key, aka unique index, often composite). _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
