How would you implement an item system?

[MrDunne]

Originally Posted by Tigairius

SQLite is one of the most powerful technologies we have at our disposal with GScript2, and almost anything that can be done with SQL can also be done with SQLite when also mixed with a little GScript2. Sure, there is no automated cleanup or date typedefs, but SQLite serves its intended purpose as a quick retrieval database system. I use it extensively in our development on Kingdoms iPhone and it works well.

Well that's good to know. I've heard a lot of other developers outside of this game complain about SQLite for a few reasons. Mainly one being it's inefficiency when with larger amounts of data (due to the whole database being stored in one file, I believe).

But since you speak of success in production, I'll take your word for it.