[RCU] Purging an sqlite database - RC 1.3.8

Sophie Loewenthal sophie at klunky.co.uk
Wed Nov 7 23:04:07 CET 2018


I noticed a roundcube sqlite dB slowly growing after each login.

in this example the user just logged, ran a search for an email address on Sent folder and logged out. Yet there was an increase in size:

Before login
-rw-r----- 1 www www 21295104 Nov  7 21:47 roundcube.db
After login
-rw-r----- 1 www www 21303296 Nov  7 21:57 roundcube.db

What sort of information could be being added to the dB?  And how could I purge this data, or otherwise reduce the sqlite dB? Perhaps though some regular cleaning?

Roundcube 1.3.8 and sqlite 3.16.2.

Best, Sophie

More information about the users mailing list