cm0002@lemmy.world to Programmer Humor@programming.dev · 1 day agoGood Morninglemmy.mlimagemessage-square52linkfedilinkarrow-up1734arrow-down15
arrow-up1729arrow-down1imageGood Morninglemmy.mlcm0002@lemmy.world to Programmer Humor@programming.dev · 1 day agomessage-square52linkfedilink
minus-squarelime!@feddit.nulinkfedilinkEnglisharrow-up24·22 hours agopg can actually query into json fields!
minus-squarelime!@feddit.nulinkfedilinkEnglisharrow-up4·9 hours agooh i didn’t know that. iirc postgres easily beats mongo in json performance which is a bit embarrassing.
minus-squareDerpgon@programming.devlinkfedilinkarrow-up1·6 hours agoHoly, never knew, and never would expect. Postgres truly is king.
minus-squareTanoh@lemmy.worldlinkfedilinkarrow-up11·19 hours agoAnd you can add indexes on those JSON fields too!
minus-squareTja@programming.devlinkfedilinkarrow-up5·14 hours agoKind of. I hope you don’t like performance…
minus-squarejubilationtcornpone@sh.itjust.workslinkfedilinkarrow-up1·3 hours 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-up1·3 hours agoQuite well is very subjective. It’s much slower than columns or specialized databases like MongoDB.
pg can actually query into json fields!
Mysql can too, slow af tho.
oh i didn’t know that. iirc postgres easily beats mongo in json performance which is a bit embarrassing.
Holy, never knew, and never would expect. Postgres truly is king.
And you can add indexes on those JSON fields too!
Kind of. I hope you don’t like performance…
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.