Loading data into an android database
AutoCompleteTextView I wanted to demonstrate how it is possible to back an AutoCompleteTextView with data from a database Cursor. To do this I needed to put a few thousand rows of data into the SQLite database on the device. I got my list of words here: http://www.wordlistgenerator.net/ I just left it with the default options to give me a nice long list. I took the apostrophes out to avoid having to escape them - I am only looking for semi junk input afterall. Location of 'words' file I saved the list into a file called 'words'. Note that there is no extension here. I am going to use this as a resource in Android and the extension interferes with this. I dropped the file into my res/drawable folder (as good as any) in order to be able to access it with my load method below. Then I used the following code to load the rows from words into the database: public void load() { SQLiteDatabase db = getReadableDatabase(); try { InputStream is =...