Posts for the month of May 2011

How big was that database?

Database servers are great, but there's a lot of magic in there sometimes and it can be hard to figure just how much storage is being taken up by what database and which tables.

A nice little hint on how to check the size of the whole or parts of you database server (Postgres):

Or for the lazy

SELECT pg_database.datname,
       pg_size_pretty(pg_database_size(pg_database.datname)) AS size
  FROM pg_database;

Public Laboratory, citizen science getting serious.

Just wanted to share a project I recently became aware of after making a trek over to  WhereCamp2011

They've got some great ideas for home brewing some nice science equipment for remote sensing, check it out at

Here's a link to my  flickr stream with photos of some of their airborne camera platforms.