cm0002 ( cm0002@suppo.fi ) to Programming@programming.dev · 4 months agoThe perils of UUID primary keys in SQLiteandersmurphy.comexternal-linkmessage-square7linkfedilinkarrow-up130cross-posted to: programming@lemmy.ml
arrow-up130external-linkThe perils of UUID primary keys in SQLiteandersmurphy.comcm0002 ( cm0002@suppo.fi ) to Programming@programming.dev · 4 months agomessage-square7linkfedilinkcross-posted to: programming@lemmy.ml
minus-squareTehPers ( TehPers@beehaw.org ) linkfedilinkEnglisharrow-up9·4 months 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.