[android-developers] Re: How to store questions for quiz type application

2010-08-04 Thread amos
Thanks guys for opinion. I'm already working on SQL based version of the application. -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group,

[android-developers] Re: How to store questions for quiz type application

2010-08-03 Thread Bob Kerns
True enough, and if you are only reading, atomicity doesn't matter. But if you want to record answers? Files are well suited to either read-only uses. But once you start writing, you have the potential for partial updates unless you use a rename or delete to mark the end of the update. Which is

[android-developers] Re: How to store questions for quiz type application

2010-08-03 Thread Paul Turchenko
I would go with storing your questions in raw XML file (asset) and parsing it on the fly. This way, you can easily change it and (perhaps) later extend your aplication to communicate with web service that has questions. IMHO using database for this is a bit wasty. On Aug 3, 8:56 am, Sarwar Erfan

[android-developers] Re: How to store questions for quiz type application

2010-08-03 Thread ko5tik
On Aug 3, 10:48 am, Paul Turchenko paul.turche...@gmail.com wrote: I would go with storing your questions in raw XML file (asset) and parsing it on the fly. This way, you can easily change it and (perhaps) later extend your aplication to communicate with web service that has questions. IMHO

[android-developers] Re: How to store questions for quiz type application

2010-08-03 Thread Bob Kerns
I agree. My experience with this sort of thing is that frequently, if you don't start out with a SQL database, you ultimately end up having to convert it later. So often it's better to start there. Here's why. Using a database scales better. If you end up with a large quiz, you'll have to load

[android-developers] Re: How to store questions for quiz type application

2010-08-03 Thread DanH
For just 500 items, if random access is required I'd go with SQL, assuming the text length for a single item isn't more than a few hundred bytes. You do have the problem of loading up the DB, though. For a really large list I might spend some time designing the preprocessing logic to build

[android-developers] Re: How to store questions for quiz type application

2010-08-03 Thread DanH
Further, while with some careful attention to detail, you can get reliable operation with files, even if the device is turned off at a bad moment -- too often people don't manage to get it right. (Key idea - the only atomic filesystem operations are rename and delete). Seems to me that opening a

[android-developers] Re: How to store questions for quiz type application

2010-08-02 Thread Sarwar Erfan
Hi, Put your all questions in SQLiteDatabase. Then, load the necessary ones when required in the application. Storing and loading from file will not be very useful. Database will help you organize the questions better and also to retrieve the required ones smartly. Regards Sarwar Erfan On Aug