3 ms·
One impact of the_mitsuhiko's second point is during debugging. Usually if you see an id in your http logs you can simply search your database for that id. The
by kevlened 1y ago
One impact of the_mitsuhiko's second point is during debugging.
Usually if you see an id in your http logs you can simply search your database for that id. The v4 to v7 indirection creates a small inconvenience.
The mismatch may be resolved if this was available as a fully transparent database optimization.
- aabbdev 1y agoA Postgres extension is currently in development to provide transparent database optimization with custom type uuid45 and optional helpers ;)
- the_mitsuhiko 1y agoThat would generally be nice to have. I would love to have base62 encoded IDs with prefixes but store it internally as UUID.
- nightpool 1y agoNot just a small inconvenience—because there's no human readable way to tell the difference between v4 and v7 IDs, you have to guess and check whether or not the ID your server process is logging is a pre-conversion or post-conversion ID
- Dylan16807 1y agoThe human readable way to tell the difference is you look at whether the third group starts with a 4 or a 7.
- kbumsik 1y agoIt is really easy to tell the difference btw. You will always see "4" or "7" in the middle.