Should I use JSON in MySQL here?
Im trying to decide how I should structure my data here. Im trying to move off of Firebase to Planetscale. I know that you can use JSON in MySQL, but I know you should avoid JSON if you can, especially if you wanting to index that data. But I do not need to index this data at all, im not doing anything special at all here.
The
I would store the
If I didn't use JSON (I have a picture of the schema for this too), I would be JOINing from the
The
Action EventsI would store the
actionEventsactionEventsIf I didn't use JSON (I have a picture of the schema for this too), I would be JOINing from the
gamespossessionsactionEvents
