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

PostgreSQL

791 readers
1 users here now

The world's most advanced open source relational database

Project
Events
Podcasts
Related Fediverse communities

founded 2 years ago
MODERATORS
 

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

top 2 comments
sorted by: hot top controversial new old
[–] [email protected] 1 points 4 months ago

I have used jsonb in production and it is plenty fast for general purpose workloads. If you need high performance, you will want to stick with a normalized schema, but in general jsonb is pretty slick and highly performant when compared with things like mongo.

With that said, if you are developing queries against jsonb, you should really try not to use it. Dumping denormalized data into a single blob is going to make your life really painful in a few years when you have giant piles of highly differentiated data. Postgres will happily let you do it, and I don’t know your use case, but think carefully about the tech debt you may be incurring by using this over the long term

[–] [email protected] 1 points 4 months ago

I am using it in the AI Horde for mostly immutable fields which I don't need to search often (although sometimes I might use them for DB filtering).

They work well in the way I use them, no complains so far.