309

Who needs MongoDB when you have JSONB? (lemmy.world)

submitted 1 month ago by qaz@lemmy.world to c/programmer_humor@programming.dev

58 comments fedilink hide all child comments

you are viewing a single comment's thread
view the rest of the comments

[-] Simulation6@sopuli.xyz 1 points 1 month ago

I really dislike JSonB in Postgres. Just use a ORM at that point.

[-] fxdave@lemmy.ml 18 points 1 month ago* (last edited 1 month ago)

That's not the point of JSONB. Use normalized tables whenever you can. JSONB allows you to store a document with unknown structure, and it allows you to access that data within SQL.

[-] Simulation6@sopuli.xyz 2 points 1 month ago

I probably have just run into a bad example of its use. I can see it being useful for unknown documents.

[-] jubilationtcornpone@sh.itjust.works 4 points 1 month ago* (last edited 1 month ago)

I run a web app that processes at least one third party JSON document that is so large it would exceed the table column limit if flattened out. It gets stored in a JSONB column. EFCore with Npgsql can query JSON documents in Postgres. Works just fine as long as you put indexes on the fields you're going to be querying.