drawdb icon indicating copy to clipboard operation
drawdb copied to clipboard

Add Support for ULID

Open tiagoandrepro opened this issue 1 year ago • 2 comments

Currently, DrawDB does not offer support for ULID (Universally Unique Lexicographically Sortable Identifier). This limits performance optimization opportunities when working with databases that require efficient indexing and lexicographic sorting. UUIDs, while functional, can lead to slower queries and less efficient data management.

I would like to see ULID support added to DrawDB. ULIDs maintain the same uniqueness guarantees as UUIDs but improve query performance by being sortable. This feature would enhance the overall efficiency of database management, especially in scenarios with large datasets.

Adding ULID support would align with DrawDB’s commitment to efficiency and modern development practices, improving the experience for developers.

tiagoandrepro avatar Oct 28 '24 18:10 tiagoandrepro

That is really a nice input @tiagoandrepro . I will like to proceed with this one.

sudhirVoid avatar Nov 29 '24 19:11 sudhirVoid

@tiagoandrepro In theory you could store a ULID value in a UUID column since they have the same size I think (but you need to store it's binary data, not the string format with dashes). If not, you could probably store it as bytes.

Adding a ULID data type to DrawDB would only make sense if your database supports the ULID data type (natively or via a plugin) ,i.e. CREATE TABLE users (id ULID PRIMARY KEY, ...);.

HeCorr avatar Feb 02 '25 03:02 HeCorr