Are there any recommendations about using JSON columns in ArcSDE (Oracle)?
In Oracle Database, JSON data is stored using the common SQL data types
With the check constraint
is json on this column you tell Oracle that you will store json.
I guess that you can create a featureclass in Oracle with python, and add this check constraint afterwards. Would that work?
I am aware that there are lots of issues with storing and querying json in relational databases as you can read here:
But are there any issues concerning ArcSDE which would make ArcSDE slower or reducing functionality?