Showdown: MySQL 8 vs. PostgreSQL 10

Re:Showdown: MySQL 8 vs. PostgreSQL 10 by nvivo on Wednesday May 23, 2018 @06:02PM (#17138780)

MySql doesn't have a UUID data type, the UUID() function returns a varchar. The way you store it is mostly preference and driver defaults. The C# driver used to handle binary(16) as Guids, then they deprecated that in favor of CHAR(36). But when dealing with a bilion rows, each byte counts and I'll favor binary(16) because it's smaller and that helps with the index sizes and memory usage.

[ Parent | on HN ]

Re:Showdown: MySQL 8 vs. PostgreSQL 10 by th3sly on Thursday May 24, 2018 @07:12AM (#17142872)

but it supports conversion to binary (+shuffle to keep order) using "uuid_to_bin"

[ Parent | on HN ]

Re:Showdown: MySQL 8 vs. PostgreSQL 10 by nvivo on Friday May 25, 2018 @06:13AM (#17152044)

Yes, but this is new to mysql 8, which is pretty recent. Also, I always use uuid v4 to explicitly prevent any ordering.

[ Parent | on HN ]