this post was submitted on 28 Aug 2025

386 points (99.2% liked)

Programmer Humor

26071 readers

1114 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

Keep content in english
No advertisements
Posts must be related to programming or programmer topics

founded 2 years ago

MODERATORS

anzo@programming.dev

Feyter@programming.dev

BurningTurtle@programming.dev

pylapp@programming.dev

386

See MongoDB (lemmy.world)

submitted 4 days ago by qaz@lemmy.world to c/programmer_humor@programming.dev

46 comments fedilink hide all child comments

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

[–] jubilationtcornpone@sh.itjust.works 3 points 4 days ago

The query speed isn't quite there but I would say it's close enough for a lot of purposes, especially with proper indexing. And JSON column fields are indexable. Two things I've used Postgres' JSON functionality for are:

1.) Storing unstructured data. 2.) Storing structured data that would exceed the table column limit.

In both cases, I've typically needed to extract the relevant data from the JSON records to either be stored in another table of turned into a materialized view so live query performance on the JSON columns was not that important.