Colleague and I have begun a long (and hopefully fruitful) project. I've been building and have come to my first crux, and now I ask the experts of the Stack Exchange for their guidance.
I'll keep this simple. Our front end has functionality to search for stocks and get back real-time intraday data on it. It's a search dashboard for info, nothing else YET. Our front end sends the user's search request to our StockDataAPI, which actually just sends a GET req to some public trusted stock data api.. the user doesn't know the difference, they think we own the publicly available data.
Asking: Is it right to keep this approach? Over time, wouldn't this become clunky and burdensome? Would it be better to have the following: Save the returned stock information in a database for easier lookup? But checking the entire DB before querying 3rd party API will become cumbersome once DB is very full. I'd also have to have a step to save info in DB if the information being returned wasn't present in the DB. Or should I try something completely different?
Thanks in advance for all your time!