Older blog entries for xcyber (starting at number 31)

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.

Contribution

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.

Article

#1

Writing an article for LinuxHall about XML-RPC implementation in PHP.It is available in Traditional Chinese format only .

#2

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.

Career

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.......

Job

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.

Lunch

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

Do you love asian food?

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

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

<study>

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!

</study>

<work>

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.

Today,

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.

</work>

<hacking>

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?

</hacking>

</Xcyber_Diary>

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">

<Article>

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

</Article>

<Job>

<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>

<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?

</Problems>

</Job>

</Xcyber_Diary>

PHP-XSLT

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

Steps:

1. compile and install expat

   #wget http://download.sourceforge.net/expat/expat-
   1.95.1.tar.gz
   #tar zxvf Sablot-0.60.tar.gz
   #cd Sablot-0.60
   #./configure
   #make
   #make install
   

2. compile and install sablotron

   #wget http://www.gingerall.com/perl/rd?url=sablot/Sablot-
   0.60.tar.gz
   #tar zxvf Sablot-0.60.tar.gz
   #./configure
   #make
   #make install
   

3. configure apache

   #wget 
   http://httpd.apache.org/dist/httpd/apache_1.3.19.tar.gz
   #tar zxvf apache_1.3.19.tar.gz
   #cd apache_1.3.19
   #./configure --prefix=/usr/local/apache
   

4. configure php
   

   #wget 
   http://www.php.net/do_download.php?download_file=php-
   4.0.5.tar.gz&source_site=php.xcyber.org
   #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 \
   --with-mysql 
   

   
   
5. compile and install php

   #cd apache_1.3.19
   #make
   #make install
   

6. compile and install apache

   #make
   #make install
   

Reference:

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!

hackingmicrosoftaccessandvba.

mygoalistoretreiveabout700000rowofdatafrommssqlusingaccess.

ihavesuggestedtousephporanythingelsewhichsupporodbctoreplaceaccess,butgotrefused.

thereasonissimple,"asadesktopuser,irefuseeverythingexceptaccess."

iamnowlearninghowtousevbatowriteaprogram,whichupdatethetables'namesmonthly,how?noclues.

shameonyou,microsoft.

duncanm

Thank you for the suggestions.After 3 days of struggling,my article is done.
I refused to translate global variable,function,element,tag,data to chinese,but i took all of your suggestions.
Thank you very much.

article

Just done the article "Transforming XML to HTML using PHP" for LinuxHall in Chinese.

article #2

Will do another article about apachetoolbox for LinuxHall in Chinese.
Still have 3 days to go.

article #3

Will do yet another Step-by-Step introductory installation walk-thru with load of screenshots about either Mandrake or cle for PCHome in Chinese.
Still have 3 days to go.(again)

Will there be a cert for journalist ?