Author: Madhax | Published: 27th January 2010 | RSS | LINK
I investigated various ways of deleting duplicate rows in a MySQL table. My problem required that the method should be quick, fault tolerant, verbose and be able to handle large datasets. Following is a list of common ways to either select distinct rows or delete duplicate rows from MySQL tables, along with how long it [...]
Author: Madhax | Published: 11th November 2009 | RSS | LINK
A couple weeks ago I had been working on something I thought would be pretty cool. The idea was a video player that could stream videos from external servers. The way I had planned on accomplishing this was via JavaFX and a signed applet. Needless to say (if you read the title) it didn’t really [...]
Author: Madhax | Published: 16th July 2009 | RSS | LINK
I recently had an interesting experience with Facebook. I made an application that let a user search for another user’s public albums even if they weren’t on each other’s friends list. This application didn’t violate any clause of the TOS list at the time. The application made use of a design decision on Facebook’s part [...]