A half table oriented half document oriented solution is just odd. I’ve worked with JSONB in Postgres. There are many reasons to dislike mongo but “your can do

A half table oriented half document oriented solution is just odd. I’ve worked with JSONB in Postgres. There are many reasons to dislike mongo but “your can do that with PostgreSQL “ isn’t one of them. Querying nested values is is nothing like Rethink or Mongo. Keys could be rows or keys. You’re still having to make one to many relationships for something that should just be an array.