Skip to content

Triple-networks

Rudger Gravestein

  • Home
  • Blog
  • Portfolio
  • Magento
  • Uptime
  • Contact

Tag: storage

UUID storage in MySQL

TLDR;

You can store a UUID safely as a “Binary 16”, instead of a “Varchar 36”.

If you still require a human-readable column, its possible to use a “generated” column (from MySQL 5.7 and up):

Source: https://mysqlserverteam.com/storing-uuid-values-in-mysql-tables/

additional info for MySQL 8.0 – https://mysqlserverteam.com/mysql-8-0-uuid-support/

Share this:

  • Click to share on Facebook (Opens in new window) Facebook
  • Click to share on LinkedIn (Opens in new window) LinkedIn
  • Click to share on X (Opens in new window) X

Like this:

Like Loading...
Author RudgerPosted on 15 January 202015 January 2020Categories Code, DevelopmentTags MySQL, storage, UUIDLeave a comment on UUID storage in MySQL
  • View rudgergravestein’s profile on LinkedIn
  • View Rud5G’s profile on GitHub

Recent Posts

  • AWS Shared Responsibility Model
  • Types of API pagination
  • A must read about color
  • Introduction to D-Bus
  • Architecture decisions

Top Posts

  • AWS Shared Responsibility Model
  • Types of API pagination
  • A must read about color
  • Introduction to D-Bus
  • Architecture decisions
  • AWS Service costs: S3
  • AWS costs: Services
  • Follow-up on a favorite post on serverless
  • Still one of my favorite insights on serverless

Receive notifications of new posts by mail.

  • Home
  • Blog
  • Portfolio
  • Magento
  • Uptime
  • Contact
Triple-networks Proudly powered by WordPress
%d