3 ms·
> Postgres JSON operators are cryptic and made my head hurt every time I wanted to accomplish something more complex. I first started working with JSONB column
by GordonS 6y ago
> Postgres JSON operators are cryptic and made my head hurt every time I wanted to accomplish something more complex.
I first started working with JSONB columns in Postgres around 2 years ago, I think, and had the same initial impression - the operators are certainly quite alien compared to more typical SQL, and it took me a while to figure out how to do more complex things.
I kept at it though, and now it all feels more natural. I haven't touched Mongo for about 10 years, so it wouldn't be fair of me to compare, but I love the performance and power of JSONB in Postgres. And having all this right alongside regular relational tables in the sr database is fantastic.
I often work with TimescaleDB too, which again just works alongside everything else, in one database - Postgres really is an incredible database!
- lexx 6y agoI honestly wonder, for a team that is unfamiliar with both psql JSONB and mongodb, which of those two would be easier to learn? And later on, which of those two would make the team more productive? I think this is the most important. To be fair, I use mongoDB for 8 years now compared to less that 1 year of psql JSONB, so I can't really answer objectively.