DEV Community

Discussion on: GoldAPI.io - How to build Gold & Silver Prices REST API and Dashboard using Node.js + React in 5 days

Collapse
 
jakesweb profile image
Jacob Colborn

Do you store the historical gold prices in Mongo or do you pull those on request? I would think that would be a good bit of data to store but would provide better performance if you did not have to reach out every time someone requested this.

Collapse
 
aershov24 profile image
Alex 👨🏼‍💻FullStack.Cafe

Hi Jacob, yes we store historical daily Gold (and Silver) prices from LBMA in Mongo and update them daily (using great node-scheduler job scheduler). This data available since 1968 so there are not so many records (around 20k). The reason there is no reliable data source for that data type anywhere to pull them by request and it usually available only as CSV files or published as static HTML data and scattered around internet. We obviously use caching (in memory) once the data is queried (life & historical).