Saturday, January 19, 2013

Find messages in skypes new database format

The db changed from that custom format similar to Kazaa to sqlite3, so to find stuff you now just write sql (sqlite3 flavour is a bit weird though). See this example and use .help, if you are stuck.

select author, body_xml from messages where strftime('%Y-%m-%d', timestamp, 'unixepoch') == '2013-01-18' and author == 'user';

No comments:

Post a Comment