I am looking for an efficient way to simply mirror the database and then do small updates once a week. I am unsure how to do it with the current setup. Anyone have a good solution they are willing to share?
while the IDs haven't changed, the data structure has changed in such a way that it would warrant a full remirror.
should you choose to do so, you should query for platforms, then games by platform and loop through all platforms and all pages.
then after you're done, you can query all images based on ID you've collected.
please check and double check your code and query, as your private key won't be reset.
With that all said, if you're ok with a hybrid database as you slow populate your DB with new entries look at the update api endpoint and use last_key_id=0, which should give you the entire DB history since the new site went up
I'd recommend using `/Games/GamesByPlatformID` instead, and iterate through pages.
but to answer your question, as much as URL query limit would allow (google suggest 512 characters, so roughly 100 ids), however, each page would only return 20 results per page.
The public key is for testing and end-user usage, and has a significantly lower limit.
If you have a new public project, please provide a link to it so we can highlight cool new applications!