RetroFed Forum
Your home away from modern life.
pg_snowflake - extension for creating customisable snowflake ID types
Post Reply
AuthorMessage
Serpent7776 programming.dev Serpent7776@programming.dev
Joined: 2024-01-20
Quote

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);
1   Original
Post Reply
Back to top