alt Hacker NewsYou could take this even further and add triggers to see if your move is legal or not. Or delete row with a conflict when you capture a piece.
You could take this even further and add triggers to see if your move is legal or not. Or delete row with a conflict when you capture a piece.
This is getting dangerously close to how some AAA MMORPGs handle[d] much of their logic and state management.
At the scales these games operate, enterprisey oracle clusters start to look like a pretty good solution if you don't already have some custom tech stack that perfectly solves the problem.