this post was submitted on 06 Nov 2024
9 points (100.0% liked)

PostgreSQL

652 readers
1 users here now

The world's most advanced open source relational database

Project
Events
Podcasts
Related Fediverse communities

founded 1 year ago
MODERATORS
Ategon@programming.dev
starman@programming.dev
jnovinger@programming.dev
9
What are your experiences with jsonb columns as document store? (chaos.social)
submitted 1 week ago by indyarni@chaos.social to c/postgresql@programming.dev
5 comments fedilink hide all child comments
 

What are your experiences with @postgresql jsonb columns as document store?

Is it easy to use from a Spring App? How fast is it? What are its limitations?

#postgresql #json #databases

you are viewing a single comment's thread
view the rest of the comments
[–] RonSijm@programming.dev 3 points 1 week ago

I haven't used json(b) in a Spring app, so I can't say much about that.

Json vs Jsonb depends on the use-case. Inserting json is faster than inserting Jsonb. Reading json (based on searching for specific json properties) Jsonb is faster, because Jsonb is parsed into a more optimized tree.

From my experience, I don't really like doing selects based on json properties. If I know I'll be selecting a certain property, I usually add an additional column next to the json with the data, and insert that property there (At least in c#/dotnet, with EF) The frameworks don't have that much support for selecting within json (you can do it, it's just a lot more natively supported to use proper columns)