How to display sqlite contents

I'm not that exp开发者_如何学运维erienced so I may have missed something obvious. What I am trying to achieve is a search feature for the database.

The two methods I'm thinking of are either an edittext and a listview and everytime the edittext changed a query is run and the listview is updated. Or populating the listview with all the data and then filtering it.

If I went for the second option I'm guessing it is less demanding on memory plus could I hide all the contents while the edittext is empty?

Any examples of implementation would be helpful too.

Thanks

A good place to start is the Android Dev Guide under the Data Storage section. Have a look at the Searchable Dictionary sample there.