this post was submitted on 13 Sep 2025
303 points (99.0% liked)

Programmer Humor

27412 readers
2251 users here now

Welcome to Programmer Humor!

This is a place where you can post jokes, memes, humor, etc. related to programming!

For sharing awful code theres also Programming Horror.

Rules

founded 2 years ago
MODERATORS
anzo@programming.dev
Feyter@programming.dev
BurningTurtle@programming.dev
pylapp@programming.dev
303
Who needs MongoDB when you have JSONB? (lemmy.world)
submitted 2 months ago by qaz@lemmy.world to c/programmer_humor@programming.dev
40 comments fedilink hide all child comments
 
you are viewing a single comment's thread
view the rest of the comments
[โ€“] jubilationtcornpone@sh.itjust.works 5 points 2 months ago* (last edited 2 months ago) (1 children)

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.

[โ€“] Simulation6@sopuli.xyz 6 points 2 months ago

Ok, I was wrong. The only example I have worked with was just someone being lazy.