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.

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.

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…

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.