Picking a language for this particular project
Hello,
I know that the best way to learn coding is to actually create a project. I thought about my biggest interests and which type of a project would keep me excited over longer period of time. Finally I decided to create an Equity Trading Journal. There are plenty of such apps but the goal is purely educational + making things my own way.
At the moment I keep all my trades in (quite advanced already) google sheet document, but it's getting a bit slow and also I can see some of its limitations.
I'm learning JavaScript and jQuery right now, I know HTML + css quite well, so my initial idea was to start in JS. On second thought however it may not be a good idea to keep all source files open to the public, so I assume (correct me if I'm wrong) that in addition to HTML/CSS I'll need a backend language. One option is to learn node.js the other using python (with its libraries for data analysis, graphs etc.). To summarize:
- I need more flexibility than google sheets UI wise, columns and rows sometimes drive me crazy, I also want to learn how to code better and slowly improve my skills
- I want the final solution to be accessible in a browser.
- As an educational long term goal, at some point I want to create a fully functional app (user account, export of data to xls and so on) but of course will start from the very basics, like log current trade, stats for each strategy, Win/Long ratio, Risk-Reward etc.
- At some point, the app should be similar, obviously not as advanced, to myfxbook.com to give you a rough idea
Questions:
- Is it a really bad idea to create everything in pure JS? Assume it's possible but...
- Node.js vs Python as a language for data analysis, creation of graphs?
- If python - which libraries to start with? if I have to start learning a new language, I want to begin with data and charts right away
- What about database? I have not much experience with mySQL, will it be neccessary?
- How about GO? I know it's a relatively young language, does it have any supporting libraries for data/graph/trading purposes?
- I assume languages like c++ are not suitable for a backend web solutions?
As always I'd appreciate your feedback :)