sqlite history file

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.

Related Posts Plugin for WordPress, Blogger...

Remove Spaces from a text file

the application cannot be opened -1712

the application cannot be opened -1712