Hey guys, I have a few questions.
There's this app idea that I'd like to sell to hedge funds. Basically it would be an app for the shareholders themselves, where they could access basic information about his fund. (e.g. today's performance, basic risk variables, etc). I thought about having the staff from the fund to fulfill a very simple excel spreadsheet everyday, run a macro (built by myself) that accesses a sql server and updates a few tables with today's infos. On the client-side, the Corona interface queries the DB and retrieves the info.
I've read some articles and thought about having the fund rent a droplet cloud service, run MySQL from there, and have the excel Macro update the DB. On the client-side I've thought about having the client query the sql server from a php query for safety issues, through the app. I'd have to decode from JSON I've been told.
I found Mysql exceedingly complex and the whole thing overkill for a few bits of information (e.g. 5-10 fields). Is there a simpler way? Is the Php absolutely necessary? What if the funds want more information? (e.g. historical performances, etc) What's the best and easiest way to work this out?
I'd like to build a prototype so I could have something to show for.
I hope I've made my intentions clear, but if not please feel free to ask.
Thanks in advance.