caluma icon indicating copy to clipboard operation
caluma copied to clipboard

feat: use uuid7 instead of uuid4 from now on

Open winged opened this issue 4 months ago • 1 comments

UUID7 has the nice property of being semi-sequential, so it will be much nicer on DB indexes, and following that, improve query performance as well

Note we don't fully replace UUID4 everywhere: In tests, we don't care too much, so we don't build a UUID7 faker for those IDs, and in the Analytics module, we use UUID4 as a simple "random string" utility for generated identifiers (and using only the left few chars of it would break when using UUID7).

winged avatar Oct 16 '24 09:10 winged