This is an interesting story where the FBI could recover private Signal messages on an iPhone.
Even though the suspect had deleted all her messages and uninstalled the App, there is something nobody (but the Agency) thought about: notifications.
Notifications are so ubiquitous, part of the daily life, really - who would think they could be a security loophole ultimately sending you to jail…
With a notification, usually the phone will shows a little preview on the screen and it is then stored by the OS in the iPhone’s push notification database. Just have to read it in cleartext - so easy and convenient!
As I’ve always said: convenience is usually the enemy of security
And supplementary question … even if, let’s say, a notification is temporarily stored somewhere and then subsequently deleted … is it really deleted?
If you store a row in an sqlite database and then delete the row … is the information really deleted? It can be quite difficult to gain control of that kind of thing when you have layers of software. This is in no way specific to sqlite.