Older blog entries for xcyber (starting at number 32)


I have been deploying mySQL servers to several clients' websites for several years.The recent dispute between mySQL AB and Nusphere is really fustrating.

mySQL AB said the Gemini stuffs ,produced by Nusphere is not released under GPL.While in doubt,i have emailed to Britton Johnston,CTO of Nusphere,hoping that i can get some clues. Below is his reply:

> From: "kwan kwan"<xcyber@yahooo.com>
> Will i get sources code of your modified mysql ,when
> i purchase your mysql adv? 
Kwan,  NuSphere distributes source code for MySQL with its
products and licenses them under the GPL.  In the specific case
of Enhanced MySQL, we provide the sources for the Gemini table
handler under the GPL license, we provide the gemini component
which is a separate library not derived from MySQL under our
commercial license. Britt... --
D. Britton Johnston       603-578-6707 Nashua
Chief Technology Officer  781-280-4954 Bedford
NuSphere Corporation      781-280-4600 Main
14 Oak Park               781-280-4646 Fax
Bedford, MA 01730         www.nusphere.com
I am now doing data entry.
I am a moron.

Just wrote a Linux-Help Yourself Guide

jmallett :: Concerning the requirements of an sysadmin,the situation is the same in Hongkong. Flipping the Recruit,you can find that almost all computer-related jobs,namely:
    Junior Programmer
    Network Operator

    Newtork Admin

    Unix/Linux Admin

They all require a CS degree. I think there are 2 reasons:

    Excessive production of CS students
    There are many CS students produced each yrs from 7 universities.A CS degree seems to be the minimum requirement to get a computer-related job.As the supply is greater than demand,why don't those employers employ more CS guys? As they are at least professionally trained and quite cheap in term of salary.Fresh CS graduates here are pulling USD 1200-USD 2000 /mo only
    Misunderstanding of job requirement from the HR dept of that company
    Those HR dept people studied HR only.How the hell can they spot the differences between network admin and programming? How can they know a CS student never study admin of an OS in university? What they know is simple:If i need a computer guru,grab me a CS student,isn't it the Title "Computer Science: clear enough for them?

To recap,even a CS graduate is facing difficulty to find a job this yr,so what do you think?

Based on your impressive experience,i think you should grab a M.Sc in CS,so that you may face less difficulty.

11 Jul 2001 (updated 11 Jul 2001 at 06:31 UTC) »


I am now developing a website for linux.org.hk tech team for them to communicate and hack together.As if you may read my diary entries,you may know i seldom hack softwares to contribute to the community.

What i do most is to give introduction of those COOL software like PHP to newbies,in form of printed articles and online articles.

I also maintain a couple of mirrors like GNU,LDP,CLDP,Webmin and LinuxFocus in my collocation server for speedy access of newbies in my country.

I think my cert level reflects (or a bit above) my contribution to the community.

deven,i think you can also help the free software community in similar ways if you don't know how to hack software.We are not at badvogato,so instead of shouting for certs,you should do some real solid things.


Writing an article for LinuxHall about XML-RPC implementation in PHP.It is available in Traditional Chinese format only .
Writing an article for Linuxpilot about ASP vs. PHP.It is an invaluable chance for me to do some PHP Advocacy
All of my published articles will be available on my website,so don't buy those books =p.


I am really interested to pursue my career in legal sector.But now i am studying biology and CS in university.i think i will finish my degree study and take the Common Professional Exam or LLB course.

What if no school admit me?

Well..I don't know.......


I am now helping the company to process a pile of papers,how?

Those papers contain the email addresses of customers,my job is data entry..

I am updating my C.V.,adding the title "Data Entry Specialist" to it.

10 Jul 2001 (updated 10 Jul 2001 at 05:49 UTC) »


Now having a japanese style lunchbox.It contains roasted chicken,roasted eel and egg with rice.

Do you love asian food?

9 Jul 2001 (updated 11 Jul 2001 at 06:35 UTC) »

<?xml version="1.0" encoding="ISO-8859-1" ?>

<Xcyber_Diary xmlns:Xcyber_Diary="http://xcyber.org/Xcyber_Diary.dtd">


Going to year2 at CUHK,declared as a CS minor student.

Can i attend M.Sc. course of CS after graduated as a biology student?

This bothers me!



My original task is to dump 1.3 Millions row of data from 200 tables containg over 150 fields from various databases living in Oracle and MSSQL using ACCESS.

Do you guys think it is possible to do so?

2 weeks before,

i have suggested to my manager that it is impratical and stupid to do so.He refused to comment on it.

3 days later,he quitted the company.

i am told that the task was out-sourced to outside company.

I have not received any prior notification.I acted like an idiot in my company.

Although i am just a summer job worker,i think it is a matter of courtesy and they should treat me like a member of their freaking team.



Get assigned as a web developer to make the website of linux.org.hk.

My task is to make a collaboration site,e.g. SF for linux.org.hk tech team .

The deadline is 2 weeks later,is it possible?

Opinions are welcome!DO you think that SF is good and useful?



7 Jul 2001 (updated 9 Jul 2001 at 18:22 UTC) »

Are there anyone studying biology,biochem,bioinfo or related stuff here?

<?xml version="1.0" encoding="ISO-8859-1" ?>

<Xcyber_Diary xmlns:Xcyber_Diary="http://xcyber.org/Xcyber_Diary.dtd">


Finished my article of transforming XML to HTML using PHP- Sablotron in chinese.I will post it up to linuxfab.cx later.


<Solved Problems>
Wrote a php snippnet,which trim out all the white space in a CSV file.But why a CSV file have unnecessary whitespace between eash csv-ed data?

Hint:The file is exported from a windows SQL database 
dump program.

After "normalizing" those csv files,i have managed to insert them to MySQL without errors.

Be careful,always load the data files to your filesystem,DO NOT use phpMyadmin to do it,or you will get a serious performance hit.

Why do i need to waste 3 minutes to wait for the text files being transferred to php-apache-mysql,when i can do i simple local mysql insert in 0.3sec?

</Solved Problems>


Two tables in database,contain similar records,need to compare them and print out the differences.

Will try php in_array,but we are talking about 50000 records, 50000*50000=2500000000 comparisons

1.)loading those 100,000 data to 2 arrays take time

2.)the comparsion EAT time!

Now thinking of a better way,any suggestions?

Trying hard to make php work with xslt using the sablotron extension.

You will need :

  1. gcc
  2. g++
  3. flex
  4. libstdc++2.9-glibc2.1
  5. google.com
  6. expat
  7. sablotron
  8. php
  9. apache,probably apxs


  1. compile and install expat
    #wget http://download.sourceforge.net/expat/expat-
    #tar zxvf Sablot-0.60.tar.gz
    #cd Sablot-0.60
    #make install
  2. compile and install sablotron
    #wget http://www.gingerall.com/perl/rd?url=sablot/Sablot-
    #tar zxvf Sablot-0.60.tar.gz
    #make install

  3. configure apache
    #tar zxvf apache_1.3.19.tar.gz
    #cd apache_1.3.19
    #./configure --prefix=/usr/local/apache
  4. configure php
    #tar zxvf php-4.0.5.tar.gz
    #cd php-4.0.5
    #./configure --with-xml \
    --with-apache=../apache_1.3.19 \
    --enable-track-vars \
    --with-sablot \

  5. compile and install php
    #cd apache_1.3.19
    #make install
  6. compile and install apache
    #make install
http://www.onlamp.com/topics/php/building_compiling http://www.devshed.com/Server_Side/PHP/SoothinglySeamless/pr int.html
For debian distro:
apt-get install php4-sablotron apache apache-common 

That's why i love debian!







23 older entries...

New Advogato Features

New HTML Parser: The long-awaited libxml2 based HTML parser code is live. It needs further work but already handles most markup better than the original parser.

Keep up with the latest Advogato features by reading the Advogato status blog.

If you're a C programmer with some spare time, take a look at the mod_virgule project page and help us with one of the tasks on the ToDo list!