

However, you will notice that the getInstance method does in fact use getWritableDatabase (getReadableDatabase actually gets a writable database unless there are issues in that the database cannot be written to). The Working Example above does away with the loadHandler. Public class MainActivity extends AppCompatActivity String result = "" SQLiteDatabase db = this.getReadableDatabase() Might be creating still the issue. I've gone over this for hours and can't see what is going on her is my code The program crashes every time saying the table I am querying can't be found, but it also seems that all of the try catch statements are being overlooked in that I deleted the database from my assets folder and it still is giving me the same response. With a simple convert you can use them as double double mydouble = Double.parsDouble(list.So I found a video online that walks you through the whole process of simply displaying a SQLite database, and once I get this down I can move forward but I can not seem to get it to work. Lets do it in code : String str = db.getdata() get the column from database pure it to String and with the splite() opration pure each values of array in a column of array than u can easily use it :) When you want to fetch them and use the values. public static void storeInDB(ArrayList longs) throws IOException, SQLException I think Con's approach is probably better than using java serialization since java's builtin serialization will need additional bytes, and non-java applications will have a harder time dealing with the data.

The other answers over there are also very pertinent. VARCHAR for storing arrays in a MySQL table. Please forgive me for savagely plagiarizing my previous answer to BLOB vs.
