Postgres jsonb column type has worked great without much effort. The old JSON type wasn't great and required special index, but that's decently in the past now.

Postgres jsonb column type has worked great without much effort. The old JSON type wasn't great and required special index, but that's decently in the past now. Not sure of MySQL in this aspect.