bash_database_history

KO | EN

gitlite — search

#react #ai #typescript #llm #golang #android #deep-learning #docker #macos #nodejs #awesome #cli #awesome-list #security

bash_database_history

(★ 35)

save your bash/zsh history to mysql or sqlite

bash_database_history Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# shell_database_history
save your bash/zsh history to mysql or sqlite

see `bashrc_trap.sh` or `zsh_trap.sh`

1) create databases you like (see `bashrc_trap.sh` for templates)
2) comment/uncomment what you need to use (mysql/sqlite3)
3) source `bashrc_trap.sh` or `zsh_trap.sh` at the bottom of your `~/.bashrc` / `~/.zshrc`
4) enjoy your upgraded history using some aliases

```
mysql> select count(command), cwd from bash.history group by cwd order by 1 desc limit 10
+----------------+--------------------------------------+
| count(command) | cwd                                  |
+----------------+--------------------------------------+
|            715 | /home/user                           |
|            393 | /home/user/b/chtest                  |
|            325 | /home/user/b/hubble                  |
|            319 | /home/user/b/dump-clickhouse         |
|            311 | /home/user/b/chtest/scripts          |
|            297 | /home/user/d/afd                     |
|            171 | /home/user/b/afonline                |
|            112 | /home/user/d/afd/src/rules/asn/build |
|             83 | /home/user/d                         |
|             81 | /home/user/temp                      |
+----------------+--------------------------------------+
10 rows in set (0.06 sec)

mysql> select count(command), date(created)  from bash.history group by command, date(created) order by 1 desc limit 20;
+----------------+---------------+
| count(command) | date(created) |
+----------------+---------------+
|             57 | 2018-11-14    |
|             51 | 2018-11-20    |
|             50 | 2018-12-04    |
|             47 | 2018-11-29    |
|             41 | 2018-11-26    |
|             35 | 2018-12-06    |
|             33 | 2018-11-11    |
|             33 | 2018-11-25    |

```
Some example aliases

```
@his(){
	limit=""
	command="select oid, created, command, cwd, tag from bash.history where command like '%$1%' "
	if [[ -z "$2" ]]
	then
		1=1
	else
		limit="order by created desc limit $2"
	fi;
	
	mysql -e "$command$limit"
	echo "run @ NUMBER to repeat command"
}

function hitag(){
	export HISTORY_TAG=$1
}

function hiuntag(){
	export HISTORY_TAG=''
}

# alias historyMysqlDel="mysql -e "use bash; truncate history""
```

bash_database_history

bash_database_history Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

bash_database_history

bash_database_history Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README