Let us say I would like a simple (yet complex) web application where there is continuous READING AND WRITING to the sql azure database. Let us say I am tracking a location, and I would like it to be updated very frequently (lets take the worst case: 1 second).
From the little knowledge I have, I think that this involves the use of the database to continuously write the location to the database, and continuously read from the database to update another person through a website.
Do you please have any suggestion which technologies can I use? Is there a simple way? I heard about node.js, signalR. I have no idea how to use them, if they are really what I need. the last tutorial I checked out simply uses a while(true) loop..but I don't think that that's something good to keep a thread continuously busy...
Do I have to create some background task?
Do I have to create some web service?
This is a school project and I wish not to go for the most difficult option, but if there is some sort of solution, challenge accepted :)
Can you please help me? Since I have asked many questions here and yet I have no solution in mind