{"repo":"iCyberon/pg_xid","free":true,"listed":false,"github":"https://github.com/iCyberon/pg_xid","clone":"git clone https://github.com/iCyberon/pg_xid.git","description":"pg_xid is a globally unique id generator thought for the web","language":"C","stars":31,"topics":["postgresql","postgresql-extension","xid","unique-identifier","unique-id"],"license":"MIT","category":"databases-storage","readme_excerpt":"pg xid - globally Unique ID Generator for PostgreSQL pg xid is a globally unique ID generator extension for PostgreSQL. It is using Mongo Object ID algorithm to generate globally unique ids: https://docs.mongodb.org/manual/reference/object-id/ - 4-byte value representing the seconds since the Unix epoch, - 3-byte machine identifier, - 2-byte process id, and - 3-byte counter, starting with a random value. The binary representation of the id is compatible with Mongo 12 bytes Object IDs. UUIDs are 16 bytes (128 bits) and 36 chars as string representation. Twitter Snowflake ids are 8 bytes (64 bits) but require machine/data-center configuration and/or central generator servers. xid stands in between with 12 bytes (96 bits). No configuration or central generator server is required so it can be used directly. Name Binary Size Features ------------- ------------- ---------------- [UUID] 16 bytes configuration free, not sortable [shortuuid] 16 bytes configuration free, not sortable [Snowflake] 8 bytes needs machine/DC configuration, needs central server, sortable [MongoID] 12 bytes configuration free, sortable xid 12 bytes configuration free, sortable [UUID]: https://en.wikipedia.org/wiki/Universally unique identifier [shortuuid]: https://github.com/stochastic-technologies/shortuuid [Snowflake]: https://blog.twitter.com/2010/announcing-snowflake [MongoID]: https://docs.mongodb.org/manual/reference/object-id/ Features: - Size: 12 bytes (96 bits), smaller than UUID, larger than snowfla","default_branch":null,"files":null,"tree":[],"storefront":"/r/iCyberon","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/iCyberon/pg_xid/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}