Re:UUID, serial or identity columns for PostgreSQL auto-gene...
by lazide on Monday May 31, 2021 @06:21PM
(#27348697)
There definitely are people out there in this thread proposing clients be able provide UUIDs. I’ve seen it elsewhere too.
I’ve also personally experienced UUID collisions due to badly set up VM environments under Windows. It isn’t a good idea to blindly trust any value - and that includes supposedly ‘never collide’ id’s like UUID.
For what it’s worth, I also had the joy of debugging someone’s distributed hash table that was using md5 as the hash bucket key (this was... 2 decades ago?) and had no way to handle collisions because obviously that is impossible.
Re:UUID, serial or identity columns for PostgreSQL auto-gene...
by NicoJuicy on Monday May 31, 2021 @09:24PM
(#27349870)
This seems more an issue of the libraries random generator to form uuids.
Eg. I use guids ( .net) and i have never seen an issue.
Re:UUID, serial or identity columns for PostgreSQL auto-gene...
by inopinatus on Monday May 31, 2021 @06:20PM
(#27348681)
I getcha, but these days the ambit reach of "application" extends to Javascript executing client-side in an environment that's basically overrun with lions/tigers/bears, and I'll suggest that's particularly a consideration when the front-end is a SPA participating in a CQRS/event-sourced overall application architecture.
Re:UUID, serial or identity columns for PostgreSQL auto-gene...
by tomnipotent on Monday May 31, 2021 @08:12PM
(#27349475)
For perspective, the npm uuid package is now being downloaded ~50M/week. It's usage is ubiquitous at this point, on any platform JS is running.
The concepts he's talking about are required for cqrs. Which is a popular concept applied with mostly DDD or microservices.