✅ How should updating Database work with Kanban style app work?
I'm working on a Kanban style app to practice everything I've learned in .NET so far and i was curious how you would handle updating everything in the database.
If you have 2 boards to hold items, and you are actively moving those cards between board A and Board B or reordering the items in each board, that would require an update each time, because you have to track the items current board and the cards order in that board. But it seems like madness to call and update everything any item is moved, so instead is it a better idea to instead call an update on a timed interval that updates the board and all items at that point in time??
4 Replies
I'd issue an update every time a card is moved. It doesn't happen that often (if someone's actively rearranging the board maybe once a second? But that's forever in computer terms), and I'd get ignored if I moved a card, then closed the window and it lost the update
JIRA goes as far as to revert the card in the UI if it can't send the move to the backend
Or really, I thought moving the cards and updating them every time would cause some kind of performance issues, but if thats not the case then this is great news 😄
I mean, if you're expecting thousands of moves a second, maybe? But at that point you're probably supporting hundreds of thousands of users
And at that point you probably have some complex backend architecture to handle that many simultaneous users anyway
yeah def not that LOL, i am very much just trying to build a somewhat impressive portfolio project to hopefully get a job at a .NET shop lol, only been learning .NET and C# for about 30 days now 😅