vbin

vbin is a collection of Command Line Tools for Unix used with other Unix Bash commands to form a formidable arsenal of tools.

Source: https://github.com/dlink/vbin

Documentation: http://crowfly.net/vbin

Commands Listing

General Tools

clip dos2unix flatten histogram lshead orig origdiff phplook dstamp

dtstamp pllook psgrep pylook revver sav savdiff show_env.pl ssh_setauth

striphtml t2c tildadiff txt2html unflatten unix2dos unorig unsav

CSV Tools

• col_sum
• csv2html
• csv2inserts
• csv2wiki
• csvformat
• csvformat2
• show_header
• xlsx2csv

SQL Tools

• count
• count_distinct
• desc
• explain
• sql_pretty
• show_create
• show_indexes
• show_tables
• select5
• selectall
• selecthistogram
• selectmax
• selectsome
• tally

DETAIL DESCRIPTIONS

• fwk_usage

  List all foreign keys that refer to a given table

  Example:

  fwk_usage central order_items | mysql -t

  Returns:

  +-----------------+------------+-----------------------+
  | constraint_name | table_name | referenced_table_name |
  +-----------------+------------+-----------------------+
  | shipping_ibfk_1 | shipping   | order_items           |
  +-----------------+------------+-----------------------+
  

• histogram

  Generate a histogram from a list of data.

  Example:

  Given spreadsheet of names and addresses, as a csv file, answer the question: How many people come from each state:

  cut -d',' -f6 professors.csv | histogram