posted to this is not a weblog
on oct 28th, 2007

tagged iphone, nerd, sqlite
and commented on once

share this page

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.


leave your comment or contact me

if you want to be able to mark your comment as authentic or delete it later, include your e-mail address (it won't be shown on the site). you'll be e-mailed instructions with a copy of your comment.

basic html allowed; be nice
required


optional, gravatar-ized


optional