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?
I think it means that meme warfare is allowed. Remove safety. Unload!
i.giphy.com/media/v1.Y2lkPTc5MGI3NjExN3htZjFtODR5aXU2ZTZ4dWxrY25md3Rldnp3aG9ka2JqMjRiYzBzbCZlcD12MV9pbnRlcm5hbF9naWZfYnlfaWQmY3Q9dg/Yh30S0qiIw1wsF1L0T/giphy.gif
My employer approves that. We have json columns to activity log.
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.
