archive

Archive for October, 2007

Flickr Viewer

Thursday, October 25th, 2007

Flickr ViewerGreat application to view flickr photos!

Number of Inhabitants per Doctor

Wednesday, October 24th, 2007

Number of Inhabitants per DoctorGreat way to highlight the density (better: the lack) of doctors around the world and especially in Africa.
Source

Postgres Crosstab Function

Friday, October 19th, 2007

Great function in Postgres (in the contrib/tablefunc package): It transforms the more lines-type result into column-type.

So instead of this:

c_name | year | value
—————————————
Germany | 2001 | 123
Germany | 2002 | 125
Germany | 2003 | 128
Germany | 2004 | 132
Germany | 2005 | 135

Italy | 2001 | 412
Italy | 2002 | 429
Italy | 2003 | 456
Italy | 2004 | 465
Italy | 2005 | 477

one gets this:

c_name | 2001 | 2002 | 2003 | 2004 | 2005
————————————————————————
Germany | 123 | 125 …..
Italy | 412 | …..

with this code:

SELECT
*
FROM
crosstab(
'SELECT
COALESCE(c.name, ''''),
year_start AS year,
value
FROM
agri_area AS d
LEFT JOIN
countries AS c ON c.id = id_country
WHERE
year_start = 2003 OR year_start = 2002 OR year_start = 2001
GROUP BY
name, id_country, year_start, value
ORDER BY 1,2;'
, 3)
AS ct(name varchar, y_2003 numeric, y_2002 numeric, y_2001 numeric)

World Clock

Friday, October 19th, 2007

World ClockReally cool application, showing at each second the change of population, number of people infected by diseases, oil pumped, car produced etc. etc…

Another Terminal: iTerm

Wednesday, October 17th, 2007

iTermThe traditional Mac Terminal is a bit out-of-date. iTerm offers Safari-styled shelling, with multiple tabs, bookmarks etc… Cool.

Safari Source

Wednesday, October 17th, 2007

Safari SourceA script which adds syntax coloring to Safari’s source view.

Indexation vs Standardized Normalization

Monday, October 15th, 2007

Indexation vs Standardized NormalizationJust a quick comparison of two methods: indexation and standardized normalization. Given are three variables – two on emissions and GDP per Capita. The s.n. gives differences in small values a higher visibility, whereas the indexation allows to read more precisely the evolution (“a raise of 35%”). Disadvantage of latter is surely the choice of the “common” year…

Safari Tidy

Thursday, October 11th, 2007

Safari TidyThe Safari Tidy plugin is a small plugin that lets you validate the webpages you browse for (x)html compliance. The actual validation is done by Tidy. This plugin was modeled after a similar plugin for Firefox.

Internet Connections

Tuesday, October 9th, 2007

Internet ConnectionsWorld City-to-City Connections