cjelly

# Where iphonesms.db is the sqlite database that iTunes creates when you perform a backup

sqlite3 -header -csv iphonesms.db "SELECT chat.ROWID, message.ROWID, message.date, chat.guid, message.is_sent, message.date_read, chat.chat_identifier, message.text
FROM chat, message, chat_message_join
WHERE chat.ROWID = chat_message_join.chat_id AND message.ROWID = chat_message_join.message_id
ORDER BY message.date;" > chat_joined.csv