Comparing SQLite databases on Android

Question

In my application I have an existing SQLite database attached. On start it's copied to phone and then being used. I know how to check if this database is already copied, but I want to check if database on the phone is the same as stored in APK. Is there any way to compare them? I want to do that programmatically.

Original database is stored in assets folder.

Yeah, that's a good idea. How can I get sizes of these files? Original is in assets folder in my APK, and copied is in /data/data/my.package/databases/. — Roman
– Roman, Commented Apr 6, 2012 at 6:57
for assert db: context.getAssets().open("assert_db").available(); and new File("/data/...").length(); for the actually db. — idiottiger
– idiottiger, Commented Apr 6, 2012 at 7:02
ye, the available sometimes has some problem, so you can read full content to memory, you can get the bytes size, or you can save the size with hardcode. maybe the hardcode is not a good idea, it depend on your requirement. — idiottiger
– idiottiger, Commented Apr 6, 2012 at 7:51

Bhavin · Accepted Answer · 2012-04-06 06:32:38Z

1

If you have a rooted Phone then you can Watch the Details of It. but if your phone is not rooted then you are won't be able to see it.

Another thing if you have copied the Application in your Phone then it will definitely work.

So Conclusion is that If you have a Rooted Phone then you will be able to See and Compare, if possible try to compare its size or Time on which it is Installed.

answered Apr 6, 2012 at 6:32

Bhavin

6,0204 gold badges26 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tofeeq Ahmad · Accepted Answer · 2012-04-06 06:48:34Z

1

If you have attach a DataBase with your APK and you successfully copied to your phone that exactly means that you have your old data base copied.So i think no need to compare.If you want to compare then compare all record in Table.

Second if you want to remember that your data base is already copied then use one flag in share preferences.Save true once copied.Then check its value

Updated

To listing all Table

select name from sqlite_master where type = 'table'

If both data base have same table then compare record of these corresponding Table

edited Apr 6, 2012 at 6:48

answered Apr 6, 2012 at 6:38

Tofeeq Ahmad

12k4 gold badges63 silver badges89 bronze badges

4 Comments

Roman Over a year ago

Original database contents are going to change, but it wouldn't replace the old one on phone because it is already there. That's why I'm trying to find a way to compare them.

Tofeeq Ahmad Over a year ago

It will not replace then you can compare Total Table if both have same number Table then compare records that's the way to do it

Roman Over a year ago

I'm not sure how to open database in my APK.

Tofeeq Ahmad Over a year ago

But your question state that you copied it. and just want to compare both data base.

Collectives™ on Stack Overflow

Comparing SQLite databases on Android

2 Answers 2

Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related