4 ms·
The early Trillian ~0.72; that one I really loved; I found Miranda later, so that I never really used. A while ago I digged around in my computer and collected
by pmlnr 10y ago
The early Trillian ~0.72; that one I really loved; I found Miranda later, so that I never really used.
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.
- justusw 10y agoMost versions of Skype use SQLite for local storage, if that is of any help!
- pmlnr 10y agoI didn't know that; I'll take a look. This was the Linux version 2.x era, mostly.
- turrini 10y agoI've made a converter for 2.x series, reach me at turrini at gmail
- BorisMelnik 10y agowhats the best front end program to read those databases, for non-db folks? (windows or linux / CLI or GUI)
- mutagen 10y agoThere'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-manager/ https://addons.mozilla.org/en-US/firefox/addon/sqlite-manage...
- SturgeonsLaw 10y agoSQLite Studio works great http://sqlitestudio.pl/ http://sqlitestudio.pl/
- dingdingdang 10y agoYup, I can second that, stable with good feature set.
- marios 10y agoI 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 ! [0] https://suurjaak.github.io/Skyperious/index.html https://suurjaak.github.io/Skyperious/index.html