Feature request: prune history

[thePanz]

Thank you for the amazing tool you created!

I am looking for a feature to prune/clear the commands history, like:

• remove commands executed only one time
• remove other less frequent commands
• remove by a regular pattern
• remove by host or user

Not sure if this is already implemented. any hints?

[gary-ruizhang]

Not find an option for prune history. Currently I delete manually use the following sql (I don't need the directory filter, add cwd to the group by section if you need that)

DELETE FROM history
WHERE rowid NOT IN (
    SELECT max(rowid)
    FROM history
    GROUP BY command
);

[miles170]

Not find an option for prune history. Currently I delete manually use the following sql (I don't need the directory filter, add cwd to the group by section if you need that)

DELETE FROM history
WHERE rowid NOT IN (
    SELECT max(rowid)
    FROM history
    GROUP BY command
);

This only clears the local history. Is there a way to also prune the cloud history?