I use sqlite quite heavily, it is my central point for tracking and storing data, as mentioned in other posts, small database little snippets of Python ensure i can automate quite a lot of stuff I do, plus I can always have the information on hand.
I was working the other day and made a mistake in an update statement, luckily I was on my windows machine using Cygwin, and like your bash history there is also a .sqlite_history file.
This works the same and stores all your command history, so you can easily see all the commands you have run. Very easy if you want to recall that difficult select statement you wrote previously.
Just look in your home directory for .sqlite_history, it's a hidden file.
I am always interested in feedback so please feel free to add any comments, or you can mail me here. If you would like to submit a quick tip with full credit and links back to your site then also feel free to contact me.
