JSON Data in preside objects

Problems and solutions
1

I have some very loose data I need to store in Preside objects and thought about MariaDB 10.6. JSON features. I think the CRUD actions are not to difficult, in worst case I need to do the queries manually. But the object definition bugs me. I haven’t found any information about a colum type JSON and things like VIRTUAl columns for indexes.

Is there any docu or examples on this? Or is it possible at all?

Thanks

MariaDB docu: Using JSON in MariaDB | MariaDB

2

It hasn’t been done, so not sure. I think in this case you may need to add the fields and their index configurations manually and do something like:

property name="my_json_col" ... dbsync=false;
3

Would be good to get a proposal on how we implement this. Potentially ditching support for MSSQL and POSTGRES along the way (though maybe not).

4

“basically” it’s a LONGTEXT type in all of the three DBs. The CRUD statements differ, but the functionality sems to be very similar. It would be helpful to deal with JSON fields. I’ll do some first steps in MariaDB and let you know.

1 Like
5

Is it worth looking at the JSON and JSONB facilities within PostgreSQL.

and