Tanoh comments on Good Morning

Programmer Humor

33,631 readers

7,507 active

1,385 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
- If the mod doesn't find it funny, you're banned. Ha-ha!... For real: do not use the community for "statements". There are other places for such content. Keep it chill and funny.

founded 3 years ago

moderators

[–] Tanoh@lemmy.world 14 points 1 year ago (4 children)

And you can add indexes on those JSON fields too!

permalink

fedilink

source

parent

hideshow 4 child comments

[–] Tja@programming.dev 7 points 1 year ago (3 children)

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

permalink

fedilink

source

parent

hideshow 3 child comments

[–] jubilationtcornpone@sh.itjust.works 2 points 1 year ago (1 child)

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.

permalink

fedilink

source

parent

hideshow 1 child comment

[–] Tja@programming.dev 2 points 1 year ago

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

permalink

fedilink

source

parent

[–] Tanoh@lemmy.world 1 point 1 year ago

Sure, if you use a field often it is most likely better to extract it into a column with auto-updates from the JSON data.

But you have to tune it and see what is best for your use case. Just saying that you can add indexes to JSON fields as well!

permalink

fedilink

source

parent