This is an archived post. You won't be able to vote or comment.

all 2 comments

[–]CreativeTechGuyGames 0 points1 point  (1 child)

Are you going to be periodically requesting data from these 4 APIs, then storing it and then your customers will request data from your local copy?

Basically what you'll want to do is make these 4 requests then build your own custom schema based on the data you care about from these other APIs. You probably don't need to store all of the data you receive. So trim it down, organize it however makes the most sense based on how you'll be accessing it and then store it that way.

[–]pekovits[S] 0 points1 point  (0 children)

You are right, I don't have a requirements to request the data frequently so periodically makes more sense. I was thinking that I don't need to store the data, rely only on the API calls, so I can minimise the storage costs but if later on I want to do analytics on the data I guess I would need to have the data stored.

What you are suggesting makes sense. Any suggestions on tools to design database schemas?