
Why Provenance Matters After Extraction in App Data Forensics
After extraction, provenance helps investigators understand where evidence came from, how it was interpreted and whether a finding can be defended.
Apps go unsupported. Updates break support overnight. Even supported apps can produce results that are incomplete or inaccurate. Firefly reaches the layer underneath: deleted records in WAL, journals and freelist pages, nested structures, ambiguous timestamps, and the file, page and byte offset a finding came from.
Decode SQLite variable-length integers and serial type codes in seconds. Calculate the storage length of strings and BLOBs, determine whether a record requires overflow pages, and identify how much of the payload is stored locally on the database page. Built for fast, script-free analysis of SQLite records and data structures.
Transform iOS backup data into organized, navigable file structures. This free Windows tool extracts and normalizes iTunes backup content, complete with hash verification and device metadata. Access your backup data through a clear, logical file system ready for efficient analysis and reporting.
James Eichbaum
Head of Product & Training
Co-founder
Elusive Data
Start strong. Learn to collect, examine, and explain digital evidence. Build hands-on skills from acquisition to reporting. Perfect for beginners or a skills refresh.
Master mobile forensics, from acquisition to reporting. Built on real cases and today’s Android and iOS challenges. Develop skills beyond tool output.
Investigate the SQLite data behind mobile apps and operating systems. Learn to extract, decode, and interpret data to uncover user activity and artifacts.
Dig into unsupported apps with hands-on SQLite analysis. Use Python to script, automate, and extract what tools miss. Gain a technical edge in advanced mobile forensics.
Learn when it works for you. 24/7 access to interactive lessons, practical exercises, and real-world forensic scenarios. Work through each module at your own pace.
Join live sessions from anywhere. Ask questions, try out techniques, and learn by doing. All the energy of the classroom, without the commute.
Learn in person from expert forensic practitioners through hands-on labs designed to build deep, practical skills.
This free guide provides a practical walkthrough of GPT-partitioned disks, covering the Protective MBR, GPT Header, and Partition Entry Array. It’s designed to help forensic professionals understand disk structures, recover data, and validate evidence.
This guide provides a practical walkthrough for forensic analysts dealing with encrypted Apple Notes in iOS 16.x. It focuses on identifying and decrypting locked notes stored in the NoteStore.sqlite database extracted from iOS backups.
Very good course! Incredibly good teacher and I think that distance learning works at least as well as in the classroom! Thanks again James! Great balance between technical depth and hands-on labs. I liked that we didn’t just rely on tools, but looked under the hood and made sense of the data. It’s definitely helped me write clearer reports and explain findings to investigators.
Best course I have ever taken. I really enjoyed the week, learned a ton, and everything was clear and easy to keep up with. The labs felt real and made sense, even without loads of experience. The instructor explained things so clearly and made it all feel manageable. I would absolutely recommend it to anyone working with mobile forensics.
Our courses sharpen the way you investigate digital and mobile evidence. You learn full workflows that go beyond tool buttons, working with raw data, decoding app artifacts, and practicing authentic case scenarios. Labs and CTF challenges give you confidence to handle live investigations under real conditions.
We offer two certification programs at the moment: SQLite Forensics, and Python for Mobile Forensics. Each program builds practical skills that complement your existing tools and help you see more, find more, and deliver precise results that hold up in reports and courtrooms.
Yes. The training has been fully updated to match the current forensic landscape. That includes support for modern iOS and Android environments, new app structures, updated CTF scenarios, and deep dives into advanced topics like SQLite freelist recovery and manual decoding of WAL/SHM files.
Our tools are built around real forensic workflows and the questions examiners need to answer after extraction. They complement the platforms you already use, helping you work with the underlying data when you need more context, deeper analysis or an independent way to verify a finding.
Firefly brings SQLite, RealmDB, LevelDB, IndexedDB and Apple Biome / SEGB into one forensic workspace for recovery, interpretation, validation and reporting, with a clear path back to the source.
SQLite Visualizer was our dedicated SQLite analysis and recovery tool. Its workflows and capabilities now form part of Firefly, extending the same approach into a broader app data forensic workspace.
VarInt Calculator provides fast, script-free analysis of SQLite variable-length integers, serial type codes, payload sizes and overflow pages.
Backup2FS transforms iOS backups into structured, navigable file systems while preserving hashes, metadata and device information.
The common principle is simple: make the data easier to investigate without hiding how the result was reached.
We first built SQLite Visualizer because we needed a clearer way to investigate SQLite in real cases. The same questions kept coming back: what was deleted, when did it change, where did this record come from, and how can I explain it in a report?
SQLite Visualizer filled that gap for SQLite. It shows deleted records frame by frame, maps schema relationships visually, and recovers data from WAL, freelists and unallocated space. Built from casework and refined in hands-on labs, it makes database analysis faster, clearer and easier to explain.
Firefly takes that same idea further. SQLite is still central, but modern app evidence lives across RealmDB, LevelDB, IndexedDB, Apple Biome / SEGB, BLOBs, timestamps, sidecars and nested structures. Firefly brings that work into one forensic workspace after extraction, so examiners can recover what remains, interpret it in context, validate it against the source and report findings with a clear path back.
From August 31, SQLite Visualizer becomes part of Elusive Data Firefly.
Our approach is built around a simple forensic principle: a decoded value is only useful if you can understand how it was derived and trace it back to the underlying data.
Firefly keeps that source context visible throughout the investigation. Examiners can move between interpreted data, database structures and raw bytes, recover historical or deleted records, and review how a finding was surfaced before carrying that context into the report.
Key capabilities include:
Source traceability
Follow findings back to the underlying file, page and byte offset where applicable.
Integrated structure and hex analysis
Move between records, database structures and raw bytes without breaking the investigative context.
Deleted and historical data recovery
Examine what remains in SQLite WAL, rollback journals and freelists, as well as supported recovery workflows across RealmDB, LevelDB and IndexedDB.
Evidence integrity
Work with read-only evidence handling, evidence-set validation and file hashing as part of the forensic workflow.
Reporting with context
Preserve interpreted values, queries, timestamps, selected records and supporting context in interactive reports.
The result is a workflow designed to make important app data findings easier to verify, review and explain.
You can choose the format that fits your goals and schedule:
Micro-Courses: Short, focused live sessions (60–90 minutes) on specific topics like GPT, SQLite, and encrypted apps — ideal for fast, practical learning.
On-Demand Courses: Access certified, self-paced training 24/7. Replay labs, follow guided exercises, and apply techniques at your own speed.
Live Online Courses: Join expert-led classes in real time. Participate in case discussions, ask questions, and complete labs with instructor feedback.
Classroom Training: Learn face-to-face through immersive sessions and hands-on labs led by experienced digital forensics professionals.
Yes. All full-length courses include a verified certificate of completion and CPE credits, recognized by many professional bodies.
Our training supports all experience levels. You can start with foundational skills like acquisition and validation, or deepen your expertise with advanced techniques such as parsing app databases and scripting with Python for forensic automation.
No. The tools are built to make complex forensic work easier to follow, verify and explain. Whether you are decoding VarInts, navigating an iOS backup or investigating database internals, the goal is to make the process clearer and faster without hiding the underlying evidence.
When you purchase SQLite Visualizer today, a one-hour onboarding session is included to help you get started. After August 31, the same applies to Firefly.
If you need more training, just contact us. We also offer advanced SQLite forensics training, including a certified course where the tools are used as part of the practical workflow.

After extraction, provenance helps investigators understand where evidence came from, how it was interpreted and whether a finding can be defended.

Modern app investigations often involve SQLite, RealmDB, LevelDB and IndexedDB. Understanding these stores helps investigators validate unsupported app evidence.

Many investigators start by looking for a SQLite forensic tool, but the real challenge is broader. This guide explains source-backed app data work, provenance, validation and how Elusive Data Firefly extends the workflow beyond SQLite.

Elusive Data announces Firefly, a forensic workspace for modern app data evidence, launching August 31 with recovery, validation and reporting workflows.

James Eichbaum on the idea behind Elusive Data Firefly, why provenance matters after extraction, and why honesty is a forensic feature.

A practical guide to SQLite forensic validation: when a normal SQLite viewer is enough, when deeper review is needed, and how investigators can check WAL files, SHM, freelists, freeblocks, deleted records and source context before reporting.

SQLite forensics explained in simple terms. Learn how SQLite databases store data, where evidence is hidden, and why it matters in digital investigations.

Protobuf varints are not SQLite varints. Learn how to parse Protocol Buffer data from Apple Notes and mobile forensic artifacts, decode LEB128 varints step by step, and build a Python decoder with bitwise operations. Includes a hands-on XOR decryption challenge.

A practical guide to choosing a SQLite forensics course, including WAL and SHM analysis, deleted records, labs, validation and forensic reporting.
Thank you for a great course! I finally get how to work with unsupported apps. That clicked during this course. I’ve done a few trainings before, but this one stood out because it was actually useful right away. The instructor explained how app data is stored in a way that made sense, and I really appreciated all the real examples. I’ve already used a few techniques in a current case.