Peter Brawley and Arthur Fuller have a nice collection of SQL scripts at their site http://www.artfulsoftware.com
http://www.artfulsoftware.com/infotree/queries.php?&bw=1072
02
May
13
Collection of SQL Scripts
02
May
13
Group SQL query by N minutes
Found this neat SQL script by Nicolas Poggi that allow to group time by N period like 5,10 or 30 minutes.
http://web.performancerasta.com/group-by-a-sql-query-by-n-minutes/
((60/N) * HOUR(date_time_field ) + FLOOR( MINUTE(date_time_field) / N ))
MS Log Parser allows for parsing and analysis based on SQL. Very useful and surprising fast.
Summarize response code
SELECT STRCAT(TO_STRING(sc-status), STRCAT('.', TO_STRING(sc-substatus))) AS Status,
COUNT(*) AS Total
INTO C:\output.csv FROM C:\a.log
GROUP BY Status
ORDER BY Total DESC
Summarize response code by hour
SELECT TO_STRING(time, 'HH') AS Hour, STRCAT(TO_STRING(sc-status), STRCAT('.', TO_STRING(sc-substatus))) AS Status, COUNT(*) AS Total
INTO 'C:\output.csv' FROM C:\a.log
GROUP BY Hour, Status
ORDER BY Hour, Status ASC
Summarize response code by every 5 minutes
SELECT QUANTIZE(time,300) AS Hour, STRCAT(TO_STRING(sc-status), STRCAT('.', TO_STRING(sc-substatus))) AS Status, COUNT(*) AS Total
INTO 'C:\output.csv' FROM 'D:\input.log'
GROUP BY Hour, Status
ORDER BY Hour, Status ASC
25
Apr
13
Python with Gtalk
Sending GTalk using Python. From desktop and even SL4A.
PC Installation
-
easy_install xmpppy
23
Apr
13
Tasker – Automation for Android
Not exactly Python, but certainly automation for Android devices.
FAQ
Articles
Tutorial for developing for Android with Eclipse and ADK.
22
Apr
13
Custom Phone Notification
Possible custom notifications for my phone. Objective is to only receive notification from certain emails or SMS only. The rest should be silent.
- http://www.notifymyandroid.com – Notification for Android
- http://pushover.net – Notification for Android & IOS
- https://ifttt.com – Logic for email/SMS triage
Python Aided Work 
Recent Comments