pgsql-ulid

KO | EN

gitlite — search

#javascript #python #hacktoberfest #react #golang #go #android #nodejs #macos #awesome #kubernetes #mcp #openai #open-source

(★ 39)

Postgres helper functions for converting between ULID and UUID.

pgsql-ulid Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# pgsql-ulid
Postgres helper functions for converting between [ULID](https://github.com/ulid/spec) and UUID.

Your application layer may deal exclusively with transformation of ULIDs, so what do you do when you need to query your DB for something? That's where these handy functions come in!

## Example
[https://dbfiddle.uk/-o7J4c0_](https://dbfiddle.uk/-o7J4c0_)
## Usage

`ulid_to_uuid(ulid text) RETURNS uuid`

Takes a ULID string and returns a UUID.
```SQL
SELECT ulid_to_uuid('01FGB414J8PPBVHBMHGSXGS21C');

-- 017c1640-9248-b597-b8ae-91867b0c882c
```

`uuid_to_ulid(id uuid) RETURNS text`

Takes a UUID and returns a ULID string.
```SQL
SELECT uuid_to_ulid('017c1640-9248-b597-b8ae-91867b0c882c');

-- 01FGB414J8PPBVHBMHGSXGS21C
```

`parse_ulid(ulid text) RETURNS bytea`

Takes a ULID string and returns a Byte Array. In case you need the raw bytes for something else.

## Inspirations
- https://github.com/geckoboard/pgulid - Provides generation of ULIDs in Postgres.
- https://github.com/oklog/ulid - Logic for transforming ULID text into bytes.

pgsql-ulid

pgsql-ulid Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

pgsql-ulid

pgsql-ulid Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README