Tuesday, January 05, 2016

Obama on gun control

"We know we can't stop every act of violence, every act of evil in the world. But maybe we could try to stop one act of evil, one act of violence"

"We do have to feel a sense of urgency about it. In Dr King's words, we need to feel the fierce urgency of now, because people are dying," he said. "And the constant excuses for inaction no longer do."

"Yes, it will be hard. And it won't happen overnight. It won't happen during this Congress. It won't happen during my presidency," he said. "But a lot of things don't happen overnight. A woman's right to vote didn't happen overnight. The liberation of African-Americans didn't happen overnight. LGBT rights, that was decades worth of work."

- Barack Obama

Wednesday, December 30, 2015

starting nodejs

a) express --sessions projectName
Create directory projectName with views, routes
b) cd projectName
c) npm install handlebars
d) npm install consolidate
Google for npm consolidate,
With reference to the example for express 3, modify app.js
e)

Mr Lee's final gift: One united people

"For those who say that Singaporeans are spoiled, selfish, always complaining and mercenary, what would they make of what's happening now: tens of thousands, soon-to-be hundreds, and possibly a million before the week is out, queueing for hours in the hot sun without a peep of disgruntlement. No one told them to do it. There are no freebies at the end of this queue. There are no goodie bags to be had, no fancy aerial displays, no ballot sheets to tick, no certificates of participation awaiting.

Yet there is nothing but stoic contemplation, a people united by sadness but at the same time, an amazing, totally unscripted display of goodwill and community. People are chipping in to help with free water, flowers, food and general kindness for one's fellow man. Without any expectations of reward or publicity - just plain human decency. "
-By Jaime Ee, The Business Times, 27 Mar 2015

Yesterday and today

With passing time, what seems important is so insignificant now.

Thursday, January 15, 2015

select it!

select * from (

select 'lkj' name, 1 isSup, 0 isHse, 1 isMgr
union
select 'lky' name, 0 isSup, 0 isHse, 1 isMgr
union
select 'Jon' name, 0 isSup, 1 isHse, 0 isMgr
union
select 'Kim' name, 1 isSup, 0 isHse, 0 isMgr

) myTable
where isSup in (1) and isHse in (0,1) and isMgr in (0,1)

Tuesday, December 30, 2014

mysql group_concat

SET SESSION group_concat_max_len = 1000000;
SELECT
cast(
concat(
PCR_M.PCR_Year,
'-',
LPAD(PCR_M.PCR_Id,4,'0')
) as CHAR
) as PCR_Id,
PCR_M.PCR_Name,
PCR_M.PCR_SEV_Id as Severity,
(
select
group_concat(I.ITM_Name separator ", ")
from
LINK_PCR_ITEM ITM
join ITEM I
where
I.ITM_Id=ITM.ITM_Id and ITM.PCR_Year=PCR_M.PCR_Year and ITM.PCR_Id=PCR_M.PCR_Id group by 'ITM_Id'
) as CSCI,


(
select group_concat(
"[Start][",
(select USR_Name from USERS where PAN.PAN_Author=USR_Id),
"] [",
date_format(PAN.PAN_Modification_Date, "%Y%m%d %H:%i"),
"]\r\n",
PAN.PAN_Comment,
"\r\n[End][",
(select USR_Name from USERS where PAN.PAN_Author=USR_Id),
"] [",
date_format(PAN.PAN_Modification_Date, "%Y%m%d %H:%i"),
"]"
separator "\r\n\r\n"
)
from PCR_ANALYSIS PAN
where (PCR_M.PCR_Id=PAN.PCR_Id and PCR_M.PCR_Year=PAN.PCR_Year)
) as Analysis,

(
select group_concat(
"[Start][",
(select USR_Name from USERS where PCT.PCT_Author=USR_Id),
"] [",
date_format(PCT.PCT_Modification_Date, "%Y%m%d %H:%i"),
"]\r\n",
PCT.PCT_Comment,
"\r\n[End][",
(select USR_Name from USERS where PCT.PCT_Author=USR_Id),
"] [",
date_format(PCT.PCT_Modification_Date, "%Y%m%d %H:%i"),
"]"
separator "\r\n\r\n"
)
from PCR_CORRECTIVE PCT
where (PCR_M.PCR_Id=PCT.PCR_Id and PCR_M.PCR_Year=PCT.PCR_Year)
) as Corrective

from PCR_MAIN PCR_M;

Wednesday, June 04, 2014

Truncated Text SSRS display in IE 10

Reference URL: http://answers.microsoft.com/en-us/ie/forum/ie10-windows_7/ie-10-ssrs-report-viewer-issue-after-kb2888505/1e82a8b9-dea6-4351-90d3-7f4f47c4fb2a

<script> block:

    try {

        Sys.WebForms.PageRequestManager.getInstance().add_endRequest(function() {

            document.getElementById("ReportViewerControl_fixedTable").style.tableLayout = '';

        });

    } catch(e) {

        //ignore me alert("error");

    }

Monday, March 31, 2014

Timeline plotting



Graphite
http://graphite.wikidot.com/


OpenTSDB
http://opentsdb.net/index.html

npm bucky-server


FLOT?

references
http://jedi.be/blog/2012/01/04/monitoring-wonderland-visualization/
http://matt.aimonetti.net/posts/2013/06/26/practical-guide-to-graphite-monitoring/

http://www.designyourway.net/drb/javascript-visualization-libraries-to-display-charts-and-graphs-34-items/

Sunday, March 16, 2014

Binary decoding with AWK

http://awk.info/?doc/bitmaps.html


function Bytes2Number( String, x, y, z, Number ) {
x = split( String, Scratch, "" )
Number = 0
for( y = 1; y <= x; y++ ) {
z = index( CharString, Scratch[ y ] ) -1
Number = Number + z * (256^(x - y))
}
return Number
}

BEGIN{
for( x = 0; x <= 255; x++ ) {
CharString = CharString sprintf( "%c", x )
FS= ""
RS = /ABC/
}

{ Width = Bytes2Number( $22 $21 $20 $19 )
Height = Bytes2Number( $26 $25 $24 $23 )
Data = Bytes2Number( $14 $13 $12 $11 )
Size = Bytes2Number( $6 $5 $4 $3 )
Depth = Bytes2Number( $30 $29 ) / 8
ImgSize = Bytes2Number( $38 $37 $36 $35 )
....
}