2

I wish I could look up, locally, without ever making an external request, the release dates (for each region/country) for "any commercially sold product ever". For example, I could do:

SELECT product_name, release_date_usa, release_date_fr FROM products WHERE (creator_company = 'Nintendo' OR publisher_company = 'Nintendo') AND title LIKE '%Zelda%' ORDER BY release_date_usa DESC;

That would give me a nice list of each Zelda game released and their release dates for the USA and France, ordered by their release date in the USA.

I've many times had the need to do things like that, and if somebody from 1985 would somehow read this question from the future, they would say:

Are you kidding? You can't even do that in the year 2020? But... all of these TV programmes talk about how databases and computers will make everything wonderful and easy and free? How come you still don't have it so far into the future?

To make it crystal clear:

I'm looking for a regularly updated and high-quality (reliable, and with the correct product names) CSV/JSON file which I can regularly download as a single archive, update my local SQL database with and then make all kinds of queries on locally, as shown above.

Please let this exist. If it's too broad, I would be okay with "just" all video games and movies, but preferably, I want every single product ever released in any nontrivial amount.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.