Skip to content

v0.2.0

Latest

Choose a tag to compare

@github-actions github-actions released this 30 Jun 17:57

What's Changed

  • added postgres@17 support, dropped old 11/12 versions
  • added new utility functions
  • updated docs
  • better error messages
  • new utility functions

typeid_generate_nil()

Generate TypeIDs with empty prefix (UUID-only format):

SELECT typeid_generate_nil(); -- Returns: 01h455vb4pex5vsknk084sn02q

typeid_is_valid(text)

Validate TypeID strings without parsing:

SELECT typeid_is_valid('user_01h455vb4pex5vsknk084sn02q'); -- true
SELECT typeid_is_valid('invalid_id'); -- false

typeid_has_prefix(typeid, text)

Check if TypeID has specific prefix:

SELECT * FROM users WHERE typeid_has_prefix(id, 'user');

typeid_is_nil_prefix(typeid)

Check if TypeID has empty prefix:

SELECT typeid_is_nil_prefix(typeid_generate_nil()); -- true

typeid_generate_batch(prefix, count)

Generate multiple TypeIDs efficiently:

SELECT unnest(typeid_generate_batch('user', 5));
-- Returns 5 TypeIDs with 'user' prefix

Full Changelog: v0.1.0-docker...v0.2.0