This is one of my favorite databases.
You need to examine this.
There is a query available in the books for you.
There's a query available in the course notebook.
I want to mention at this point, every query
that you see that's in the notes,
those will also be available in the course notebook
because I realize you can't copy and paste easily
from the books.
So it will be in that notebook, that you can go to Evernote
and copy and paste it from there.
Localappstate.db is going to give you
a package name and a delivery.
It is going to track every single app that
is loaded from the Play Store.
Now, this is where you're probably thinking,
what if it's not from the Play Store?
It's not going to be tracked here.
You are going to work some labs this week where apps
are sideloaded or are malware.
When you think of the term sideloading,
is essentially coming from somewhere
that's not the App Store.
A good example--
I was doing a presentation for Latin America.
And they see some application that's called WhatsApp Plus.
It looks very similar to WhatsApp.
But it's different.
Instead of being green, it's blue.
And I think it gave me some malware, to be honest.
I downloaded it from the internet,
and I installed it onto the Android.
My Android is not rooted.
It doesn't need to be to have sideloaded applications.
WhatsApp Plus would not be tracked in local localappstate
because it did not come from the Play Store.
But there is a file that we're going
to talk about coming up that's called frosting.db
that will store it.
Now, keep in mind with frosting, it
sounds sweet, so you may need root or physical access
to get it.