UUIDv7 is coming in PostgreSQL 17

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

InfluxDB – Built for High-Performance Time Series Workloads
InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
  1. nanoid

    A tiny (124 bytes), secure, URL-friendly, unique string ID generator for JavaScript

    No thread about UUID is complete without a plug for NanoID! https://github.com/ai/nanoid/blob/main/README.md

  2. InfluxDB

    InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.

    InfluxDB logo
  3. pg_idkit

    Postgres extension for generating UUIDs

    If you like this (I do very much), you might also like pg_idkit[0] which is a little extension with a bunch of other kinds of IDs that you can generate inside PG, thanks to the seriously awesome pgrx[1] and Rust.

    [0]: https://github.com/VADOSWARE/pg_idkit

    [1]: https://github.com/pgcentralfoundation/pgrx

  4. pgrx

    Build Postgres Extensions with Rust!

    If you like this (I do very much), you might also like pg_idkit[0] which is a little extension with a bunch of other kinds of IDs that you can generate inside PG, thanks to the seriously awesome pgrx[1] and Rust.

    [0]: https://github.com/VADOSWARE/pg_idkit

    [1]: https://github.com/pgcentralfoundation/pgrx

  5. discussion

    > Integers don't scale because you need a central server to keep track of the next integer in the sequence.

    They most assuredly do scale. [0]

    Also, Slack is built on MySQL + Vitess [1], the same system behind PlanetScale, which internally uses integer IDs [2].

    [0]: https://www.enterprisedb.com/docs/pgd/latest/sequences/#glob...

    [1]: https://slack.engineering/scaling-datastores-at-slack-with-v...

    [2]: https://github.com/planetscale/discussion/discussions/366

  6. pg_uuidv7

    A tiny Postgres extension to create version 7 UUIDs

    https://github.com/fboulnois/pg_uuidv7

    It's slightly different from recommendations by draft RFC version (there's no counter), but fully within spec requirements. From practical point there's no difference at all.

  7. SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub 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

  • SQL as API

    7 projects | news.ycombinator.com | 25 Dec 2023
  • Pgrx – Build Postgres Extensions with Rust

    1 project | news.ycombinator.com | 8 Oct 2023
  • PGRX v0.9.7

    1 project | /r/rust | 29 Jun 2023
  • Let's make PostgreSQL multi-threaded (pgsql-hackers)

    1 project | /r/PostgreSQL | 18 Jun 2023
  • Build high-performance functions in Rust on Amazon RDS for PostgreSQL

    2 projects | /r/rust | 24 May 2023

Did you know that Rust is
the 5th most popular programming language
based on number of references?