Need some guidance for Final Year Project - Multiplayer Sudoku App

[quick hare]

Hello guys, I am ongoing a Final Year Project to create a multiplayer sudoku android app. For now, I am struggling about the database and multiplayer part, which are fetch and get data from database to view player stats, and the multiplayer mode to combat with other players in same Sudoku puzzle.

So far, I done with the player authentication (with Firebase) and the sudoku game logic, but I stuck on how to create random multiplayer game mode which is players are combating with same puzzle generated and the leaderboard as well as player stats features.

I would greatly appreciate your guys insight of multiplayer functionality and database management. Thank you for answering my confuse.

[vivid rover]

Check out this chess example. It's using Lobby and Cloud Code for the multiplayer and Cloud Save for the database

https://github.com/Unity-Technologies/com.unity.services.samples.multiplayer-chess-cloud-code

[quick hare]

Thanks so much. But apologies for some misinformation I didn't state that.

For the game mode, it has two players in a room, playing the same puzzle generated and the players need to solve faster than others with lives attempts remaining. Once the players solved the puzzle completely, he will get points and will update to the database.

The puzzle game is real time match but not turn based match, so is this technique same with the chess example? Sorry for asking lot of questions makes you trouble

[vivid rover]

Yea the Chess sample is for turn based games. For realtime you would connect using NGO Relay and use Lobby to find a match.
There is a Leaderboard service you can use too. I would still use Cloud Save to save player ratings and whatnot.

[quick hare]

Thanks for your example, how about the database part/

[quick hare]

I would like to save player data automatically, can preview in player stats, and also update after a match