I want to make an adventure game (such like Monkey Island or Myst) and I wonder how data can be stored... In my first game (which is action / arcade kind) there is just a few strings and integers to be stored so I used text files, but in this new game there will be lots of descriptions and strings that must be stored and shown when player goes to somewhere or looks at somewhere (however there's no need to modify this data)... Is SQLite the best way to do this? And, if the answer is yes, is there any tutorial to easy integrate a SQL database in a non-view-based application (OpenGL instead)?
I suppose there is no reason you could not use an SQL database for this, but ... why go through the trouble? Based on your description, why not just stick to a text file, like raw text or XML?
I guess I don't (yet) see a compelling reason to use SQL in your scenario.
Kalimba is correct. There is no reason for a SQL database.
However, I use SQL databases for my high score systems.
This is how it is done. On some kind of web server, make a php file that uses $_GET to get information from the URL (The data you want). The iPhone can do a simple HTTP request with the variables in the URL. The PHP file can see what information it needs and echo the information to the page. The iPhone can parse this information into each individual strings.
Use the iPhone to get that string then split the string into a array with the information. You can get the information in the string by stopping at the : character and keep going until the string stops.
SQL in a game?
Linear Mode
