SQL History
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.
Victor
shared this idea
-
Ricardo Corral
commented
And make the "Delete" key work when an Item is selected. At the very least, after selecting "delete query and its history" make the "Enter" key work in the annoying confirmation (or remove the annoying and unnecessary confirmation).
-
On, 2:
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.
