Trying to answer this question How to backup large contact photos?, I wanted to compare the picture size after restore

I do see a database for contacts , as mentioned in Narayanan's answer here - location hasn't changed from Gingerbread days !

/data/data/com.Android.providers/contacta/databases/contracts.db

How do I see the picture and it's size ??

I gather one has to SQLlite viewer but Apps from play store didn't help and I am new to SQL stuff. It would be nice if I can get a way of doing this (preferably without using PC but if that's inevitable , it's fine )

Edit:

  • Android version 6.0, Rooted

  • When I see /data/data/com.android.providers.contacts/files/photos/ they pertain to WhatsApp photos not contact pictures

  • What Android version are we talking about? Did you already check at /data/data/com.android.providers.contacts/files, if present? – Death Mask Salesman Jul 13 '17 at 10:19
  • @DeathMaskSalesman: updated question – beeshyams Jul 13 '17 at 10:30
  • That folder can only be opened as root. Are you rooted? Furthermore, WhatsApp cannot alter it, but it may be possible that the above app makes use of the Contacts Provider, which in turn stores WhatsApp's contact thumbnails. – Death Mask Salesman Jul 13 '17 at 10:39
  • @DeathMaskSalesman of course the device is rooted, otherwise wouldn't be able to see /data/data. Coming back to the question, maybe WhatsApp does as you suggested but I am trying to locate my contact pics – beeshyams Jul 13 '17 at 10:44
up vote 2 down vote accepted

Assume you're using an AOSP ROM, you just missed the correct answer:

/data/data/com.android.providers.contacts/files/photos

Whatever the original size of the image is, it will be resized to 720*720 and shrinked to less than 64 KiB.

To verify this by yourself, get these commands executed in a root shell. You need BusyBox or Termux for find and xargs Android M introduced ToyBox which has find and xargs built in.

# cd /data/data/com.android.providers.contacts
# ## Add a picture of your choice to a contact
# find -type f | xargs ls -t

See the output. find -type f outputs every single file found under current working directory, and xargs use piped stdin as arguments to ls -t, which lists and sorts all files from the command line by last modification time. You will see that the top 3 files are

./databases/contacts2.db
./databases/contacts2.db-journal
./files/photo/3 (num. varies dpd. on your env.)

The answer is clear as seen above.

  • No need to specially spacify toybox. It is already symlinked in /system/bin – iBug Jul 13 '17 at 11:20
  • OK.. Ran those commands on Terminal Emulator and see the output as you said and the interpretation Accepting the answer +1. But my doubt remains – beeshyams Jul 13 '17 at 11:33
  • This supports 720 by 720 - which means this hasn't changed from Kitkat – beeshyams Jul 13 '17 at 12:09
  • Also while the size part is clarified , where are they stored, which is kind of incidental - if you can address that and add to your answer it would be nice – beeshyams Jul 13 '17 at 12:46
  • For high res images, I supposr it's handled by your Contacts frontend app, because it's not what Contacts Storage should do. – iBug Jul 13 '17 at 14:36

Your Answer

 
discard

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.