using sqlite to get access to notes

[copland007]

I'm a little too tired to actually give you great news saying I have a way to sync your notes, but I can give you a way to get access to the notes data...

The notes are stored on the iphone in sqlite format, so first grab a sqlite binary from here if you don't already have it on your machine: http://www.sqlite.org/download.html

Load up your favorite iphoneinterface and grab your notes.db:

cd /private/var/root/Library/Notes/
getfile notes.db

Then to play around with your notes database pass in the filename to sqlite binary, something like this

sqlite3 notes.db

That will drop you into the command line and you can go wild, for docs on sqlite usage see this: http://www.sqlite.org/sqlite.html

[Kyle Matthews]

Nice. Good info.

Wiki'd!