Skype uses SQLite

Skype uses SQLite too! Even if you don’t believe it, but it’s one of the most handy things for getting data structured; But as every database, even sqlite needs some love every now and then. On a linux box, the databases of Skype are in ~/.Skype// and their extension is .db; Contacts, Logs and all that jazz in […]

Visiting blogs by SQL Query

Honestly, it is interesting to get to know the people, leaving comments on blogs. It is a good way to get to know new people. But how to get all that links together without digging through every comment? Right! Ask the database: SELECT DISTINCT comment_author, comment_author_url FROM wp_comments WHERE comment_author_url IS NOT NULL ORDER BY comment_author; This query’s […]