D 2018-11-15T22:41:24.962
L histstore
P 61e1df1f3c6b782a2c30e0a52c5459d1689c0367
U mrwellan
W 1256
<h2>Histstore</h2>

Store your command line history in a quickly searchable sqlite3 database. For those of us in the electronics design industry or anyone else who must remember long obscure and complicated command lines ...

<h3>Install from precompiled tar</h3>

(NOTE: Send requests for additional platforms to matt @ kiatoa.com)

Download from this link: [/uv/histstore/histstore-sles11.tar.gz|histstore-sles11.tar.gz]

Untar the file in some convient location:

<verbatim>tar xfvz histstore-sles11.tar.gz</verbatim>

Link the binary to some location on your $PATH as "hs"

<verbatim>ln -s $PWD/histstore/histstore ~/bin/hs</verbatim>

Now test:

<verbatim>history | hs -save
hs %</verbatim>

<h3>Compile and install</h3>
<verbatim>
csc histstore.scm -o hs
cp hs ~/bin
</verbatim>
<h3>Usage</h3>
Set up some aliases
<verbatim>
alias kh='history | hs -save'

> kh
Saving command lines to db...
saved 0 lines
saved 500 lines
</verbatim>

Every once in a while when working type "kh" to store your commandlines.

Use "hs" to search. "%" is the wildcard:

How did i fix that problem in mythtv? 
<verbatim>
> hs mysq%char%
mysql -u root -e 'alter database mythconverg default character set latin1;'
</verbatim>
Z ca7c7c023c21b7129e93fb8f6c7058f0