git.shiar.nl
/
barcat.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
earthquake feed example
[barcat.git]
/
barcat
diff --git
a/barcat
b/barcat
index c2f41aa97c9365debb63be1ebdfd8d3b5003d19d..5863c4c952b527438ef29accfc93b9681de71272 100755
(executable)
--- a/
barcat
+++ b/
barcat
@@
-355,6
+355,11
@@
Any kind of database query with counts, preserving returned alignment:
echo 'SELECT count(*),schemaname FROM pg_tables GROUP BY 2' |
psql -t | barcat -u
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 |
External datasets, like movies per year:
curl https://github.com/prust/wikipedia-movie-data/raw/master/movies.json |
@@
-389,7
+394,7
@@
Or the top 3 most frequent authors with statistics over all:
git shortlog -sn | barcat -L3 -s
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=%ci --since=30day | cut -b-10
seq 0 30 | xargs -i date +%F -d-{}day ) |
( git log --pretty=%ci --since=30day | cut -b-10
seq 0 30 | xargs -i date +%F -d-{}day ) |