cm0002@suppo.fi to Programming@programming.dev · 14 days agoThe perils of UUID primary keys in SQLiteandersmurphy.comexternal-linkmessage-square21linkfedilinkarrow-up146arrow-down11cross-posted to: programming@lemmy.mlhackernews@lemmy.bestiver.se
arrow-up145arrow-down1external-linkThe perils of UUID primary keys in SQLiteandersmurphy.comcm0002@suppo.fi to Programming@programming.dev · 14 days agomessage-square21linkfedilinkcross-posted to: programming@lemmy.mlhackernews@lemmy.bestiver.se
minus-squareTehPers@beehaw.orglinkfedilinkEnglisharrow-up9·14 days agoI’m glad this covers UUIDv7. Unless you need cryptographically-random, unpredictable row IDs, using UUIDv7 helps a lot with the performance by making the keys ordered at least.
I’m glad this covers UUIDv7. Unless you need cryptographically-random, unpredictable row IDs, using UUIDv7 helps a lot with the performance by making the keys ordered at least.