I'm developing a sort of scrum board web app but I'm not sure how to approach the aspect if it changing and updating for users that are looking at the same page.
Scenario: We have a table with 3 columns (To Do; In Progress; Done) populated with elements inside. If I drag one from To Do to In Progress (jQuery/AJAX); what type of approach could I use to have it update on all users viewing that scrum board (they would see Object 1 move from Column 1 to 2)
Theory: Right now I'm thinking of pinging the database every 15 seconds or so (I know that there won't be a large amount of users so it won't strain the database) and redraw accordingly... but I don't feel it's proper.
An example would be Google Docs shared Excel sheets.
Is there a way to create a delegate in PHP to accomplish this? If not, could you point me in the right direction? (Perhaps learning another language for this aspect?)