Archive for July 10th, 2007

10
Jul

Snow in Buenos Aires

Yesterday Buenos Aires received first snowfall in 89 years! As I don’t watch TV or any other form of news, I would probably never hear about this if Tatiana didn’t surprise me this morning with information about the snow. The news is even more surprising since Marica and I were visiting her two years ago at approximately same time of the year and the weather was everything but cold. We wore shorts and t-shirts all the time, even in the evening, and we used to sunbath under the Obelisco.

This seems to be one of the coldest winters in South America in a long, long time. Global worming works in strange ways, indeed. While you think about it enjoy in the pictures of beautiful Buenos Aires covered in snow.

Buenos Aires in Snow

Buenos Aires in Snow

Photos are courtesy of Jeff.

10
Jul

DIA from SQL

Today I needed a fast way to generate DIA diagram from an MySQL database structure and I found this great little project on SourceForge called, very convenient, sql2dia. This tool is actually a PERL script which generates XML file (yes, if you ever wondered, DIA file format is pure XML. Nice, a? :)) sql2dia does not provide support for relations between tables, but this feature is planed for the future releases. Anyway, it does exactly what I needed it to do – create a diagram of tables in my PostfixAdmin database (don’t ask why… yet :)). Here is an example how it works and the result.

[ home sql2dia ] # ./mysql2dia -D -d maildb -h localhost \
> -u username -p password -o mail.dia
Debug mode activated.
Creating header…
Creating object admin…
Creating object domain…
Creating object vacation…
Creating object mailbox…
Creating object log…
Creating object alias…
Creating object domain_admins…
Creating footer…

sql2dia