Creating an app that does a lot of queries. That is, when a player plays a card it looks to see what combinations it can create, etc.
What is the best way to store this information in the app (local DB? what kind? Just XML?) and also then when there is an online connection, send updated or new information to an online storage so their data and profile isn't lost if they logout and login?
Should I use AWS and get an RDS instance of a DB or will any shared server with a page/listener work?
Essentially, I want to have an offline (their account on their device) set of data that matches the online (all users and back up for their account) set of data.