cm0002@lemmy.world to Programmer Humor@programming.dev · 1 day agoGood Morninglemmy.mlimagemessage-square51fedilinkarrow-up1719arrow-down15cross-posted to: programmerhumor@lemmy.ml
arrow-up1714arrow-down1imageGood Morninglemmy.mlcm0002@lemmy.world to Programmer Humor@programming.dev · 1 day agomessage-square51fedilinkcross-posted to: programmerhumor@lemmy.ml
minus-squarelime!@feddit.nulinkfedilinkEnglisharrow-up24·19 hours agopg can actually query into json fields!
minus-squarelime!@feddit.nulinkfedilinkEnglisharrow-up3·6 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·3 hours agoHoly, never knew, and never would expect. Postgres truly is king.
minus-squareTanoh@lemmy.worldlinkfedilinkarrow-up11·16 hours agoAnd you can add indexes on those JSON fields too!
minus-squareTja@programming.devlinkfedilinkarrow-up5·11 hours agoKind of. I hope you don’t like performance…
minus-squarejubilationtcornpone@sh.itjust.workslinkfedilinkarrow-up1·24 minutes 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.
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.