Steve Jobs Quotes

by heru on August 27, 2011

Your time is limited. Don’t waste it living someone else’s life.

Because the people who are crazy enough to think they can change the world, are the ones who do.

Steve Jobs. Thank you.

 

{ 0 comments }

Query #1:

2
SELECT * FROM a, b WHERE a.b_id = b.id AND b.id > 0;

vs

Query #2:

2
SELECT * FROM a INNER JOIN b ON a.b_id = b.id AND b.id > 0;
  1. Are they the same?
  2. Do they produce the same result?
  3. Which query runs faster?
The third one is actually a trick question. The answer for #1 and #2 is that technically both are the same. I have found this out of curiosity after doing an interview with fresh graduates that have the habit of using INNER JOIN instead of =.
After researching through, I found out that a thread in stack overflow discusses this in pretty details. Please make sure your read other answers as well!
Basically in summary from StackOverflow:
  1. #2 is easier to read when you have multiple tables involved.
  2. #2 is safer because #1 if you miss the ‘=’, then it will cause a cartesian join (which in 2 large tables, it will be very painful!
I am found guilty that I am a habitual practice of #1. I think it is time to break my old habit and adapt a new one.

{ 0 comments }

How to Hide Status Bar Using XCode 4

August 27, 2011

How to hide the status bar in Xcode 4? Amazingly, it is pretty straightforward. In XCode, go to your project folder > supporting files > [project name]-Info.plist Hover to the last line and click the “+” button to add another entry. Enter the key field as “UIStatusBarHidden”. Once you’ve done that, it will change to [...]

Read the full article →

Not User Centric Design, Not Activity Centered Design, but Situational Centered Design

February 28, 2011

Reading the new edition of “Designing the Obvious” by Robert Hoekman, Jr has certainly led to many new insights about creating user interfaces. Many of us have come to know the terms of “user centric design” (UCD). In UCD, designs are based on research on users. While these designs might create great designs, this approach [...]

Read the full article →

jQuery Ajax Call Getting the Redirect Content Problem

January 17, 2011

When submitting a form, we will usually get redirected to the “thank you” page. During this process, the header given out at the target page is 302 redirect. So, what has this got to do with jQuery AJAX Call? We might have used jQuery AJAX call to submit a form and this form redirects it [...]

Read the full article →

Fix: jQuery UI Dialog Align Bug on Google Chrome

December 30, 2010

We have recently found out that there is an alignment bug on the “Dialog” feature of jQuery UI on Google Chrome. In the picture below, you notice that the Dialog window appears to be aligned on the left instead of in the center in Google Chrome. It turns out that there is a quick fix [...]

Read the full article →

Update to WordPress 3.0.4

December 30, 2010
WordPress

WordPress just released a Critical important security update to 3.0.4. From their site, it seems that there is a bug in WP KSES HTML sanitation library that will allow XSS (Cross Site Scripting) vulnerabilities. How urgent is it? Here’s a quote from the announcement: I realize an update during the holidays is no fun, but [...]

Read the full article →

Happy Clients and Return on Investment

December 26, 2010

When you invest on something, you will be happy when you receive a return on your investment. Right? Same with your client. A client doesn’t just pay for your service or product. He / she invests something on you. Thus, it is clear that ROI is expected. Until then, it is hard to imagine or [...]

Read the full article →

Minify or Compress HTML Output with CodeIgniter

December 23, 2010

In web design, it is important that you minify or compress your HTML web page for a faster load. Google Page Speed includes “Minify HTML” as one of the factors that contribute to a fast loading web page. Fortunately, you can do this easily with CodeIgniter using Hooks. Learn more about CodeIgniter Hooks. In order [...]

Read the full article →

3 Ways to Optimize Back End

December 6, 2010

This is the third part of the Web Optimization series. In the previous part, we have discussed that there are 3 different areas where you can optimize in a web design – backend area, frontend area, and in-between area. In this article, we will go deeper into backend area optimization. When we say “backend”, we [...]

Read the full article →