The database found at USERDATA/data/com.android.vending/databases/frosting.db is extremely helpful at proving an application existed on the device. Here we will see the application name, application path, and last update timestamp and data, which may provide additional data about the application. The query below will help you parse this file. This query is also in your course notebook.

select

pk,

apk_path,

datetime(last_updated/1000,'UNIXEPOCH','localtime') AS "Last Updated",

data

from frosting