Enhancement: Consider supporting UUIDv7 and/or ULID

litestar-org / advanced-alchemy

A carefully crafted, thoroughly tested, optimized companion library for SQLAlchemy

http://docs.advanced-alchemy.litestar.dev/

MIT License

218 stars 26 forks source link

Enhancement: Consider supporting UUIDv7 and/or ULID #25

Closed cofin closed 7 months ago

cofin commented 1 year ago

Summary

Determine if adding a ULID data type is feasible at this point.

Basic Example

No response

Drawbacks and Impact

No response

Unresolved questions

No response

Funding

If you would like to see an issue prioritized, make a pledge towards it!
We receive the pledge once the issue is completed & verified

halms commented 11 months ago

Just wanted to throw in the room that maybe you want to also/instead consider the newly proposed UUIDv7?

There is a RFC draft (already rather close to acceptance) that standardizes these.

From what I understand, it is very similar to ULID, except for the 6 bits that are reserved for UUID version and variant and therefore 74 random bits instead of 80.