[horde] IMP VFS tidy up - can ".horde/imp/compose" be safely removed if old?

[SPICY2 MIGRATION ACCOUNT]

(resend to list as well)
On Wed, 2025-05-14 at 14:06 +0200, Ralf Lang wrote:
> Hi,
> 
> Am 11.05.2025 um 10:16 schrieb SPICY2 MIGRATION ACCOUNT:
> > After I few tests it seems the old ".horde/imp/compose" VFS entries
> > are
> > from IMP sessions that have been terminated without sending an
> > email,
> > as they are cleaned up when the email is sent. So I have backed up
> > the
> > table and run the following to tidy it up....
> > 
> > delete from horde_vfs where vfs_modified <
> > unix_timestamp(date_sub(now(), interval 180 day)) and vfs_path =
> > ".horde/imp/compose";
> > 
> We will need to document garbage collection more thoroughly. Users 
> should not need to run SQL statements.
> 
> That said, your method should work for "SQL" backends. If you happen
> to 
> use the SqlFile driver (metadata in db, files in fs) then it might 
> create consistency problems.
> 

yes, that would be handy, but even simple SQL statements aimed at
HORDE/IMP admin level users (who may have had to grapple with MySQL to
install the system) are better than nothing, plus an overview of what
can be done without breaking things.

I'm only using the SQL backend and have seen no issues with the server
since running the above.. and my SQL backups have dropped down to 10s
of megabytes instead of gigabytes.