News Score: Score the News, Sort the News, Rewrite the Headlines

PostgreSQL and UUID as primary key

UUIDs are often used as database table primary keys. They are easy to generate, easy to share between distributed systems and guarantee uniqueness.Considering the size of UUID it is questionable if it is a right choice, but often it is not up to us to decide.This article does not focus on "if UUID is the right format for a key", but how to use UUID as a primary key with PostgreSQL efficiently.Postgres Data Types for UUID ​UUID can be seen as a string and it may be tempting to store them as such....

Read more at maciejwalkowiak.com

© News Score  score the news, sort the news, rewrite the headlines