Currently I'm developing an iOS MMO game with cocos2d-x. The game depends on many data tables (Excel file) given by the designers. These tables contain data like how much gold/crystal will be cost when upgrade a building (barracks, laboratory, etc.). We have about 10 tables, each have about 50 rows of data.
My question is how to store those tables on client side and how to update them once they have been modified on server side?
My opinion: use SQLite to store data on client side, the server will parse the Excel files and send the data to client with JSON format, then the client parse the JSON string and save it to SQLite file.
Is there any better method? I find that some game stores CSV files on client side, how do they update the files? Could server send a whole file directly to client?