I needed to find all the users with duplicated phone numbers in the phone_number table (same phones have the same number and same country_id):

SELECT user_id, number, COUNT(*) FROM phone_numbers GROUP BY user_id, country_id, number 
HAVING COUNT(*) < 1;

htop is an alternative to the traditional unix top, with a lot more features, being the most visible the pseudo-graphical header.

As images are worth a thousand words, here you have top and htop running in the same machine, notice that in htop apart from the graphical header the processes are showed in a tree.

(download)

Click here to download:

htop_alternative_to_top.zip (261 KB)

2. for command in `ls /System/Library/Frameworks/JavaVM.framework/Versions/1.6/Commands`; do echo $command; sudo rm /usr/bin/$command; sudo ln -s /System/Library/Frameworks/JavaVM.framework/Versions/1.6/Commands/$command /usr/bin/$command; done

3. Enjoy!

Wow!

Impossible del.icio.us is now delicious.com. Totally incredible! This is a shock!

At first sight the new design is pretty, more modern than the previous. Maybe a little too much hover effects, but nothing I cannot stand. I'll have to use it for a couple of days to see if the change is worth, or if has been only a facelift. Keep tuned!

While working on a couple of forms for an upcoming web I decided they deserve a "Cancel" button. Searching for a way to implement it I arrived to the Reset / Cancel Button Considered Harmful by Jakob Nielsen, the usability guru.

The main idea is that a Cancel/Reset button is not necessary because the user will use the back button if they decide not to save the form. Also, more buttons mean more clutters, in this case unnecessary.

Of course, these are online guidelines and in a shopping cart or in a multi-step form it may be desirable to have a remove and cancel, respectively, buttons.

I mean, a screencasts is something good to take a peek to a new project, but if you want to learn how to use a piece of text where you can go at your own pace, in some places faster in other slower. Although, in the embedded flash videos is almost impossible to read what they type.

In Ruby many operators are implemented as method calls. For example you can write:

>> 3 + 4
=> 7

as:

>> 3.+4
=> 7

In this case we call the method + on the Fixnum 3 and pass as argument the Fixnum 4.

>> 3.class
=> Fixnum

While it's good to have expressions built-in as methods, so the programmer can extend/modify them I think thay still relying on the receiver class to determine the method to be called is not the best solution. Personally I think that generic functions, found for example in Lisp, are a way better and more elegant solution

Hey there!

Although I already own a "big" blog at egimenez.com, I only want to use it for long and thought articles. I'll use posterous to record short notes, quick ideas, and all that miscelanea that doesn't fit in the "serious" one. I love to be able to post anything from e-mail, thaaaats good!

Now I only need an iPhone... 11th July is near!