UUID vs int for primary key - Which is better (with auto increment), especially if you are scared you'll run out of ids?

This page summarizes the projects mentioned and recommended in the original post on /r/PostgreSQL

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

  • pg_tuid

    generate_tuid function for postgres

    • Use some kind of time-prefix system (e.g. https://github.com/tanglebones/pg_tuid) over uuid.

  • sequential-uuids

    generator of sequential UUIDs

    • Just fyi, UUID in Postgres is not 40 text chars, it's 16 bytes binary and has a canonical text representation. Also, you don't need to use UUIDv4, I am quite partial to: https://github.com/tvondra/sequential-uuids

  • 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

  • A smaller YugabyteDB image for CI/CD

    1 project | dev.to | 27 Apr 2024

  • Pg_tier: Postgres Extension to enable data tiering to AWS S3

    1 project | news.ycombinator.com | 25 Apr 2024

  • Bloom Filter Indexes in PostgreSQL

    2 projects | news.ycombinator.com | 23 Apr 2024

  • Supabase Security Advisor & Performance Advisor

    2 projects | dev.to | 19 Apr 2024

  • From Postgres Proto to TypeScript – new transpiler for tooling

    2 projects | news.ycombinator.com | 31 Mar 2024