posted to this is not a weblog on sunday, october 28th, 2007 with 1 comment
tagged iphone, nerd, sqlite

a tip for iphone owners: a lot of the information stored on the phone like the call history, voicemail, and sms messages is kept in sqlite3 databases.

so when your friend's girlfriend takes your iphone and sends messages to your friend that seem weird and gay to you the next day (thanks jenny) when viewing your message history, you can delete them without clearing out the whole conversation history.

jcs@hornswagle:~> scp root@192.168.1.61:/private/var/root/Library/SMS/sms.db .
root@192.168.1.61's password: 
sms.db                                                                 100% 21KB  21.0KB/s   00:00    
jcs@hornswagle:~> sqlite3 sms.db 
Loading resources from /var/home/jcs/.sqliterc
SQLite version 3.4.1
Enter ".help" for instructions
sqlite> delete from message where text like '%blow%';
sqlite>
jcs@hornswagle:~> scp sms.db root@192.168.1.61:/private/var/root/Library/SMS/

it might be kind of funny to take someone's iphone and insert fake records into that database and make them think you sent text messages that were never really sent. someone should make a sqlite3 package for apptapp so these edits can be done directly from the terminal on the iphone.

one comment
Bob (authentic) on october 29th, 2007 at 09:19:58:

Imagine what you could do to someone considering big brother today: I little porn, a little IRS, sprinkled with some dope and blended with a redrum plot. Nice law and order episode.