How can I save external API response data to local database (using Prisma and Postgres)
Unanswered
Wirehaired Vizsla posted this in #help-forum
Wirehaired VizslaOP
Hi friends,
Firstly I'm quite the amature so apologies if this is more simple than it seems but I'm not finding much help Googling.
I'm using the IGDB gaming api (https://api-docs.igdb.com/?javascript#examples). I want to display (likely through Pagination) their ~37,000 multiplayer games on my website. Their recommendations are to save their data on our databases to minimize the load on their APIs.
I'm able to query their API through Postman, but I'm not sure which approach (libraries, etc) to take for getting that data into my database.
Thoughts;
- Save API response data into 1 giant file, then find a way to get that data into a DB table(s)
- Setup something that gets converts API response data straight into my DB
How would professionals tackle this problem? Is this even the right approach?
Thanks in advance!
Firstly I'm quite the amature so apologies if this is more simple than it seems but I'm not finding much help Googling.
I'm using the IGDB gaming api (https://api-docs.igdb.com/?javascript#examples). I want to display (likely through Pagination) their ~37,000 multiplayer games on my website. Their recommendations are to save their data on our databases to minimize the load on their APIs.
I'm able to query their API through Postman, but I'm not sure which approach (libraries, etc) to take for getting that data into my database.
Thoughts;
- Save API response data into 1 giant file, then find a way to get that data into a DB table(s)
- Setup something that gets converts API response data straight into my DB
How would professionals tackle this problem? Is this even the right approach?
Thanks in advance!