echo 'SELECT count(*),schemaname FROM pg_tables GROUP BY 2' |
psql -t | barcat -u
+Earthquakes worldwide magnitude 1+ in the last 24 hours:
+
+ https://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/1.0_day.csv |
+ column -tns, | graph -f4 -u -l80%
+
External datasets, like movies per year:
curl https://github.com/prust/wikipedia-movie-data/raw/master/movies.json |
git shortlog -sn | barcat -L3 -s
+Activity of the last days (substitute date C<-v-{}d> on BSD):
+
+ ( git log --pretty=%ci --since=30day | cut -b-10
+ seq 0 30 | xargs -i date +%F -d-{}day ) |
+ sort | uniq -c | awk '$1--' | graph
+
=head1 AUTHOR
Mischa POSLAWSKY <perl@shiar.org>