A few days ago, I found out that you can send video messages to people via Skype. Someone asked me if I knew of a way to export them from Skype. (That way you can watch them while offline, back them up for later, or whatever else you might want to do.)
After searching around the web for a while, I realized that there is no such feature at the moment. I also saw many people suggesting an SQLite browser add-on for firefox.
It turns out that Skype uses a sqlite database to save messages and other information. On OSX, the main database file is located under
Inside the file is a table called VideoMessage, which contains the URL for all received video messages. What people were doing was finding the URL using the sqlite browser, then downloading each file individually. Another problem was that those links expire after some time, so if you haven’t viewed the video in Skype in the recent past, they won’t work. Since this method is a bit complicated for most users, I decided to automate it.
My first version consisted of a bash script that used find to get the database file, then called sqlite3 to get the urls, and generated an html file with links to the videos. It worked, but it still wasn’t as easy as it could be.
The next/last step consisted of writing an Objective-C app to do it all.
The application automatically finds the database file (or files, if there are multiple Skype accounts). After that, it opens each one and gets the video message info to display. The users can then select the messages they want and download them all at once to the desktop.