Over the years my Tab/Sql History became huge, and it is working very slow. I am looking for a way to clean up.
1. There is no way to select multiple lines to delete. Delete is available only for one row. For example, every ALTER PROCEDURE creates history. I don’t need it at all. I would like to find all of them and delete.
2. There is no functionality to compress and reindex Sql History database.
3. Ironically “Send Feedback” link on a bottom of screen leads to nowhere.
After 7 days some snapshots are removed (query edited and connection changed) and then VACUUM is run on the SqlHistory.db file which rebuilds the database file, repacking it into a minimal amount of disk space.
Does this cover what you're looking for here, or would adding the option still be useful?
Quick update on 3 - the latest version of Prompt has removed this feedback link.
I'll come back to you on the other requests.