Author: Jiju Thomas Mathew

Recently for Saturn SPL, as part of a prototype discussion, I was considering a fam based trigger for a process queue. We were already familiar with queueing processes in a mysql table, with auto_increment primary key, this should not be a problem. But when the number of processes increase, the table size too increases and finally we will be forced to remove those already processed. Also more than this, we wanted the table to me as compact as possible, meanwhile should be as accurate as possible. MySQL could not (AFAIK) stamp rows with mico seconds.
Continue reading “MySQL UDF – the first taste”

While searching for some thing, I found a string encryption code sample for Visual Basic, and I just wanted the same in php, and did a port. Just like what F. Balena has done over there, this function is also used for both, encrypt as well as decrypt.


<?php
function stringEncrypt($str, $pass){
    $strlen = strlen($str);
    $passIndex = 0;
    $passLen = strlen($pass);
    // null passwords wont encode
    if(strlen($pass) == 0) 
        return $str;
    for ($i = 0; $i < $strlen; $i++){
        // get the next char in the password
        $passChr = ord($pass[($i % $passLen)]);
        // encrypt one character in the string
        $str[$i] = chr(ord($str[$i]) ^ $passChr);
        // modify the character in the password (avoid overflow)
        $pass[($i % $passLen)] = chr(($passChr + 17) & 255);
    }
 return $str;    
}