Flickr Viewer
Thursday, October 25th, 2007Great application to view flickr photos!
Great application to view flickr photos!
Great way to highlight the density (better: the lack) of doctors around the world and especially in Africa.
Source
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)
Really cool application, showing at each second the change of population, number of people infected by diseases, oil pumped, car produced etc. etc…
The traditional Mac Terminal is a bit out-of-date. iTerm offers Safari-styled shelling, with multiple tabs, bookmarks etc… Cool.
Just 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…
The 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.