Using CursorLoader to query SQLite DB and populate AutoCompleteTextView

Question

I have a SQLite database I would like to query. I want to target Android 2.2 through ICS. I came across this article on how to do this, but it uses deprecated code (does not query asynchronously, but on the UI thread). I've since read that I can use CursorLoader along with LoaderManager to do this task the preferred, best practices way (as to not bog down the UI thread).

The problem is finding a concise example to explain to me how to do this. 1) Load the database, 2) query it, 3) use the result to populate an AutoCompletetextBox list view.

Does such an example exist?

Answer 1

I know this is an old question but for people who visit this page:

SimpleCursorAdapter has a new constructor:

SimpleCursorAdapter(Context context, int layout, Cursor c, String[] from, int[] to, int flags)

this cunstructor does not use UI thread. You can use it safey.