I am working on a feature where I need to store some data and I am not sure what should be my best option to store this data. I am sending data to some third party and want to show some part of that data internally in system dashboard.
Data is being calculated at run time and being sent to third party. Since the base data based on which I am creating data needed for third party can change down the line, I can not use same API to create data in the later stage so I am left with no option but to save it somewhere.
I am not sure what will be the best way to store some part of it. I have following options
- Store data in DB as json data and when need to show in dashboard , just fetch it and de serialize it.
- Create a new structure for this in DB and store it.
FYI: I am storing data being sent to third party as an XML for logging purpose but not sure if using same XML file at later stage is a good option ( a little doubtful about file system).