Populating a ListVIew using SQLite and Server Data?

Yes this sounds like a good strategy. The key point here is to wrap the two data sources (SQLite and Server Data) into single source and to fetch data from it Yes is sounds like a good strategy When you modify the underlying data set you should call notifyDataSetChanged which will force the adapter to refetch it's data As I said the key here is to have single data source structure from which the adapter will fetch data. The best solution here will be to use temporary table.

Basically temporary table exist only in the life of a single connection to the database, so when you close your connection the table will be dropped automatically. When you open the database create temp table and insert all messages in it. When downloading new messages insert them in the real table and in the temp table but when you download old messages insert them only in the temp table.

And finally use only the temp table to fetch data.

Yes this sounds like a good strategy. The key point here is to wrap the two data sources (SQLite and Server Data) into single source and to fetch data from it. Yes is sounds like a good strategy.

When you modify the underlying data set you should call notifyDataSetChanged which will force the adapter to refetch it's data. As I said the key here is to have single data source structure from which the adapter will fetch data. The best solution here will be to use temporary table.

Basically temporary table exist only in the life of a single connection to the database, so when you close your connection the table will be dropped automatically. When you open the database create temp table and insert all messages in it. When downloading new messages insert them in the real table and in the temp table but when you download old messages insert them only in the temp table.

And finally use only the temp table to fetch data.

I like your solution to question 3 - thanks! – Vicki D Aug 3 at 7:36.

Im not sure what you mean by updating a cursor. Here is my two cents. Create a service/ thread which updates you data base.

Since you said similar to mail this can help you notify the use as new messages arrive in the notification area. Then every time the user starts the activity query from the data base. You can use time stamp or messageId to avoid conflicts.

Yes you're right - I can sync the data in the background and then when the activity starts the new data will be loaded from the sqlite db. I think that will sort question 2. My big stumbling block is question 3.

How do I stick together data from sqlite database and data from server in one list? – Vicki D Aug 3 at 7:08 you always read from on place and that will be the sqldb. And you will always write to db from server.

Try to keep it simple. Try to use some unique id to identify each message uniquely. – Sam Quest Aug 4 at 2:07.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.