sqllite commandline history via up/down keys
I found very annoying problem with sqlite CLI. When you press up/down arrow keys, it prints ASCI characters of the keys rather that showing historical commands. When I googled, I realised that we can either link readline library when compiling sqlite or do: sudo apt-get install rlwrap rlwrap sqlite3 database.db worked like a charm for me.