Any thoughts on using KSUID as primary key?

This page summarizes the projects mentioned and recommended in the original post on /r/PostgreSQL
Ksuid Golang Go Uuid Coordination

InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured

  • ksuid

    K-Sortable Globally Unique IDs

    • I'm quite interested in Segment's KSUID for the primary key. At the moment, I'm using UUID and auto incremented bigint in certain tables. UUIDs are ugly and big and auto incremented bigints are prone to error: When I truncate and add new data to table A, a table B which was connected to A with many-to-many relations is truncated as well. When I add 'old' data to table B accidentally, all table A ids are actually wrong but related anyway and showing wrong data instead of null.

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • What happens after 100 years?

    1 project | news.ycombinator.com | 3 Feb 2024

  • A Brief History of the UUID

    1 project | news.ycombinator.com | 6 Aug 2023

  • UUIDs are so much better than autoincrementing ids and it's not even close

    1 project | news.ycombinator.com | 28 Feb 2023

  • Is it bad to use short (20 chars) random strings as primary keys?

    3 projects | /r/golang | 27 Jun 2022

  • New UUID Formats

    2 projects | /r/programming | 12 Jun 2022