Awesome
Universally Unique Lexicographically Sortable Identifier generate for PostgreSQL
Extension for generate ULIDs.
Usage
| Function | Return Type | Example | Result |
|---|---|---|---|
| ulid_generate() | uuid | select ulid_generate() | 0177a26f-6db1-11bf-54e2-e0f29ca6fc72 |
| ulid_to_string(id uuid) | text | select ulid_to_string(ulid_generate()) | 01EZ37SMZRKB68B5CPZZ56MBQQ |
| ulid_from_string(id text) | uuid | select ulid_from_string('01EZ37SMZRKB68B5CPZZ56MBQQ') | 0177c67c-d3f8-9acc-8595-96ffca6a2ef7 |
Build
mkdir build
cd build
cmake -DCMAKE_INSTALL_PREFIX=/usr -DCMAKE_BUILD_TYPE=Release ..
make
make install
Examples
CREATE EXTENSION ulid;
-- ...
CREATE TABLE foo
(
id uuid default ulid_generate() primary key,
value bigint not null
);
-- ...
INSERT INTO foo(value) SELECT generate_series(1, 1000) as value ;
-- ...
SELECT ulid_to_string(id), value FROM foo ORDER BY id LIMIT 10;
Build in docker
docker build -f Dockerfile.debian -t deb .
sudo find /var/lib/docker/ -name pg-ulid_1.1-1_amd64.deb -type f | xargs sudo ls -hrt | tail -1 | xargs -i sudo cp -v '{}' .