WEBVTT

00:00:01.791 --> 00:00:05.061 align:middle line:84%
Now let's talk some
considerations.

00:00:05.061 --> 00:00:08.151 align:middle line:84%
When a new database is
released, whether it's

00:00:08.151 --> 00:00:12.051 align:middle line:84%
through an application
or through an iOS update,

00:00:12.051 --> 00:00:13.431 align:middle line:90%
what actually changed?

00:00:13.431 --> 00:00:16.901 align:middle line:84%
So the first thing you have to
figure out, is it a new file?

00:00:16.901 --> 00:00:20.851 align:middle line:84%
Is it a file with a similar file
name, but in a different path?

00:00:20.851 --> 00:00:23.371 align:middle line:84%
If it's not a new
file, was a new table

00:00:23.371 --> 00:00:25.021 align:middle line:90%
added to that database?

00:00:25.021 --> 00:00:28.561 align:middle line:84%
Is it simply that a new column
was added to a database?

00:00:28.561 --> 00:00:30.961 align:middle line:84%
Did the time stamp
format change?

00:00:30.961 --> 00:00:33.151 align:middle line:90%
Did a column name change?

00:00:33.151 --> 00:00:36.871 align:middle line:84%
Is the data now being embedded
as a Protobuf or a BLOB?

00:00:36.871 --> 00:00:40.681 align:middle line:84%
Is it being embedded
as a binary plist?

00:00:40.681 --> 00:00:43.471 align:middle line:84%
All of these things
come into play.

00:00:43.471 --> 00:00:46.591 align:middle line:84%
In the labs of this
section, you are

00:00:46.591 --> 00:00:49.074 align:middle line:84%
going to work an entire
backup and answer questions.

00:00:49.074 --> 00:00:50.491 align:middle line:84%
But then, you are
also going to be

00:00:50.491 --> 00:00:53.691 align:middle line:90%
challenged with this situation.

00:00:53.691 --> 00:00:59.271 align:middle line:84%
With iOS 15 and also 14,
Photos.sqlite changed.

00:00:59.271 --> 00:01:01.191 align:middle line:84%
There's a change
in that database

00:01:01.191 --> 00:01:03.531 align:middle line:84%
that you have to find
and manipulate in order

00:01:03.531 --> 00:01:06.711 align:middle line:84%
to parse key artifacts
that your tool may not

00:01:06.711 --> 00:01:07.701 align:middle line:90%
be parsing for you.
