cm0002@lemmy.world to Programmer Humor@programming.dev · 3 days agoGood Morninglemmy.mlimagemessage-square56fedilinkarrow-up1805arrow-down15
arrow-up1800arrow-down1imageGood Morninglemmy.mlcm0002@lemmy.world to Programmer Humor@programming.dev · 3 days agomessage-square56fedilink
minus-squareTja@programming.devlinkfedilinkarrow-up6·2 days agoKind of. I hope you don’t like performance…
minus-squareTanoh@lemmy.worldlinkfedilinkarrow-up1·1 day agoSure, if you use a field often it is most likely better to extract it into a column with auto-updates from the JSON data. But you have to tune it and see what is best for your use case. Just saying that you can add indexes to JSON fields as well!
minus-squarejubilationtcornpone@sh.itjust.workslinkfedilinkarrow-up2·2 days agoThe performance is actually not bad. You’re far better off using conventional columns but in the one off cases where you have to store queryable JSON data, it actually performs quite well.
minus-squareTja@programming.devlinkfedilinkarrow-up2·2 days agoQuite well is very subjective. It’s much slower than columns or specialized databases like MongoDB.
Kind of. I hope you don’t like performance…
Sure, if you use a field often it is most likely better to extract it into a column with auto-updates from the JSON data.
But you have to tune it and see what is best for your use case. Just saying that you can add indexes to JSON fields as well!
The performance is actually not bad. You’re far better off using conventional columns but in the one off cases where you have to store queryable JSON data, it actually performs quite well.
Quite well is very subjective. It’s much slower than columns or specialized databases like MongoDB.