{"repo":"andrielfn/pg-ulid","free":true,"listed":false,"github":"https://github.com/andrielfn/pg-ulid","clone":"git clone https://github.com/andrielfn/pg-ulid.git","description":"PostgreSQL extension for ULID","language":"C","stars":117,"topics":["extension","postgres","postgresql","ulid"],"license":"MIT","category":"databases-storage","readme_excerpt":"Postgres ULID extension This extension enables efficient storage and manipulation of 128-bit Universal Unique Identifiers (ULIDs). It introduces the 'ulid' data type, along with functions, operators, and indexing using hash and btree operator classes. Why use this extension? The ULID specification provides an excellent alternative to UUIDs, offering sortable and timestamp-inclusive 128-bit identifiers. This extension for PostgreSQL offers several benefits over other ULID implementations: - Blazing-fast performance: Implemented in C , ensuring high-speed operations. - ULID generation: Built-in support for generating ULIDs using the gen ulid() function. - Monotonic generation: gen ulid() is monotonic within each millisecond — IDs minted in the same millisecond from one connection are strictly increasing, never colliding, preserving sort order under heavy insert load. - Seamless integration: Utilizes the PostgreSQL extension framework , making installation and usage hassle-free. - Efficient storage: Employs a binary storage format , resulting in more efficient storage compared to using TEXT for ULIDs. - Native data type: Introduces the ULID data type , enabling the creation of ULID columns. - Indexing support: Enables the creation of indexes on ULID columns for improved query performance. - Timestamp casting: Supports casting ULIDs to timestamps for flexible data manipulation. - UUID casting: Casts losslessly between ulid and the native uuid type, making it easy to migrate exist","default_branch":null,"files":null,"tree":[],"storefront":"/r/andrielfn","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/andrielfn/pg-ulid/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."}