the way we had it working was local storage (sqlite) and remote storage (postgresql with a middleware). If you pick something up it flags as an “interesting ev

the way we had it working was local storage (sqlite) and remote storage (postgresql with a middleware). If you pick something up it flags as an “interesting event” and syncs your profile to local storage- on game server crash, there would be a crash collector which syncs the local database with the remote one and removes the lock - meaning you can join a working server. The crash collector also did things like… well, collect the crash dump and send it for debugging. But thats roughly how it worked.