Skip to content

Instantly share code, notes, and snippets.

@kristjan
Last active August 29, 2015 14:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kristjan/e8222575114bd8fafe8e to your computer and use it in GitHub Desktop.
Save kristjan/e8222575114bd8fafe8e to your computer and use it in GitHub Desktop.
DB color distribution
# All colors on all applications
$ for app in `heroku apps | tail -n +2`; do heroku config --app $app | cut -d':' -f1 | grep HEROKU_POSTGRESQL | cut -d_ -f3; done | sort | uniq -c | sort -rn
4 WHITE
3 CHARCOAL
2 YELLOW
2 ORANGE
2 ONYX
2 CRIMSON
2 COBALT
2 BRONZE
2 AQUA
1 NAVY
1 MAUVE
1 MAROON
1 IVORY
1 GREEN
1 CYAN
1 BLACK
1 AMBER
# Only colors assigned to a current DATABASE_URL
$ for app in `heroku apps | tail -n +2`; do heroku pg:info --app $app | grep 'DATABASE_URL' | cut -d' ' -f2 | cut -d_ -f3; done | sort | uniq -c | sort -rn
2 YELLOW
2 WHITE
2 ONYX
2 CRIMSON
2 COBALT
2 CHARCOAL
2 BRONZE
2 AQUA
1 ORANGE
1 NAVY
1 MAROON
1 GREEN
1 CYAN
1 BLACK
1 AMBER
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment