I am trying to develop an interactive map website. I am aiming for an OSM based tile layer where I can add and adapt objects based on real time movement data. The real time movement data need to be loaded from a mySQL database.
To reach this goal I tried many technologies but nothing is satisfying or brings me to my target so far.
2: I made a short test using the leaflet js library. However, it also looks like being close to Google and Microsoft and I have not enough experience to know if and how I interact with databases.
3: I have the feeling I could reach my target using node.js only but do not know yet the consequences for the front and back end.
That said, do you guys have experience with those technologies or can recommend alternatives? How do you think about those technologies from the L/FOSS perspective?