pg-xid
pg-xid is a globally unique id generator for postgres (by modfin)
pg_tuid
generate_tuid function for postgres (by tanglebones)
pg-xid | pg_tuid | |
---|---|---|
2 | 4 | |
79 | 115 | |
- | - | |
4.0 | 0.0 | |
27 days ago | over 1 year ago | |
Go | PLpgSQL | |
MIT License | MIT License |
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-xid
Posts with mentions or reviews of pg-xid.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-09-28.
-
PostgreSQL reached maximum value of sequence (2147483627)
Or even xid https://github.com/modfin/pg-xid
-
Introducing pg_idkit: an extension for generating lexicographically sortable UUIDs (UUIDv6-8, CUID, Timeflake) in Postgres
If I only need/want xid, how this compares to https://github.com/modfin/pg-xid ?
pg_tuid
Posts with mentions or reviews of pg_tuid.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-09-28.
-
PostgreSQL reached maximum value of sequence (2147483627)
If you don't want to wait on official UUID6/7/8 support you can roll your own. I've got a version here.
- Custom unique PK against generated UUIDV4 performance.
-
Understanding UUIDs, ULIDs and String Representations
You can also time prefix uuids via something like https://github.com/tanglebones/pg_tuid.
-
UUID vs int for primary key - Which is better (with auto increment), especially if you are scared you'll run out of ids?
Use some kind of time-prefix system (e.g. https://github.com/tanglebones/pg_tuid) over uuid.
What are some alternatives?
When comparing pg-xid and pg_tuid you can also consider the following projects:
SQLBoiler - Generate a Go ORM tailored to your database schema.
sequential-uuids - generator of sequential UUIDs
bytebase - The GitHub/GitLab for database DevOps. World's most advanced database DevOps and CI/CD for Developer, DBA and Platform Engineering teams.