Linux Ubuntu finally arrived.

Ubuntu Linux from Netherlands finally delivered the copies I ordered for you guys.

After taking my copies and giving some to my friends, I have the following
in Inventory for those who are interested:

-> 9 Ubuntu Linux 5.04 for Intel x86

-> 1 Ubuntu Linux 5.04 for AMD64/EM64T

-> 4 Ubuntu Linux 5.04 for PowerPC

After those run out, I can make copies of the ones I left for me
and ship them to you. I will only charge a symbolic price for the media
and the shipping cost.

More about Linux Ubuntu at www.ubuntulinux.org

It comes with 2 CDs, the Live CD and the Install CD.
The Live CD allows you to run Ubuntu without installing it, you just reboot your machine with it, and you’ll be running Linux from the CD. This is good to test the compatibility of your hardware against ubuntu. Once you know how it behaves, and if you like what you see, you can proceede to install Ubuntu with the install disc.

Those interested can write to wedoit4you@gmail.com to see if we’re out of inventory.

Look at me when I was still in School

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

Fun with SQL Left Joins

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.

Preparense… Camino al cielo ya viene…

Hola, les doy las gracias por haber entrado a este blog y por las criticas y comentarios que me han participado (aunque fueron pocos, jejeje). Escribo en esta oportunidad para decirles que se preparen… Porque de ahora en adelante van a ser testigos (todos aquellos a los que se les de por entrar a ver mi blog) de unas historias que reflejan el afan humano por realizar sus mas profundos deseos y metas. Algo que simplemente va por encima de las normativas de la realidad, es el enlace entre el mundo humano y las puertas del cielo. Todo esto reflejado en un poema de 4 partes llamado…

Camino al cielo

Esperenlo, les prometo que vale la pena…

Shadowargel the Angelodim…

Para aquel que espera

Primero que todo… hola de nuevo amigos mios, en esta ocasión les escribo acerca de las persona que esperan por quienes nos traen el amor a la vida. Le dedico este poema a Greysamar Reyes (Carlita)por ser una persona muy especial conmigo y apoyarme siempre que lo he necesitado. Y ahora con mucho gusto, para ustedes “Para aquel que espera”.

Para aquel que espera.

-Para aquel que espera,
quien sus sentimientos entrega,
que la larga noche los lleva,
y cuyos corazones congrega.

-Que siente que la vida,
corre y corre sin parar,
contra los sueños y contra la ida,
de un tiempo sin vuelta atras.

-Porque solo entiende el que ama,
y tambien aquel que no ha de amar,
que el corazón es el tranporte,
para cruzar el largo mar.

-El mar es aquel que separa,
todo aquello que se quiere encontrar,
tras un largo sueño, un año, un día,
solo aquello que se quiere amar.

-El mar es la desesperación,
que afrontan todas las almas,
que se quieren y entristecen,
y ademas calman sus ansias.

-Es por eso que hoy escribo,
inspirado en una persona,
la cual ama y adora,
a quien espera a toda hora.

-No es que me de lastima,
pero si me da tristeza,
ver esperar a ella que ama,
a aquel que promete y no regreza.

-Mientras que el amor exista,
que sean bienvenidas las pruebas,
que afronta el amor fijista,
quien ama, de aquel que espera.

-Pero al final la recompenza es grata,
porque has visto a quien esperas,
y dices que valió la pena,
porque brilla el amor del alma.

Para Carla que se ha portado conmigo de una manera impresionante, porque solo ella logra apartar la maldad de mi corazón, y solo ella enciende en la oscuridad una luz que me hace seguir adelante y buscar una salida de mi oscuro trance… Si llegas a leer esto, recuerda que te quiero mucho.

Shadowargel the Angelodim.

Tonight: Amigos Invisibles!!!

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.

Hottest day of the year.

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.

Otros comandos de eMacs.

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

I am nerdier than 89% of all people. Are you nerdier? Click here to find out!

Summer is here

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

Gubs @ Long Island with his Dream Girl

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.