jakob / jakob/Postico

Feature Request: Display UUID columns in Crockford Base32 (for ULID)

Open
#845 1 comment 2 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
485
Forks
8
PR merge metrics
No merged PRs in 30d

Description

The recent addition of displaying `bytea` values in Crockford Base32 is great. Would it also be possible to do the same for `uuid` values? Since UUID and ULID are byte-compatible, it's becoming common to store ULIDs in UUID columns. The only friction is having to convert between the two display formats when switching between Postico and my app's console and logs, which display ULIDs. For example, my app displays `01GTGATJT0JXE9CFBXVQ0ZFWG6`, but Postico displays `0186a0ad-4b40-975c-963d-7dddc1f7f206`. They're the same value in the DB, but just displayed differently between my app and Postico.

It would be great if there was an option to display `uuid` columns in Crockford Base32, whether globally or per column.

Thanks for making Postico!

Contributor guide

No contributing guide indexed for this repository

Research direction

Review Postico's existing bytea Crockford Base32 display behavior and its handling of uuid columns; the issue names no implementation files or tests. The work is complete when UUID values can be displayed as matching Crockford Base32 ULIDs through a global or per-column option.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql
Domain
database, desktop
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.