Skype main.db
From Just Solve the File Format Problem
(Difference between revisions)
(Added references to Skype skype.db; added Category:Microsoft because this format, even though it was not created by Microsoft, was created by a company that later became a subsidiary) |
(Removed now-redundant basic information on skype.db) |
||
Line 7: | Line 7: | ||
<!--Test to see if it's possible to edit --> | <!--Test to see if it's possible to edit --> | ||
− | From 2008<ref>O'Connor, T.J. ''Violent Python: A Cookbook For Hackers, Forensic Analysts, Penetration Testers And Security Engineers''. Elsevier, 2013. p. 110. [https://archive.org/details/ViolentPythonACookbookForHackersForensicAnalystsPenetrationTestersAndSecurityEngineers/page/n109?q=main.db IA link]</ref><ref>https://web.archive.org/web/20080716022445/http://www.skype.com/intl/en/download/skype/windows/beta/ Note the date.</ref> to 2017<ref name="MS_QA">https://answers.microsoft.com/en-us/skype/forum/all/where-is-the-maindb-file-for-new-skype/b4d3f263-a97e-496e-aa28-e1dbb63e7687</ref>, when a split occured and some versions replaced it with [[Skype skype.db|skype.db]] (see that page for details), the [[Telephony|VoIP]] + [[E-Mail,_newsgroups,_and_forums#Chat.2C_Texting_and_Instant_Messaging|chat]] program [[Skype]] stored the most accessible copy of its message and call history in an [[SQLite]] database named '''main.db''' | + | From 2008<ref>O'Connor, T.J. ''Violent Python: A Cookbook For Hackers, Forensic Analysts, Penetration Testers And Security Engineers''. Elsevier, 2013. p. 110. [https://archive.org/details/ViolentPythonACookbookForHackersForensicAnalystsPenetrationTestersAndSecurityEngineers/page/n109?q=main.db IA link]</ref><ref>https://web.archive.org/web/20080716022445/http://www.skype.com/intl/en/download/skype/windows/beta/ Note the date.</ref> to 2017<ref name="MS_QA">https://answers.microsoft.com/en-us/skype/forum/all/where-is-the-maindb-file-for-new-skype/b4d3f263-a97e-496e-aa28-e1dbb63e7687</ref>, when a split occured and some versions replaced it with [[Skype skype.db|skype.db]] (see that page for details), the [[Telephony|VoIP]] + [[E-Mail,_newsgroups,_and_forums#Chat.2C_Texting_and_Instant_Messaging|chat]] program [[Skype]] stored the most accessible copy of its message and call history in an [[SQLite]] database named '''main.db'''. Much of the information stored in main.db, and some that wasn't (namely "deleted" messages), was also stored in [[Pre-2017 Skype chatsync|a directory structure called "chatsync"]]. |
== Software == | == Software == |
Revision as of 04:20, 18 June 2019
From 2008[1][2] to 2017[3], when a split occured and some versions replaced it with skype.db (see that page for details), the VoIP + chat program Skype stored the most accessible copy of its message and call history in an SQLite database named main.db. Much of the information stored in main.db, and some that wasn't (namely "deleted" messages), was also stored in a directory structure called "chatsync".
Software
- [1]: Skyperious, an open-source viewer written in Python
- pip2 name: skyperious
- [2]: NirSoft SkypeLogViewer, a proprietary freeware viewer
- [3] Another proprietary freeware viewer
- [4] Ditto.
Links
- StackOverflow: skype: how to read chat message using main.db
- StackOverflow: skype main.db - difference between Chats and Conversations
- Betrayed Spouses Club: Skype Main.db
- AskUbuntu: How should I see the skype chat history from the file main.db located at ~/.Skype/SKYPEUSERNAME/?
- Yahoo Answers: Why don't I have a main.db file on my Mac for Skype?
References
- ↑ O'Connor, T.J. Violent Python: A Cookbook For Hackers, Forensic Analysts, Penetration Testers And Security Engineers. Elsevier, 2013. p. 110. IA link
- ↑ https://web.archive.org/web/20080716022445/http://www.skype.com/intl/en/download/skype/windows/beta/ Note the date.
- ↑ https://answers.microsoft.com/en-us/skype/forum/all/where-is-the-maindb-file-for-new-skype/b4d3f263-a97e-496e-aa28-e1dbb63e7687