Jsummers: Category:SQLite based file formats

2020-01-25T14:24:47Z

Category:SQLite based file formats

Effect2: Added another link

2019-06-18T04:21:07Z

Added another link

Effect2: Created page with "{{FormatInfo |formattype=electronic |subcat=Telephony |extension={{ext|db}} |released=2017https://answers.microsoft.com/en-us/skype/forum/skype_win10-skype..."

2019-06-18T04:15:17Z

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

New page

{{FormatInfo
|formattype=electronic
|subcat=Telephony
|extension={{ext|db}}
|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>
}}
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.

== Applicable Software ==
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" />.

== Links ==
* [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???]
* [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?]
* [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?]

== References ==
<references />

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

← Older revision		Revision as of 14:24, 25 January 2020
Line 20:		Line 20:

	[[Category:File formats with a distinctive filename]]		[[Category:File formats with a distinctive filename]]
		+	[[Category:SQLite based file formats]]
	[[Category:Microsoft]]		[[Category:Microsoft]]

@@ Line 14: / Line 14: @@
 * [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?]
 * [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?]
 == References ==

Skype skype.db - Revision history

Jsummers: Category:SQLite based file formats

Effect2: Added another link

Effect2: Created page with "{{FormatInfo |formattype=electronic |subcat=Telephony |extension={{ext|db}} |released=2017https://answers.microsoft.com/en-us/skype/forum/skype_win10-skype..."