http://fileformats.archiveteam.org/index.php?title=Skype_skype.db&feed=atom&action=historySkype skype.db - Revision history2024-03-29T11:56:58ZRevision history for this page on the wikiMediaWiki 1.19.2http://fileformats.archiveteam.org/index.php?title=Skype_skype.db&diff=34508&oldid=prevJsummers: Category:SQLite based file formats2020-01-25T14:24:47Z<p>Category:SQLite based file formats</p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 14:24, 25 January 2020</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 20:</td>
<td colspan="2" class="diff-lineno">Line 20:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Category:File formats with a distinctive filename]]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Category:File formats with a distinctive filename]]</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">[[Category:SQLite based file formats]]</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Category:Microsoft]]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Category:Microsoft]]</div></td></tr>
</table>Jsummershttp://fileformats.archiveteam.org/index.php?title=Skype_skype.db&diff=32336&oldid=prevEffect2: Added another link2019-06-18T04:21:07Z<p>Added another link</p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 04:21, 18 June 2019</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 14:</td>
<td colspan="2" class="diff-lineno">Line 14:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [https://answers.microsoft.com/en-us/skype/forum/skype_win10-skype_messms-skype_instamessms/how-do-i-export-my-chat-history/20849b44-d68a-40f4-8cb8-6a2dc88e9e7e how do I export my chat history?]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [https://answers.microsoft.com/en-us/skype/forum/skype_win10-skype_messms-skype_instamessms/how-do-i-export-my-chat-history/20849b44-d68a-40f4-8cb8-6a2dc88e9e7e how do I export my chat history?]</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [https://superuser.com/questions/1339046/skype-version-8-moved-the-main-db-file-is-there-a-way-to-read-this-database-now Skype version 8 moved the main.db file. Is there a way to read this database now?]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [https://superuser.com/questions/1339046/skype-version-8-moved-the-main-db-file-is-there-a-way-to-read-this-database-now Skype version 8 moved the main.db file. Is there a way to read this database now?]</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">* [https://answers.microsoft.com/en-us/skype/forum/skype_windesk-skype_messms-skype_sms/sqlite-maindb-file/75258f84-4b2d-4284-82b0-958bed9f3b36 SQLite main.db file] contains information on layout of skype.db as well</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== References ==</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== References ==</div></td></tr>
</table>Effect2http://fileformats.archiveteam.org/index.php?title=Skype_skype.db&diff=32332&oldid=prevEffect2: Created page with "{{FormatInfo |formattype=electronic |subcat=Telephony |extension={{ext|db}} |released=2017<ref name="whereis">https://answers.microsoft.com/en-us/skype/forum/skype_win10-skype..."2019-06-18T04:15:17Z<p>Created page with "{{FormatInfo |formattype=electronic |subcat=Telephony |extension={{ext|db}} |released=2017<ref name="whereis">https://answers.microsoft.com/en-us/skype/forum/skype_win10-skype..."</p>
<p><b>New page</b></p><div>{{FormatInfo<br />
|formattype=electronic<br />
|subcat=Telephony<br />
|extension={{ext|db}}<br />
|released=2017<ref name="whereis">https://answers.microsoft.com/en-us/skype/forum/skype_win10-skype_messms-skype_instamessms/where-is-the-maindb-file-for-new-skype/b4d3f263-a97e-496e-aa28-e1dbb63e7687</ref><br />
}}<br />
Starting from some time in late 2017, the [[Telephony|VoIP]] + [[E-Mail,_newsgroups,_and_forums#Chat.2C_Texting_and_Instant_Messaging|chat]] program [[Skype]]'s "Skype for Windows 10" client (see [[#Applicable Software]]) stored its message history in a [[SQLite]] database named '''skype.db'''. This database is purportedly very similar to its predecessor, [[Skype main.db|main.db]], which is still created in the filesystem after the update, but does not hold any substantial data. There does not seem to be any publicly-available software (except for Skype itself) able to read skype.db; thus, the best way to get its contents is to presumably examine it in a generic SQLite viewer, although if the layout of main.db is any indication, this should be easy to do.<br />
<br />
== Applicable Software ==<br />
It seems that some time in late 2017, client-side development of Skype was internally split into two separate programs: "Skype on Desktop, Mac and Linux" (also known by various permutations of this name), a continuation of the old client, and "Skype for Windows 10" (or "Skype UWP"), apparently a new client<ref>https://answers.microsoft.com/en-us/skype/forum/skype_win10-skype_messms-skype_instamessms/skype-versions-12-v-8/419d97cd-06df-4d16-ae7e-1ff3986b6640</ref>; these are confusingly referred to as versions 8.* and 12.* of the same version space, as if they were different versions the same software. Little information is available about the split, but it appears that "Skype for Windows 10" was created as part of an effort within the company to switch to a UI toolkit called [[Wikipedia:Universal Windows Platform|"Universal Windows Platform"]].<ref>https://www.theregister.co.uk/2016/03/24/microsoft_introduces_yet_another_skype_for_windows_10/; https://answers.microsoft.com/en-us/skype/forum/skype_win10-skype_messms-skype_instamessms/where-is-the-maindb-file-for-new-skype/b4d3f263-a97e-496e-aa28-e1dbb63e7687 confirms that "Skype UWP" is "Skype for Windows 10" is Skype 12.*</ref>. It seems likely that skype.db is only used by the new version and not the old one.<ref>https://answers.microsoft.com/en-us/skype/forum/skype_win10-skype_messms-skype_instamessms/how-do-i-export-my-chat-history/20849b44-d68a-40f4-8cb8-6a2dc88e9e7e → second reply by "Ruwim.B"</ref><ref name="whereis" />.<br />
<br />
== Links ==<br />
* [https://answers.microsoft.com/en-us/skype/forum/skype_win10-skype_messms-skype_instamessms/where-is-the-maindb-file-for-new-skype/b4d3f263-a97e-496e-aa28-e1dbb63e7687 Where is the main.db file for the new Skype???]<br />
* [https://answers.microsoft.com/en-us/skype/forum/skype_win10-skype_messms-skype_instamessms/how-do-i-export-my-chat-history/20849b44-d68a-40f4-8cb8-6a2dc88e9e7e how do I export my chat history?]<br />
* [https://superuser.com/questions/1339046/skype-version-8-moved-the-main-db-file-is-there-a-way-to-read-this-database-now Skype version 8 moved the main.db file. Is there a way to read this database now?]<br />
<br />
== References ==<br />
<references /><br />
<br />
[[Category:File formats with a distinctive filename]]<br />
[[Category:Microsoft]]</div>Effect2