Skip to content

Releases: blitss/typeid-postgres

v0.2.0

30 Jun 17:57

Choose a tag to compare

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

v0.2.0-next

30 Jun 17:33

Choose a tag to compare

v0.2.0-next Pre-release
Pre-release

What's Changed

  • fix: try fixing permissions for CI publish (#7) by @blitss
  • fix: dockerfile build for postgres (use prebuilt binaries) (#6) by @blitss

v0.1.0-docker

08 Jul 08:57

Choose a tag to compare

fix: use buildjet to build ARM images

v0.1.0

07 Jul 12:45
c535470

Choose a tag to compare

Merge pull request #5 from blitss/staging

add CI publish