pg_uuidv7
A tiny Postgres extension to create version 7 UUIDs (by fboulnois)
pg_xxhash
xxhash functions for PostgreSQL (by hatarist)
pg_uuidv7 | pg_xxhash | |
---|---|---|
4 | 1 | |
242 | 6 | |
- | - | |
7.4 | 10.0 | |
about 2 months ago | over 2 years ago | |
C | C | |
Mozilla Public License 2.0 | GNU General Public License v3.0 or later |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
pg_uuidv7
Posts with mentions or reviews of pg_uuidv7.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2024-02-23.
-
Shrink UUIDs with PostgreSQL or Ruby
Unfortunately, as of PostgreSQL 16, UUIDv7 are not yet supported out of the box. For the time being, use an extension such as pg_uuidv7 or pg_idkit to generate UUIDv7 e.g. as default primary key when you CREATE new records.
-
UUIDv7 is coming in PostgreSQL 17
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.
- Are there trusted non-cryptographic hashing extensions for Postgresql?
-
UUIDs are obsolete in the age of Docker
Sometimes, I am amazed about what gets on the front page of ycombinator.
TLDR: Don't use UUID v1, since its entropy is based on the Mac address, if your cloud provider is generating the same mac addresses for all your containers.
To say not use UUID's it makes no sense. Use UUIDv7, use them in postgres https://github.com/fboulnois/pg_uuidv7 have fun :)
pg_xxhash
Posts with mentions or reviews of pg_xxhash.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-12-07.
-
Are there trusted non-cryptographic hashing extensions for Postgresql?
I have also found some random Github repositories like pghashlib and pg_xxhash but they don't seem super popular and I'm hesitant to use them in a production system (pg_xxhash specifically disuades from using it in a serious system).
What are some alternatives?
When comparing pg_uuidv7 and pg_xxhash you can also consider the following projects:
pg_math - pg_math extension to support statistical distribution functions for PostgreSQL
pghashlib - Stable hash functions for Postgres
vasco - vasco: Discover hidden patterns in your Postgres data