cm0002@lemmy.world to Programmer Humor@programming.dev · 24 hours agoGood Morninglemmy.mlimagemessage-square50linkfedilinkarrow-up1706arrow-down15
arrow-up1701arrow-down1imageGood Morninglemmy.mlcm0002@lemmy.world to Programmer Humor@programming.dev · 24 hours agomessage-square50linkfedilink
minus-squarelime!@feddit.nulinkfedilinkEnglisharrow-up24·18 hours agopg can actually query into json fields!
minus-squareTanoh@lemmy.worldlinkfedilinkarrow-up11·15 hours agoAnd you can add indexes on those JSON fields too!
minus-squareTja@programming.devlinkfedilinkarrow-up5·10 hours agoKind of. I hope you don’t like performance…
minus-squarelime!@feddit.nulinkfedilinkEnglisharrow-up3·5 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·2 hours agoHoly, never knew, and never would expect. Postgres truly is king.
pg can actually query into json fields!
And you can add indexes on those JSON fields too!
Kind of. I hope you don’t like performance…
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.