Sessionbuddy DB compression

[Oleg Ivanets]

Hi, Had over 300 backups. Cleared most of them but datebase remains to be over 300mb. How can i compress it, or clear? Any tool? of commandline command?   \AppData\Local\Vivaldi\User Data\Default\databases\chrome-extension_cchdkldpeehfnlckegjlijngjihdpllg_0\2

[Davor Dundovic]

You can do it from command line.

For instance:

sqlite3 31 "delete from PreviousSessions where creationDateTime <= date('now', '-30 day'
);VACUUM;"

Deletes all previous sessions older than 30 days from Session Buddy database file "31" and the command "VACUUM" then shrinks database file itself.

Regards,

Dundo

On 16. 08. 2023. 18:46, Oleg Ivanets wrote:

Hi, Had over 300 backups. Cleared most of them but datebase remains to be over 300mb. How can i compress it, or clear? Any tool? of commandline command?   \AppData\Local\Vivaldi\User Data\Default\databases\chrome-extension_cchdkldpeehfnlckegjlijngjihdpllg_0\2

--
You received this message because you are subscribed to the Google Groups "Session Buddy Discussion" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sessionbuddy-dis...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sessionbuddy-discuss/2ee076bf-2b59-4a77-a577-b29dbad0e127n%40googlegroups.com.