SQLite is a self-contained SQL database engine that is used on every smartphone (including all iOS and Android devices) and most computers (including all Macs and Windows 10 machines). Each computer or phone using SQLite often has hundreds of SQLite databases and it is estimated that there are over one trillion SQLite databases in active use. Given the above, the importance of examining all of the data held in these databases in an investigation is paramount, and of course this includes examining deleted data whenever possible.In this book we cover the format of the SQLite database, and associated journal and Write-Ahead Logs (WAL) in great detail. We show how records are encoded, how to decode them manually and how to decode records that are partially overwritten. We also describe how the workings of SQLite, and in particular the journal and WAL, can be used to ascertain what has happened in a manner that cannot be determined from the data alone. We cover basic SQL queries and how they can be used to create a custom report that includes data from different tables, and we show how we can use SQL queries to test hypothesises about the relationships of data in different tables.This book is aimed mainly at forensic practitioners, and it is assumed that the reader has some basic knowledge of computer forensics; it will also be of interest to computer professionals in general particularly those who have an interest in the SQLite file format.
✔ Author(s): Paul Sanderson,Dr. Richard Hipp,Brett Shavers,Heather Mahalik,Eric Zimmerman
✔ Title: SQLite Forensics
✔ Rating : 4.6 out of 5 base on (42 reviews)
✔ ISBN-10: 1980293074
✔ Language: English
✔ Format ebook: PDF, EPUB, Kindle, Audio, HTML and MOBI
✔ Device compatibles: Android, iOS, PC and Amazon Kindle
Readers' opinions about SQLite Forensics by Paul Sanderson
Keira Graham
Discover the magic of first love and self-discovery in this enchanting coming-of-age story. The author's lyrical prose and relatable characters create a heartwarming narrative. Each chapter explores the joys and challenges of growing up with sensitivity and insight. The emotional journey is both poignant and uplifting. It's a story that resonates with readers of all ages. Ideal for fans of young adult fiction.
Elvenia Connolly
Follow the thrilling adventures of an unlikely hero in a world full of danger and intrigue. The author's fast-paced writing and imaginative plot keep you on the edge of your seat. Each character is well-developed, adding depth to the exciting narrative. The twists and turns make for a rollercoaster of emotions. It's an exhilarating read that captures the essence of adventure. Perfect for fans of action-packed stories.
Alicia Lawrence
Delve into the dark and twisted world of a psychological thriller that keeps you guessing. The author's masterful storytelling and complex characters create a gripping narrative. Each plot twist is meticulously crafted, adding to the suspense. The tension builds with each chapter, making it impossible to put down. It's a chilling and captivating read that explores the depths of the human psyche. Perfect for fans of psychological suspense.
