Limit Records fetched in Android (Sqlite database)

Question

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: