Showdown: MySQL 8 vs. PostgreSQL 10

Re:Showdown: MySQL 8 vs. PostgreSQL 10 by firenotire on Wednesday May 23, 2018 @12:44PM (#17135597)

Can't you just enforce uniqueness anyways for that field? And then have the client retry?

[ Parent | on HN ]

Re:Showdown: MySQL 8 vs. PostgreSQL 10 by foxylion on Wednesday May 23, 2018 @12:46PM (#17135618)

Yes, we are planning to just fail, as the chance of a collision is really low and the user will then be able to just retry creating the object.

[ Parent | on HN ]

Re:Showdown: MySQL 8 vs. PostgreSQL 10 by zzzcpan on Wednesday May 23, 2018 @12:59PM (#17135741)

You can easily guarantee uniqueness within the system without any coordination.

[ Parent | on HN ]