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):  http://feeding.cloud.geek.nz/2009/02/finding-size-of-postgres-database-on.html

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  http://publiclaboratory.org

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