this post was submitted on 18 Jul 2025
809 points (99.4% liked)

Programmer Humor

25159 readers
1540 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
 
you are viewing a single comment's thread
view the rest of the comments
[–] Tanoh@lemmy.world 13 points 4 days ago (4 children)

And you can add indexes on those JSON fields too!

[–] Tja@programming.dev 6 points 3 days ago (3 children)

Kind of. I hope you don't like performance...

[–] jubilationtcornpone@sh.itjust.works 2 points 3 days ago (1 children)

The performance is actually not bad. You're far better off using conventional columns but in the one off cases where you have to store queryable JSON data, it actually performs quite well.

[–] Tja@programming.dev 2 points 3 days ago

Quite well is very subjective. It's much slower than columns or specialized databases like MongoDB.

load more comments (1 replies)
load more comments (1 replies)