[ucarion]

Do you have any resources online for how well this approach works in practice? I've been thinking about doing this in replacing a MongoDB database.

[cagmz]

Anecdotally, it's worked out well. Before storing a JSON object, we validate it at the app-level using a JSON schema (which has types, required keys, etc). This lets us write without worrying to much.

Once we felt that the schema wasn't changing as much, had too many concerns, etc, we made tables and wrote to them (instead of the JSON column).

[pas]

Could you please elaborate on why do you want to replace MongoDB?