Most versions of Skype use SQLite for local storage, if that is of any help!
I didn't know that; I'll take a look. This was the Linux version 2.x era, mostly.
I've made a converter for 2.x series, reach me at turrini at gmail
Re:ICQ: 20 Years Is No Limit
by BorisMelnik on Tuesday November 15, 2016 @11:07PM
(#12964458)
whats the best front end program to read those databases, for non-db folks? (windows or linux / CLI or GUI)
There's a reasonably full featured plugin for Firefox called SQLite Manager that lets you open arbitrary SQLite files and browse / edit the contents.
https://addons.mozilla.org/en-US/firefox/addon/sqlite-manage...
Re:ICQ: 20 Years Is No Limit
by SturgeonsLaw on Wednesday November 16, 2016 @04:03AM
(#12965475)
SQLite Studio works great
Re:ICQ: 20 Years Is No Limit
by dingdingdang on Wednesday November 16, 2016 @08:38AM
(#12966711)
Yup, I can second that, stable with good feature set.
I recently stumpled upon Skyperious[0]. I intend to test the merging feature soon (multiple computers and unsynced chat logs annoy me more that they should). So far the viewing works fine !
A while ago I digged around in my computer and collected _all_ the chat logs I was able to find: Trillian, MSN, Pidgin, Empathy, Thunderbird, XChat, Facebook, and normalized them to plain text. They were in all sorts of formats: line-by-line XML, JSON, per file JSON, per file XML, text, HTML. (I had to exclude Skype due to it's binary log.) If you have any logs, do a similar normalization as soon as possible, it will only get more painful. Anyway, the trillian logs were exceptionally ugly with with the line-by-line all data in attributes XML, but hey, the user interface and the connect to any platform was awesome.