Use django’s JSONField

[chris34]

Inyoka has a custom JSONField Basically, this will work.

However, Django offers nowadays an own JSONField:

• https://docs.djangoproject.com/en/4.1/ref/models/fields/#django.db.models.JSONField
• https://docs.djangoproject.com/en/4.1/ref/forms/fields/#django.forms.JSONField
• https://docs.djangoproject.com/en/4.1/topics/db/queries/#querying-jsonfield

Migrating to Django's one could save maintenance (in the longterm) and make queries easier. However, it is unclear, how much work it is to migrate.

[encbladexp]

Does our own JSONField use the DB native column types, or just TEXT with a JSON in it?

[chris34]

hm, seems like the line number where the class is located changed

https://github.com/inyokaproject/inyoka/blob/7de28b02c730969b3b51c03619619e7514a851a8/inyoka/utils/database.py#L153

At the moment it's only a Textfield with Python's json.loads(s) and json.dumps(obj, cls=DjangoJSONEncoder).