pg_snowflake - extension for creating customisable snowflake ID types

a year ago by Serpent7776 to c/postgresql

Postgres extension creating customisable snowflake IDs - serpent7776/pg_snowflake

Example usage:

-- Register with default settings (41 timestamp bits, 10 type bits, 12 counter bits)
CALL snowflake.register('user_id');

-- Generate a user ID
SELECT snowflake.generate_user_id(now(), 1, 1);

-- Register with custom bit allocation
CALL snowflake.register('order_id', 42, 8, 13);

-- Generate an order ID with specific type and counter
SELECT snowflake.generate_order_id('2023-12-01 10:30:00 UTC', 5, 1000);
postgresql
postgresql

@programming.dev

login for more options
2251
203
21

The world's most advanced open source relational database

Project
Events
Podcasts
Related Fediverse communities

go to feed...