mck
banner
mck.semb.wever.org
mck
@mck.semb.wever.org
it's msw upside-down

distributed computing, databases, jdk, linux
🇳🇴🇦🇺 https://about.me/wever
ja, det var skisporets smøretips "wizard"
December 1, 2025 at 10:15 AM
hva skjedde med griptip.skisporet.no ?
griptip.skisporet.no
December 1, 2025 at 9:53 AM
when would you write the two columns separately (as opposed to always in same insert/update statement) ?

you have any numbers about extra storage space the hash column uses ? reduce the hash length ?

i don't know your specifics but both are trivial for most folk

to skip setup: astra.datastax.com
November 20, 2025 at 6:16 PM
for just equality matches yeah, hash it into a separate column and index that. i don't know of any plans to directly index blobs. Given the workaround is simple, i hope it's not otherwise lacking in any way ?
November 20, 2025 at 5:52 PM
We call it denormalisation
It's catering to technical limitation (but what choice do you have?)

I hope future data platforms automatically do this for you, based on consumer usage+patterns. Ultimately it's the responsibility & best encapsulated in the storage engine (network locality issues aside)
November 8, 2025 at 9:36 AM
lenke ?
October 28, 2025 at 10:20 AM
lol, repeat of NBN. waiting for the morons to turn up and declare it's not needed and there's a "more efficient" way to
October 21, 2025 at 5:51 AM
📌
September 27, 2025 at 2:44 PM