A few pics of a Sunday Afternoon Skating in Central Park, and of a HBO Film Festival currently being played at Bryant Park for everyone to see when the sun comes down.

Click to make big

Thanks to Rizmar for these pictures.

To give some context:
October 7th, 2000 – I just turned 20 yrs old, seems like I didn’t need my glasses
Caracas, Universidad Catolica Andres Bello, Software Engineering Computer Lab.
Second ACM Internal Programming Marathon

My teammate was Maritza Martinez, and I don’t remember if we had another teammate, I guess was Jesus Oliveira.

We chose to program in Java. Maritza was the wizkid that solved the problems, I had to code em up. I was learning Java at the time and decided to give it a try at the Marathon, other than the java.utils, and java.io classes, one of the things that helped us a lot was having the JavaDocs on screen while everybody else would look for reference on the books.

We didn’t win, but I guess we got to solve a couple of problems.

Check the pictures.

Let’s see if you can find me

click to make big

click to make big

Today I spent a great deal of time trying to pull something in one fancy SQL statement.

In the end, the words of my first algorithm teacher and common sense made me desist from making such a fancy SQL statement, which I still believe can be made…

The problem:

I have a bunch of Generic Translation Tags. These tags have been translated to english, and they need to be translated to other languages. I want to make a querie which will tell me, which Tags have not been translated yet to the other language… so you would think its only a left join and that’s it… think again.

Solution:
Got the tags ids translated in english, put them into a temp table
Got the tags ids translated in spanish, put them into a temp table
Left joined the english tags, with the spanish, now I got the english that are not in the spanish
Then join the Tags table with those ids… simple… divide, and you’ll conquer…

Here’s the code:
#1 FIRST WE GET THE TAGS WE TRANSLATED IN THE MASTER LANGUAGE
#AND PUT IT IN A TEMPORARY TABLE TAGS_MASTER
DROP TEMPORARY TABLE TAGS_MASTER;
CREATE TEMPORARY TABLE TAGS_MASTER AS (SELECT DISTINCT
Trans_tag_fk_id Tag_master_id
FROM TRANSLATIONS
WHERE Trans_lang_fk_id = $master_lang_id);

#2 THEN WE GET THE TAGS WE HAVE TRANSLATED SO FAR IN THE SLAVE LANGUAGE
#TRANS_SLAVE
DROP TEMPORARY TABLE TAGS_SLAVE;
CREATE TEMPORARY TABLE TAGS_SLAVE (SELECT DISTINCT
Trans_tag_fk_id Tag_slave_id
FROM TRANSLATIONS
WHERE Trans_lang_fk_id = $slave_lang_id);

#3 WE DO A LEFT JOIN (MASTER,SLAVE) TO OBTAIN THE IDS OF
#TAGS THAT HAVE NOT BEEN TRANSLATED YET IN THE SLAVE LANGUAGE
DROP TEMPORARY TABLE TAGS_MASTER_NOT_SLAVE;
CREATE TEMPORARY TABLE TAGS_MASTER_NOT_SLAVE (SELECT Tag_master_id,
Tag_slave_id
FROM TAGS_MASTER LEFT JOIN TAGS_SLAVE
ON Tag_master_id = Tag_slave_id WHERE
Tag_slave_id IS NULL);

#4 THEN WE JOIN THE RESULTS WITH THE TAGS TABLE
#AND APPLY THE GIVEN FILTERS
SELECT Tag_pk_id, Tag_name
FROM TAGS JOIN TAGS_MASTER_NOT_SLAVE
ON Tag_pk_id = Tag_master_id;

#DROP THE TEMPORARY TABLES
DROP TEMPORARY TABLE TAGS_MASTER_NOT_SLAVE;
DROP TEMPORARY TABLE TAGS_SLAVE;
DROP TEMPORARY TABLE TAGS_MASTER;
—

Hail SQL.

Really happy day today, have been waiting for it a long time.

I’m going to see Amigos Invisibles for the second time in NY City.

They’re gonna be playing on the City Latin Funk Music Festival

It’s also very exciting because I’m taking somebody very special with me, I’ve been playing all the Amigos Invisibles songs for the last couple of months and I know she’s gonna like them even more when she sees them on stage, hope they get to play a nice set to get that energy going.

Wish they had more promotion, these guys are one of the best dance bands of the world, they can play any thing from live tecno, to samba, salsa, blue, jazz, merengue, cumbia, venezuelan music, plus their lyrics are a lot of fun, mostly about sex and love, but with a very funny and teasing style, wouldn’t miss a concert for anything in the world. Make sure you buy their records and that you get to see them.

www.amigosinvisibles.com

Hopefully I’ll have some pictures for you when I come back tomorrow.

Damn it, its been a hot day in New York, the hottest day in 3 years,
with a record of 97F.

During the weekend I went to a lake where I could relax with my girlfriend and her friends, we got one hell of a tan. The lake even had a couple of swans, it was really nice.

Today I finally made it to the LimeWire.com Team Page, check it out

http://www.limewire.com/english/content/team.shtml

and in spanish
http://www.limewire.com/spanish/content/team.shtml

Let’s see if my name ranks higher now on google searches under “Angel Leon”

Other than that there isn’t much to say. Been reading a lot on innovation and I’ve been really busy with surprise web projects I’m working on at LimeWire.

Algunos comandillos nuevos que he aprendido, muy utiles.

Convertir el resto de una palabra a Minusculas
Alt+l

Convertir el resto de una palabra a Mayusculas
Alt+u

Seleccionar toda el documento
Ctrl+x Ctrl+p

Intercambiar la posicion del cursor (inicio/final o final/inicio)
una vez que seleccionas una region
Ctrl+x Ctrl+x

Cuando tienes la ventana dividida en 2 (Ctrl+x 2) o mas, y quieres cambiarte a la
otra ventana para editar en otra parte del archivo
Alt+x other-window

Indentar rapidamente
Ctrl+x Tab

Capitalizar (Un Texto Asi Con La Primera Letra)
Alt+x capitalize-region

—

How nerd are you?
http://www.nerdtests.com/ft_nq.php

And after a lot of fun during the weekend, I just can say I love summer in NY.

Don’t miss the videos from Central Park Today
http://dev.wedoit4you.com/images/060505

Grupo Capoeira Brasil was there to play Capoeira all afternoon.

Close by there were so many Park parties, the one I enjoyed seeing the most was formed by a bunch of energetic dancers and skaters that danced to the beat of a DJ in the middle of the park, see the videos and you’ll see how excited people were having fun in the warm weather. Wish in my country we didn’t take for granted the fact that we have this weather all year long, we’d have more parties like this an we’d get along better, I’m sure some Venezuelans have a lot of fun, but see the video so you see what I mean, just a bunch of strangers kicking it to the beat and having a lot of fun.

http://dev.wedoit4you.com/images/060505

Also my girlfriend helped me put together this capoeira video
http://dev.wedoit4you.com/images/060505/capoeira_head_spin.avi
I’m learning how to do a head spin, check it out.