A friend and I have created a little iPad game in our spare time. Because we needed help, we also hired a freelancer to assist us with the programming.
The game has been developed in Xcode and Unity 3D and is based on an SQLite database.
The problem that we now have is the complexity of creating new levels and doing the game balancing. We just could not figure out a nice workflow - given how complex the database has become.
I come from a business background - so what I did is I recreated the database in MS Access and created many, many interactive forms, automated most of the stuff in VBA to help us create new games and do some of the game balancing. I spent weeks after weeks on this - and I am still far from done. Also, I didn't even check if I can export my database and import it into SQlite.
How would you organise the workflow to manage your complex game database?
Would you use a Web interface? Would you use Access or Excel (probably not)? What is the best way to manage your SQlite database for a game - without having to write SQL queries for each change?