Skype main.db

From Just Solve the File Format Problem
(Difference between revisions)
Jump to: navigation, search
(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)
(Category:SQLite based file formats)
 
(One intermediate revision by one user not shown)
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'''. 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'''. 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 27: Line 27:
  
 
[[Category:File formats with a distinctive filename]]
 
[[Category:File formats with a distinctive filename]]
 +
[[Category:SQLite based file formats]]
 
[[Category:Microsoft]]
 
[[Category:Microsoft]]

Latest revision as of 14:24, 25 January 2020

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. 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".

[edit] 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.

[edit] Links

[edit] 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. https://answers.microsoft.com/en-us/skype/forum/all/where-is-the-maindb-file-for-new-skype/b4d3f263-a97e-496e-aa28-e1dbb63e7687
Personal tools
Namespaces

Variants
Actions
Navigation
Toolbox