Sunday, June 23, 2013

Web programming can be easy and fun

Having to be a database and VB application for a long time, I never thought of I have to get involved in web programming. Well, thanks to the coming project of setting up an intranet and extranet in my company, it has open up an opportunity for me to get involved in web programming.

So where to get started?

Check out codecademy.com! It has step by step instruction and on-the-fly on-screen result very keystroke in the code. Badges are awarded for the completed courses and there are no exam! No fee is required and absolutely free. Finally, there are forum for the community and helps are always there if I got stuck in the exercise.

Highly recommended to check it out if you are into web programming (or other programming which are available on the site).

http://www.codecademy.com/

Wednesday, May 22, 2013

Parameter or Table?


It's confusing for me that when I was asked to create a record about a transport vessel, I was told that I have to create it in the parameter screen, where it saves all the configuration plus master data. The information saved was trivia (only the vessel name and a key) but should it be stored in the parameter table? I'm puzzled but nevertheless I can do a comparison between the two approach.

Pro parameter
1. Quick and easy to save and edit.
2. No additional user interface. One parameter interface rules all.

Cons parameter 
1. Messy because other values (e.g. transport name, company name, model name) also stored in the same table
2. No room for adding new/custom fields
3. Value stored is not relevant to the field name. ("Value" field can be number, text or date)

Maybe it wasn't a bad idea after all, if the value will not have any further fields or attributes in the future. Else it's better to stick to a new table.

Sunday, May 5, 2013

Tomcat failed after install MS SQL server 2008


The cause is identified that MS SQL server reporting service port was using 80 and has been conflicting with tomcat port causing the web server unable to render webpage.

Reconfigure the port in SQL server 2008 reporting service and tomcat went back to live again.

Wednesday, March 6, 2013

Oracle Developer VM

I have tried to setup oracle express in my Windows 7 64bit machine but only to find out there are no 64bit Oracle express for windows to download. I tried to create a 64bit Ubuntu VM and setup the 64bit Oracle express Linux version but failed. Not willing spend more time on researching, I took the easy approach by looking existing Oracle VM and what I found is the Database App Development VM from Oracle. The downside is the 4GB file and it took a while to download.

After setup Virtual Box, Bios to make sure virtualization feature is on, "Enable IO APIC" and "Hardware clock in UTC time" is checked, finally I got the Oracle VM up and running within an hour. As I was poking around using the terminal to start up the database, the best way to start using this VM is by double click on the "Start Here" Firefox icon.


The first lesson is the SQL Developer data modeler, which I find it very interesting as the tool really show how help to create, identify and diagram the database table. Maybe this is old news and I might be living in the cave for a while now before realize there are such wonderful tool. :O

Anyway, there are more lessons to go and things to poke around in this VM. I took a VM snapshot just in case I screw things up so I can restore the snapshot back. Highly recommended for oracle developer to get one installed in their machine.

Reference
http://www.oracle.com/technetwork/community/developer-vm/index.html

Tuesday, January 1, 2013

Got extra ram not used by windows? Try Ramdisk to speed up web browser.

I just happened to find out there is free software to create a disk from RAM memory and the virtual disk speed is fast. I have installed the software and created a ramdisk of 512mb out from my notebook 4Gb memory. I configured Chrome cache folder and windows temp folder to the ramdisk. Applications seem to run faster (maybe it's paradox but icasa desktop softwareP seems to load a lot faster)

The downside is that it takes longer time to boot to windows (to load the disk image to RAM) and shutdown (to save the data from RAM to physical disk). I don't frequently shut down my notebook and always put it on standby. Therefore, I guess the startup and shutdown doesn't affect me much.

I also thought of upgrading my system with Solid State Drive (SSD) to improve performance but that is going to take a lot of effort to mirror the all the data from current harddisk. Furthermore, it's costly to buy a SSD today. The cheap and easy way, just upgrading the RAM and create the RAMdisk as necessary.

Updates: Try pairing ramdisk with PortableApps (portableapps.com), it works great for me.

Reference
Dataram Ramdisk (Free non commercial use limited to 4Gb)
http://memory.dataram.com/products-and-services/software/ramdisk

AMD Radeon version (same as above)
http://www.amd.com/us/products/desktop/radeon-memory/Pages/ramdisk-overview.aspx

Softperfect Ramdisk (Free non commercial use with no limit)
http://www.softperfect.com/products/ramdisk/

Guides
http://blog.raxco.com/2012/06/20/how-to-make-your-pc-50-times-faster-with-ramdisk-plus/