SQLite for Automagic

[VitPMir]

Sorry, but in every Android phone sqlite3 console utility exists. So, no need to write more code instead of SQL

Not all phones have sqlite3. I do not have (Mi Max 2). And to install this utility you need root.

[anuraag]

VitPMir's method is better. I have been playing with the code and it's going well. I am using query instead of rawQuery in my flow.

This code can be used to close database.

Code: Select all

callJavaMethod(objDb, "android.database.sqlite.SQLiteDatabase", "close()");

[VitPMir]

This code can be used to close database.

Thanks.

[fagci]

Not all phones have sqlite3.

Maybe that is without custom ROM. I always flash new smartphone, coz stock is bad for me. ㄟ(ツ)ㄏ

[Desmanto]

Mine is RN5 with AEX 6.7 Pie 9.0 ROM, and I have sqlite3 binary here. I just found out that adb shell also have the sqlite3 binary baked in. But of course it is useless as we need PC to work with.