If sequential IDs (int, bigint) are fast and small, why companies like Segment and Stripe using GUID?

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

    • But on the other hand Stripe is using IDs like ch_3L9o8x2eZvKYlo2C0UFoBfSp, in_1L9o8y2eZvKYlo2CMcdIG9aZ. I'm guessing this is prefixed GUID or something. So to store this in Postgres, I have to use textor varchar. Segment's also developed their own algorithm KSUID. And they say it's super fast with trillions of rows.

  • 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