Skip to content

Instantly share code, notes, and snippets.

@errzey
Created September 11, 2013 16:43
Show Gist options
  • Save errzey/6526383 to your computer and use it in GitHub Desktop.
Save errzey/6526383 to your computer and use it in GitHub Desktop.
Never miss a deleted message in Skype
In OSX: cd ~/Library/Application\ Support/Skype/<yourusername>
sqlite3 main.db
CREATE TABLE ILOGURDELETEDMESSAGES (AUTHOR TEXT, MESSAGE TEXT);
CREATE TRIGGER LOLILOGB4UREMOVE AFTER UPDATE On Messages
FOR EACH ROW
WHEN (NEW.body_xml ="")
BEGIN
INSERT INTO ILOGURDELETEDMESSAGES (AUTHOR, MESSAGE) VALUES (NEW.author, OLD.body_xml);
END;
Profit.
@gitSergeyK
Copy link

Now Skype drops all triggers on each start. Any other smart ideas? :)

@errzey
Copy link
Author

errzey commented Jul 29, 2016

Haha I can't believe I never saw these comments.

@errzey
Copy link
Author

errzey commented Jan 18, 2017

I would have to look at skype again to find further workarounds.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment