Skype main.db

From Just Solve the File Format Problem
(Difference between revisions)
Jump to: navigation, search
m (Test edit to see if changes are possible with problems)
(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)
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>, 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'''. After version 12 was released in 2017, message history was instead kept in a slightly different database called [[skype.db]], although main.db remains in the filesystem.<ref name="MS_QA" /><ref>https://answers.microsoft.com/en-us/skype/forum/skype_windesk-skype_messms-skype_sms/sqlite-maindb-file/75258f84-4b2d-4284-82b0-958bed9f3b36</ref>. 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"]].
+
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'''. After version 12 was released in 2017, message history was instead kept in a slightly different database called [[skype.db]], although main.db remains in the filesystem.<ref name="MS_QA" /><ref>https://answers.microsoft.com/en-us/skype/forum/skype_windesk-skype_messms-skype_sms/sqlite-maindb-file/75258f84-4b2d-4284-82b0-958bed9f3b36</ref>. 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 ==
Line 23: Line 23:
 
* [https://answers.yahoo.com/question/index?qid=20130907011149AAgfHYn Yahoo Answers: Why don't I have a main.db file on my Mac for Skype?]
 
* [https://answers.yahoo.com/question/index?qid=20130907011149AAgfHYn Yahoo Answers: Why don't I have a main.db file on my Mac for Skype?]
  
<!--
 
Add a see also for the other DB!
 
-->
 
 
== References ==
 
== References ==
 
<references />
 
<references />
  
 
[[Category:File formats with a distinctive filename]]
 
[[Category:File formats with a distinctive filename]]
 +
[[Category:Microsoft]]

Revision as of 04:18, 18 June 2019

File Format
Name Skype main.db
Ontology
Extension(s) .db
Released 2008

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. After version 12 was released in 2017, message history was instead kept in a slightly different database called skype.db, although main.db remains in the filesystem.[3][4]. 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

References

  1. O'Connor, T.J. Violent Python: A Cookbook For Hackers, Forensic Analysts, Penetration Testers And Security Engineers. Elsevier, 2013. p. 110. IA link
  2. https://web.archive.org/web/20080716022445/http://www.skype.com/intl/en/download/skype/windows/beta/ Note the date.
  3. 3.0 3.1 https://answers.microsoft.com/en-us/skype/forum/all/where-is-the-maindb-file-for-new-skype/b4d3f263-a97e-496e-aa28-e1dbb63e7687
  4. https://answers.microsoft.com/en-us/skype/forum/skype_windesk-skype_messms-skype_sms/sqlite-maindb-file/75258f84-4b2d-4284-82b0-958bed9f3b36
Personal tools
Namespaces

Variants
Actions
Navigation
Toolbox