Reading SMS from the terminal?

[SocialNetworkingWasAMistake]

I am pretty sure somebody posted the location of the text files that chatty displays (cannot find it right now). Something like a .var/chatty/... directory?

You should be able to find out which files the chatty process loads, e.g. using 'ps'.

Hope this helps

  lacriz

Looking at lsof it looks like the file I'm looking for is /home/mobian/.purple/chatty/db/chatty-history.db so I guess I need to figure out some way to read an sqlite db from the terminal

Edit: came up with this and threw it into my .zshrc, works great

Code:

alias txts="sqlite3 ~/.purple/chatty/db/chatty-history.db -box \"select datetime(messages.time, 'unixepoch') AS time, threads.alias AS contact, replace(messages.body, char(10), ' ¶ ') AS message from messages join threads on messages.thread_id=threads.id order by time desc;\" | less -S"