TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

Do you really need a UUID/GUID?

1 pointsby pavanlimoover 9 years ago

1 comment

wtbobover 9 years ago
&gt; Databases like MySQL do not have a native implementation of the data structure.<p>Postgres has a native UUID type (I don&#x27;t know the details of its storage representation, though). Using MySQL by choice in 2015 is a bit of a design smell, though.<p>&gt; This means the column that carries the value must at least be 36 characters (VARCHAR(36)). When you consider the text encoding (e.g. MySQL character set) used to represent strings, this could mean 2-3 bytes per character (if using UTF-8).<p>Ummm, this is just wrong. The UTF-8 representations of [0-9A-Ba-b] are all single bytes.
评论 #10392634 未加载