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 Events is what I am thinking about using JSON for. I would store the
actionEvents inside the possession table, and on the right-hand side in the picture there is a pretty typical example of what an actionEvents array would look like. If I didn't use JSON (I have a picture of the schema for this too), I would be JOINing from the
games table to the possessions table and then to the actionEvents table whenever I wanted to query this actionEvent data . And this is data that I am querying very often. So this just feels super unnecessary to me.
