Making complex data simple and compelling
From digital device to digital evidence
Unlock your vehicle's digital evidence potential
Forensic Analysis and Enhancement
Investigating and analyzing financial records
Gain access to the online accounts of deceased loved ones
Clear, precise evidence for a messy world
Expert reports to suit your specific needs
We can locate people anywhere
Stop worrying and learn the truth
Prevent, Detect, Respond To Cyberattacks
First response is crucial. Every minute counts.
The first response is critical to reduce liability
Detection & Removing Spyware Services
Reduce your electronic risk from digital transmittals
Find out who you are really talking to
Experienced, Confidential Services
Swift, professional incident response
Complicated cases require compelling digital facts
Find, recover and document digital evidence
Bring solid evidence before a judge
Cases can be investigated using Social Media
Divorce, custody battles, and other
Win the most important battle of your life
Everything you need
Effective Expert Witness in Court
Evidence shows who is telling the truth
Subpoena power yields strong evidence
Digital evidence can build a strong defense
Go to court with compelling digital evidence
There are a lot of posts about failing to be able to ascribe a contact to a remote post on IOS SMS.db rebounds. Previous Paul’s post (“SMS recovered records and contacts – three ways”) shows another way to establish a relationship between two sets of records deleted.
This post explains how the database schema can be used, and foreign key constraints and triggers to understand why the removal of one element can have a knock on effect and not as the circuit can be used to explain why these records are no longer available.
Below, the author covers the triggers and foreign key constraints in a small number of parts, but the full scope goes far beyond the scope of this article. It is important to understand that a trigger is a function of SQLite and the database it is defined on and once defined whether it runs or not is not within the control of the programmer, but is controlled by the settings of the database – i.e. the actions are carried out automatically by the SQLite library.
This is a fairly broad topic and in a nutshell it does not tell. For those who have an interest or a Forensic Toolkit for SQLite user in this post you will gather a lot of interesting ideas.
Save my name, email, and website in this browser for the next time I comment.
Speak to a Specialist Now
Get Help Now