Power Over Ethernet (POE) Network hub for the CCTV project

I got a new project, a CCTV project! Because the company wants to save money after call in few vendor, we decided that we can save more than 60% of the budget if we do it by ourself. We are going to use IP camera that need power from the Power Over Ethernet (POE).

Since we do not want to use the usual 3-pin plug AC power socket to power up the POE, we decided to use network switch that comes with POE.

After looking for few models, I found out that HP is the best in terms of performance. However, the price is way to expensive. We need at least 30 port since we are going to use 30 IP cameras. the next brand that I was looking for are TP-Link and D-Link, China and Taiwan made.

Out of these 3 brands, TP-Link is the cheapest of all. Since they are claiming they are the number one in the world for the network switch market segment, I give it a try for TP-Link.

As for the HP network switch, I was looking at this model: HP E2520-24G-PoE switch. From the website, the features looks amazing! While model number for D-Link: DGS-3120-24PC looks good also. However, for these two models, HP cost me more than RM5000 and D-Link more than RM4000. While as of TP-Link, TL-SG3424P, the cost is only RM840, not even RM1000! 

Comes to the network topology, we need to scatter up the 30 cameras from the server room span all to the plant wide that having 140 meter X 25 meter. Because of the huge area to cover, we decided to go for daisy chain and star topology, makes the TP-Link network switch not able to cope with this. Later we decided to buy 8 port Tp-Link PoE network switch so that we can maximize the wiring which is 100 meter maximum from the network switch to each camera.

Looking at the catalog, we go for TP-Link TL-SF1008P, 8 port PoE switch. However, only 4 ports are PoE enable port and this is unmanageable network switch. Come to think about it, 4 ports will go to the cameras, 2 port we will link the network switch to another network switch, to make it daisy chain/star topology.

As of now, I am waiting for the network swicth to arrive and I will update more about the CCTV using PoE soon.

++++++++++++++++++++++++

My eyes will be anywhere after this

-- microprocessor--

++++++++++++++++++++++++

Formula One Tech Magic

Since year 1998 I started to passionate about Fomula 1 car race. It was the first year my country, Malaysia hosted Formula 1 race in Sepang. Why I love this sport? It is because the engineering behind the sport that makes the whole excitement. The engineering is not about the car engine itself, but also the data telemetry system, the safety, aerodynamics, calculations, timing, and also team work.
But the best about this sport for me is the ENGINEERING!

====================
seated at the finishing line
-- microprocessor --
====================

Fusion Chart

I was looking for a on-the-fly real time chart for one of my project. It need to get the raw data from the database, and present the raw data into a graph for the management to review and made the decisions.
I found out 5 years ago about Fusion Chart, until i forgotten about it and my superior remind about it again. Fortunately, after 5 years, there is  a FREE version of Fusion Chart. The free version offer less features from the paid version however, for me, the free version suits my need already.

Fusion chart create amazing chart together with animation to catch the attention of the reader. It will render the chart using XML data, Javascript or from JSON and render it to Flash to show the graph.
You may get the Fusion Chart from here
============
chart and graph
-- microprocessor --
============

CRUD AJAX

I found out to develop CRUD AJAX (Create-Read-Update-Delete Asynchronous JavaScript and XML(eXtensible Mark-Up Language)) was a breeze using AJAX CRUD. The GUI for the end user is like excel to do the editing. They just click on the field to activate the editing mode, edit and enter. No need to enter into another page wait for page loading, click submit and again wait for another page loading.
AJAX CRUD using PHP and MySQL as the database.

AJAX-CRUD

Because it is open source, you may get the source code from here.

My Job, My Career, My Hobby

There are people bored with their job. Not for me. I love computer since i was 4 or 5. It was in 1989. By that time, DOS was the OS that I was using, and by that time, the PC that I'm using, there was no mouse like we are having now.
To boot up the PC, we need to load the MS-DOS into the RAM.
1) Put in the diskette
2) load the MS-DOS into the RAM
3) Take out the diskette
4) Load in what ever program we want (Wordstar = Microsoft Word, Lotus 1-2-3 = Microsoft Excel, Games)
I still remember by that time, I can remember each and every command to type in order for me to boot up the system and run the programs. Sadly, i threw the PC few years ago. Should not do that.
During that year, 1989, I was using 3.5 inch diskette with capacity of 1.44 MB, and it was huge by that time! imagine to have the exe file inside and all the documents also can be inside the same diskette. Example, the Wordstar and the documents that we create can be inside the 1.44MB diskette, and there are still much more space inside it! Having this 1.44 MB diskette by that time is like having a Blue-Ray disc now!

Now, I am an engineer where I contribute my passion to the world. My career as software engineer, for me its just a hobby for me. Day in, day out creating software is great and I'm getting paid for doing my hobby! I don't want to be like few of them that are complaining about their job. In the first place, why did you apply the job? Why did you go to the university to get the degree cert, why you apply for the course during your university registration day? After graduate, you look for a job, applied for a job, and after 24 months, why never stop complaining about your job?
I must say, I love my job, I'm building my career and i am getting paid to do my hobby! Changing job for more money? Not everything money can buy :)
---------------------------------
microprocessor
-------------------------------

cout<<"Hello World!";

As for the new year (2013) resolution, I going to start a web blog where I will share my project or work experience. Why am I doing this? Simply because many of my projects, whenever I'm stuck, I will Google for it and within minutes, my problem solved. Because of this, I never afraid to say that there is no technical problem that cannot be solved. The whole world sharing the knowledge, the experience.  This what motivates me to create this blog, so that I can share my own personal experience, technical problem and share it to the whole world.

I am a technical guy. I might not write well, but to put up my stand, to share my knowledge to the world, my basic communication skill should be enough.

My background:

In the IRC world (yes, I did use IRC), they called me: microprocessor
Qualification: I have two qualifications.

1) Diploma in Electronic Engineering from University Technical Malacca, Malaysia (I'm a Malaysian). Basic Electronic Engineering from Kulim Technical School. (Google your self where is Kulim, Malaysia)


2) Degree in Software Engineering from University Technology PETRONAS (they also sponsors the Formula 1)
You might ask, why do I have two qualifications. Simply because I am very keen in both fields, electronic and software. As for me, creating the electronic circuit is like having the physical thing but by putting the software inside it, it is like giving the soul to the circuit.

Working experiences

1) Celestica, Kulim Hi-Tech Park - Preventive Maintaince Technician

2) Silterra, Kulim Hi-Tech Park - Computer Intergrated Manufacturing Software Programmer

3) Flextronics, Penang - Software Programmer

4) A Very Small Software House, Penang - Software Programmer

5) Intel, KM6, Kulim Hi-Tech Park - Test Engineer

6) Malaysia Institute of Microelectronic System (MIMOS), Kulim Hi-Tech Park - Software  Engineer

7) A good local company, Kulim Hi-Tech Park - Software Engineer, Test Development.
Programming language: C# .Net,  PHP.

With the Electronic Engineering and Software Engineering knowledge, I hope that I can share my technical problems and the solutions [please bear in mind that I will not share the whole project as it is my company's property :)   ] I hope people that have similar problem will Google it and found the solution that I am sharing here.

I will try to post a new problem/solution/article every time I'm stuck and found the solution so that I can share the knowledge with the whole world.

Whenever you found that my article is worth for sharing, be my guest! Please do leave any comment if you found a better way on the solution so that other people might benefit from it as well.

Thank you so much for visiting this blog

################
-- microprocessor --
################