my admittedly anecdotal experiences working with JSONB in Postgres: coding is generally easy and performance is great, it even plays nice with ORMs like hibern

my admittedly anecdotal experiences working with JSONB in Postgres: coding is generally easy and performance is great, it even plays nice with ORMs like hibernate (with just a bit more work). the downside is the query syntax: for complex queries where you need to search within the JSON, it's hard to write correct SQL. it's a trial-and-error process and the error messages aren't that great. once you get it working you're fine, but it can be hard to get there sometimes.