Thursday, November 16, 2017

Dragon Ball Z: Light of Hope

Months of waiting and finally released. Dragon Ball Z : Light of Hope is a non-profit, live action web series produced by indie filmmaker, Robot Underdogs. It was a project which has been working off for months with such amazing low budget. Hollywood must be ashamed.

Tuesday, October 17, 2017

First Giant Robot show for the first time in History

First ever Giant Robot fight in history! It seems that the Japanese robot looks nicer than the Americans ones. As a robot fan, I would definitely watch it tonight! Reminds me of Pacific Rims and part 2 which will be showing in cinema soon. I am not sure if I would still be alive to see robots which will have super fast actuator like Gundam in future.

Tuesday, October 10, 2017

Star Wars: The Last Jedi Trailer finally out!

The trailer is finally out but it seems that there is a major spoiler that is quite obvious in it. Don't watch if you can, it's only less than 2 months away. btw, Luke finally talks.

Thursday, September 21, 2017

Mysterious Life of Developers

That pretty sums up most of the 3 different types of developers. :/ I used to be the one drinking coke. lol.

Tuesday, September 19, 2017

Practical VFX from GOT

Game of Throne is no doubt one of the best English drama I ever watched. Love, War, and Politics, you name it. How amazing Visual effects aka VFX has become so natural that when you are watching, you cannot differentiate between CGI and real people. It's so impressive that I have to post the video for sharing.

Original Source Here

Thursday, September 14, 2017

The human walking notebook.

A 2-time memory world champion, Yanjaa Wintersoul. (What a cool name btw!) Born in Mongolia, and raised in Stockholm, Kenya and Tokyo. She was recently invited by Ikea to face a series of campaigns in Singapore, Malaysia and Thailand. She will need to study and memorised on every page of the Ikea catalogue book. 

Sunday, May 14, 2017

Project Home Automation - Thought process - Part 1

Last year I have been so busy with working and planning for my new home and decided that I should plan on working on home automation. The earliest video which I encounter that triggers me to work on automation was this video.

Back then it was so cool that I have a lot of inspiration and thoughts on this. Somehow, along the way, when I try to think of the thought process, I realised that home automation is are cool but are they practical?

I started out experimenting stuff by doing it manually and see why automation is needed and why some are not. I need to plan carefully to be smart home ready before my renovation completed, I will not expect any wires to run around my house to fit into the automation plan.

There are also a lot of ideas and things I wanted to do and since I am revamping my whole house I should start thinking about these few items for a start.

Fundamental of Automation
There are 3 components that make up the Automation
  • Controllers, making an intent to trigger an event
  • Sensors, to react on system states
  • Actuators, the mechanics that output the result of the finished state
Automation Action
2 basic principles to think about.
  • Reactive, when you need to switch on and off something, you need to act on a command so that it sends a signal to the device to act on it effortlessly.
  • Proactive or events, scheduled action that will be acted upon automatically and effortlessly.
The basic needs for every home automation if you cannot even control your lights, you can forget about automation. In smart lighting automation world, there are a few things that you need to plan before committing.
  • Should you control your light from the bulbs or should you control from the switch?
  • How should you run your wires? Is there different between a normal wiring and automation wiring?
  • Did you do any research that what kind of communication to use? Zigbee? Zwave? Wifi?
Fan and Airconditioning
Fans and Aircon are the 2nd most touched on for automation. In the current market, not a lot of these devices are smart. Most of these device's sensors are using infrared devices. A hard one to picked on.

This one is optional but useful to have it. I only have 2 ideas on it. Planting surveillance camera and door lock. For the camera, I have no idea which will be better for me and I am not going to drill a hold on my door just for this one. I probably will place in my living room pointing towards the main door. As for the door lock, I will check if there are any APIs which I can work on to connect back to my main controller. This will be my roadmap.

It will be cool to have this feature but not too annoying, I will probably take note of it and ran some experiment.

It should have weather reports, bus status and probably my stats. So far I think room temperature is a gimmick which I don't think I will put that in my plan.

In my next few posts, I will be explaining the reasons how did I conclude my decisions and my selections for each of the thought process which I have mentioned above.

To end this post, remember this point, Automation is to help you to improve your life quality and not making you lazier.

Thursday, February 2, 2017

Generate dynamic script using Qlikview Script

Having to use Qlikview for around 1-2yrs, I find that Qlikview script is quite easy to pick up for those developers who have the basic programming foundation. Having to work on QV in my job, I have discovered 'hacks' that you can use qv scripts to eg. generate dynamic scripts, manipulate directories, creating ETL and many more.

One of the ways I am going to show you is to be creative and do something that is out of the box.

Generate dynamic ftp script.

NoConcatenate myscript:
LOAD * Inline [
# MyCodeTitle
open s,
cd myremotedir,

LOAD 'get c:\myloaddir' AS '# MyCodeTitle' AutoGenerate 1;

LOAD * Inline [
# MyCodeTitle

STORE myscript into [C:\script.txt] (txt);

What I did is to load an inline script to create 1 column cannot be more than 1) name as # MyCodeTitle which will be shown as remarks on the generated script. The column cannot be more than 1 as it will be tabulated.

The middle part is where the magic happens.
LOAD 'get c:\myloaddir' AS '# MyCodeTitle' AutoGenerate 1;
This part of the code can be dynamic and you can actually create a for loop wrapping around this code if you need to read data from somewhere.

and Finally
LOAD * Inline [
# MyCodeTitle
;STORE myscript into [C:\script.txt] (txt);
You end your ftp script by concatenating your previous dataset and save it as your ftp script. script.txt.

Now you can open your script and it should look like exactly like an ftp script.
It's that easy! And remember to drop table after storing it!