archive

Archive for January, 2007

Städte

Friday, January 26th, 2007
Die
bevölkerungsreichsten Städte der Welt…
http://worldatlas.com/citypops.htm

Excel Charts

Thursday, January 18th, 2007

excel_carres.pngNice chart… Read more here.

PostGres – Conditional Statements

Tuesday, January 16th, 2007
SELECT grp, SUM(cnt) AS cnt FROM (

SELECT url_request,
CASE

WHEN url_request like ‘%metadata%’ THEN ‘metadata’

WHEN url_request like ‘%map%’ THEN ‘map’

WHEN url_request like ‘%graph%’ THEN ‘graph’

WHEN url_request like ‘%values%’ OR url_request like ‘%table%’ THEN
‘values’
WHEN url_request like
‘%download%’ THEN ‘download’
ELSE
‘other’
END

AS grp, SUM(number) AS cnt
FROM
hits_per_urlrequest
GROUP BY
hits_per_urlrequest.url_request)
AS foo

GROUP BY grp
ORDER BY cnt DESC

Web Site Development – Interesting Approach

Tuesday, January 9th, 2007
Interesting article about how to approach the
development of a new site/layout from the viewpoints of a write, an engineer and
an artist, but all together as one person.