Advanced Shell History         http://code.google.com/p/advanced-shell-history/


Save your command line history in a sqlite3 DB!


Features of this utility:
  * Retains extra command details:
    * exit code
    * start and stop times (and command duration)
    * current working directory of the command
    * session details such as tty, pid, ppid, ssh connection details
  * works with multiple shells (zsh and bash)
  * saves history into a sqlite3 database
  * provides a convenient tool to query the history database.


HOW TO BUILD:
  $ make build_c       # Builds the C++ version
  $ make build_python  # Builds the Python version
  $ make build         # Builds both versions

Notes:
  * A full build of the code from source depends on the following commands
    or utilities existing on your build system:
      - bash
      - make
      - g++ and gcc
      - curl
      - tar
      - unzip
      - sed and awk
      - flex (optional: only needed if rebuilding queries.cpp from queries.l)
  * Also recommended is sqlite3 for writing new queries interactively.
  * On a Mac, you will need to install xcode for make, g++:
      http://developer.apple.com/xcode/


HOW TO INSTALL:
  $ make install_c       # Installs the C++ version
  $ make install_python  # Installs the Python version
  $ make install         # Installs both versions


HOW TO UNINSTALL:
  $ make uninstall


HOW DOES THIS WORK:

This program operates on the assumption that your shell gives you the ability
to execute a custom operation before a prompt is redrawn on your terminal.

Bash provides the PROMPT_COMMAND environment variable while zsh gives us the
precmd environment function.  Both are repurposed by this program to log the
previous command into a local database before each new prompt is displayed.

Many people have never heard of this feature or found a great use for it.
However, if you currently DO use this feature, you can still use this program.
The code renames your existing hook and invokes it after saving the previous
command.


Caveats:
  * this is not meant to be a security auditing tool - it's for user
    convenience and meant to enhance shell builtin history.
  * for bash users, this overrides your PROMPT_COMMAND and changes the 
    default options of your builtin history.  Hopefully both are an 
    improvement.
  * for zsh users, this overrides your precmd function.  the shell script
    attempts to rename your previous precmd function and continue to hook
    into it.
  * all users will notice that the PIPESTATUS / pipestatus variables have
    been renamed to ASH_PIPESTATUS.  Because these variables are transient
    and logged, they cannot be easily restored.  Instead they are copied.
  * when you build this, the Makefile may download a version of sqlite3
    (if it's not already included in the tarball or the svn repo).
  * this potentially changes your normal shell history settings to enable
    options necessary for the magic to work.

Bugs:
  * doesn't capture exec'ed commands: example: exec rm /tmp/foo # is lost
  * the python version is about 10x slower than the C++ version

Author: [email protected] (Carl Anderson)
Last Update: 2012-08-06