this post was submitted on 13 Sep 2025
321 points (99.1% liked)

Programmer Humor

26372 readers
1574 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
321
Who needs MongoDB when you have JSONB? (lemmy.world)
submitted 4 days ago by qaz@lemmy.world to c/programmer_humor@programming.dev
60 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 4 days ago* (last edited 4 days 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 7 points 4 days ago

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