Limit Records fetched in Android (Sqlite database)

Question

Hi.

I am trying to fetch sms messages from inbox, sent items and drafts. I would like to do a pagination for my list view for that it's imperative that I fetch records in pages/chunks.

I am not familiar with sqlite which is the database I understand android use to store the data. Can someone tell me how can I restrict the number of records I am fetching by using contentResolver.query?

Also what is the way to pull the sqlite database file onto my machine and browse/query it locally to experiment or see data on my machine?

Are there any other better ways to implement pagination in android??

Thanks

Answer 1

According to the Sqlite website, you can use a LIMIT ... OFFSET ... clause in your query:

http://www.sqlite.org/syntaxdiagrams.html#select-stmt

Answer 2

These should help you
http://osdir.com/ml/Android-Developers/2010-03/msg04308.html
http://groups.google.com/group/android-developers/browse_thread/thread/b355f032064b7571

Answer 3

To pull your database for viewing, make a copy of it on the SD card and then use adp pull to get it.

Answer 4

There doesn't seem to be any way to limit your results from the SmsProvider. However you shouldn't really need to, given that you use CursorAdapter and don't try to read the contents into your own data structures. Have you tried this?