I may use Appcelerator to write an app for the iPhone with customization needed for the Android. But I would like data files my app creates to work on both the iPhone and the Android.
I have not chosen the database but have heard that SQL Lite might be one solution. I would like data files to be in an open a format as possible and to be sharable between all versions of the app which I write.
Should I be thinking about XML?
Does an XML file need to be loaded in its entirety before it's usable? Clearly, using a database has big advantages since it can be read dynamically.
What are my options if I want an open format and to allow users with other programs to create data files in a format my app could also use?