SQLite Databases Part 2: Understanding Location Data and Timestamps
Special Guest: Matt Goeckel, Solutions Engineer at Cellebrite
In this episode, we’re joined by Matt Goeckel, a Solutions Engineer at Cellebrite, to discuss various aspects of SQLite. In Part 1 of the series, we focused on how to identify columns, write select statements, order counts, and filtering.
In Part 2, we’ll primarily focus on joins and then touch on timestamps.
We’ve prepared numerous files that require timestamps, and we’ll use them to better explain and demonstrate how it works with SQLite.
This episode will also cover how to:
- Tackle calendar reminders featuring their own data source files
- Understand and uncomplicate location data
- Verify parsed data
- Understand history tags
To learn more about SQLite, joins, and time stamps watch the episode.