pg_snowflake - extension for creating customisable snowflake ID types
a year ago by Serpent7776 to c/postgresql
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);
@programming.dev
The world's most advanced open source relational database
go to feed...
@programming.dev
The world's most advanced open source relational database
go to feed...