Skype main.db - Revision history

Jsummers: Category:SQLite based file formats

2020-01-25T14:24:09Z

Category:SQLite based file formats

Effect2: Removed now-redundant basic information on skype.db

2019-06-18T04:20:18Z

Removed now-redundant basic information on skype.db

Effect2: 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

2019-06-18T04:18:45Z

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

Effect2: Test edit to see if changes are possible with problems

2019-04-15T02:01:12Z

Test edit to see if changes are possible with problems

Effect2: Created page with "{{FormatInfo |formattype=electronic |subcat=Telephony |extension={{ext|db}} |released=2008 }} From 2008O'Connor, T.J. ''Violent Python: A Cookbook For Hackers, Forensic ..."

2019-04-13T19:34:05Z

Created page with "{{FormatInfo |formattype=electronic |subcat=Telephony |extension={{ext|db}} |released=2008 }} From 2008<ref>O'Connor, T.J. ''Violent Python: A Cookbook For Hackers, Forensic ..."

New page

{{FormatInfo
|formattype=electronic
|subcat=Telephony
|extension={{ext|db}}
|released=2008
}}

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

== Software ==
* [https://suurjaak.github.io/Skyperious/]: Skyperious, an open-source viewer written in [[Python]]
** pip2 name: skyperious
* [https://nirsoft.net/utils/skype_log_view.html]: NirSoft SkypeLogViewer, a proprietary freeware viewer
* [https://turgs.com/skype/viewer/] Another proprietary freeware viewer
* [https://www.bitrecover.com/free/skype-chat-viewer/] Ditto.

== Links ==
* [https://stackoverflow.com/questions/44502283/skype-how-to-read-chat-message-using-main-db StackOverflow: skype: how to read chat message using main.db]
* [https://stackoverflow.com/questions/16886728/skype-main-db-difference-between-chats-and-conversations StackOverflow: skype main.db - difference between Chats and Conversations]
* [http://betrayedspousesclub.blogspot.com/2012/07/skype-maindb.html Betrayed Spouses Club: Skype Main.db]
* [https://askubuntu.com/questions/527583/how-should-i-see-the-skype-chat-history-from-the-file-main-db-located-at-skyp AskUbuntu: How should I see the skype chat history from the file main.db located at ~/.Skype/SKYPEUSERNAME/?]
* [https://answers.yahoo.com/question/index?qid=20130907011149AAgfHYn Yahoo Answers: Why don't I have a main.db file on my Mac for Skype?]


== References ==
<references />

[[Category:File formats with a distinctive filename]]

← Older revision		Revision as of 14:24, 25 January 2020
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]]

@@ Line 7: / Line 7: @@
 <!--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 ==

@@ Line 7: / Line 7: @@
 <!--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 ==
@@ 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?]
 == References ==
 <references />
 [[Category:File formats with a distinctive filename]]

@@ Line 5: / Line 5: @@
 |released=2008
 }}
 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"]].