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:
+Activity of the last days (substitute date C<-v-{}d> on BSD):
- git log --pretty=%cd --date=format:%F --since=1month |
- perl -MTime::Piece -pE
- 'for ($t //= localtime; $t->ymd gt $_; $t -= 24*60*60) {say $t->ymd}' |
+ ( 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