Testing out PlayFab to see if it will meet my current projects needs.
One thing I cant seem to find is the ability to do SQL like queries or functions.
Use Cases:
Need to remove item from all users because it no longer exists in game and refund VC paid for item.
Export tables for backups, needed incase of exploit or hackers we need to ability to rollback data.
Stuff like that. Do these functions exist with the PlayFab service?
Thanks.
We do not provide arbitrary query into the PlayFab core service database tables, as that's historically one of the key sources of failures in online games (queries which result in excessive load on the databases, resulting in slow performance). We can provide a dedicated, distinct database for enterprise partners - feel free to email us at devrel@playfab.com if you'd like more info on that.
For changes to players based upon changes to your game (like removing an item which no longer exists), the efficient way to do this is by having an "onLogin" handler in Cloud Script, which you call when the player signs in, and which you can then update to make sure any changes to player data over time are managed.
Larger-scale usage, such as rollback, is not something any developer has asked us for as yet, so if it's a key requirement for you, we'd certainly like to discuss the specifics (again, via devrel@playfab.com). We do plan to offer functionality which would make this possible in Q1.
