I just got mocked at work because I said for an audit table is fine to have a mysql json column type similar to what spatie package activitylog does. Is even worst cause was the CTO that mocked me with a meme, what do you guys think about this?
Depends on the usage, if it's for a dump of logs or user headers then it's okay. If it's for the handling of data that could be normalized a bit then it's not okay. But I also believe nosql dbs should not be used in 75% of cases they are used today.
Exactly what I think, for logs is a better approach in my opinion. I wouldn't use json type too often but there are certain cases like logs of user actions on an entity for example that to me makes sense.