Using Mnesia to coordinate game state to multiple devices

[Nicd]

I have a question related to this earlier post I made (so read the details from that):

@Nicd

I’m making a game where RFID readers will play an integral part. The game consists of many devices (different kinds of Raspberry Pi) acting as a network and synchronising game state together. There are initially three types of devices:

Player device: This is worn by the player and contains an RFID reader. Each player also has an RFID tag in their hand. The player device connects to the others with WiFi. If the RFID reader detects another player’s code, that player has tagged the wearing player and the wearing player’s tag will be disabled from affecting other players (by communicating this to all other players). Then that player must go to read their tag at a respawn station to reactivate their tag.
Respawn device: This is stationary somewhere and will connect via Ethernet most likely. When the respawn station’s RFID reader detects a tag, it should communicate to all the devices that that player’s tag is active again.
“Judge” that coordinates the whole game. This device should also offer a web page probably with Phoenix that can be used to set up and follow the game. Another feature could be permanent storage of game info to PostgreSQL/SQLite for example.

Do you think Mnesia would be a good fit to synchronise the game state between devices over WiFi (assuming WiFi is reliable)? For example the player devices need to know which players are on their side and which players are disabled so they are not tagged by “dead” players. The latency should be low enough to not be noticed during gameplay. So that when you tag someone, you can see that they are tagged at that moment and not a second later.

If not, what do you think should be used instead?

[Nicd]

@outlog

and even then you still need logic on the ‘judge’ if a tag event comes in it should wait x ms to see if another and contrary event comes in - and then decide based on the timestamps if A gets the tag or not.

mnesia doesn’t solve this logic so I would not venture there.

Serious timing is not required so if two players tag each other it’s not a problem, but can there be consistency issues? I’ve understood that Mnesia has atomic transactions, but will it lead to too big of a latency (this is all on a low-latency LAN WiFi)?