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 […]
Tag: sql
MSSQL vs Access via JET/ODBC
If you are dealing with a greater amount of records in a Microsoft Access database, it’s recommended to use a SQL server as a backend database to handle those and get rid of unpleasant surprises. Usually those servers are connected via JET/ODBC – and that’s where the fun starts.
Who’s connected to my MSSQL server?
Today I was trying to restore a backup of our MSSQL server when a user decided to drive me crazy by not disconnecting after telling anyone that we need to do that restore. So I fired up the management studio and had a look at the current processes by using the following query: select spid, status, loginame, hostname, […]
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 […]