Create List In Android App

I want to know a good way to create a list in my android app. I have all info in my DB and want to load data from it each time I start the app and make a list from it (id and title

Solution 1:

You can use either JSON or XML.

You can use the web service approach or you can include your db with your application.

In fact, I most often choose to create a sqlite3 database of my data and include it in the assets folder, which can be copied to the app's data folder on startup.

As for copying your sqlite3 database from assets/ to the db data directory, I found these instructions helpful.

Solution 2:

In your situation I would pick JSON over XML for all the reason's stated in the following post: http://ajaxian.com/archives/json-vs-xml-the-debate

Plus, in android, there are JSON Array's built in by default so you don't have to do any extra passing of the code.

returnnewJSONArray("my json string goes here..."); 

Since we are talking about a mobile device, I would always generate changes in your php script rather than have a full sync as this will be a lot smaller in size that a full sync. However, you will need to give your user a option to do a full re-sync if this is applicable to your app. I would use a SQLite database to store the data and only update the changes in that.

To also make the stream smaller, you can gzip compress your output from php as this can be natively read by the android device. In my app, I compress 500kb down to ~110kb before transmitting, a huge saving on performance. Here a partial example of how to read the stream:

InputStreamin=null;
HttpURLConnectionhttpConn=null; // you will have to write your on code for this bit.if (httpConn.getContentEncoding() != null) 
{
StringcontentEncoding= httpConn.getContentEncoding().toString();
if (contentEncoding.contains("gzip")) 
{ 
    in = newGZIPInputStream(httpConn.getInputStream());
}
} 
else 
{ 
    in = httpConn.getInputStream();
}

I hope that this all makes sense, it's been a long day programming :)

Stu