SQLite3
Latest
Trick your iPhone voicemail into using voice recording data
The other day, I discussed how to record audio on your iPhone. Several people wrote in asking whether they could have their recordings show up in voicemail, so I scouted around a bit. I discovered that voicemail is stored in ~/Library/Voicemail and that it uses an sqlite3-compatible database to manage that information. Last night, I put together a shell script that allows you to trick the iPhone into thinking that amr files added to the voicemail folder are actual voicemails. To make this happen, I ported sqlite3 to the iPhone (You can download a copy here). I also wrote a csh script, which you can download here and a time utility, here. The reason I wrote the script in csh rather than bash (both of which appear in the standard binary distribution kit) is just that I'm more familiar with csh. To run the script, supply it with the amr file as its one argument, e.g. copy2vmail foo.amr. The script copies the amr file to the voicemail folder and updates the voicemail database as if the voicemail were received at the current time. To force voicemail to update and re-read the database, enter the phone application and quit it by holding down the home button for 4-8 seconds. Re-enter the phone application and, with luck, you will see the recording as new voice message from "VoiceRecorder". Thanks, Spaced.
Scanning your iPhone Backup Files
Here's a nice way to recover notes from your iPhone without having to mail them to yourself--although it's not for the faint of heart. James Duncan Davidson located where iTunes stores its iPhone backup data--at least mostly. There's an error in his write-up. It's actually stored in your home folder's application support directory in MobileSync/Backup. For me, that works out to be /Users/ericasadun/Library/Application Support/MobileSync/Backup. But getting back to Duncan Davidson's story, he took a peek at those files and noticed they were some sort of compressed SQLite3 files. Following on that, "Mr. Flip", who is one of the iPhone web developer Google group members posted this simple extraction utility written in Perl. When run, it converts each of the backup files to a normal well-named SQLite3 db file. Following Flip's directions, I then downloaded a copy of the OS X version of SQLite Browser from Sourceforge and used it to view the contents of the backup db files. Interestingly enough, when viewing the db files directly from the command line (via sqlite3 notes_01.db and .dump) I discovered that the iPhone saved my entire history of edits for my note files as well as the actual final content.
