Cleaning the sqlite to decrease its size

Whateverr · February 8, 2020

I have read this thread https://forums.zotero.org/discussion/43336/database-clean-up-sql-vacuum where a user recomment the VACUUM command from sqlite3 to decrease the size of the sqlite.

Is it recommended to do it or is there another (more official) way of decreasing the zotero db size?

dstillman · February 8, 2020

It's not something we recommend that people do manually, but there's no harm. Currently, if you just check your database integrity from the Advanced → Files and Folders pane of the Zotero preferences, it will run a vacuum as well.

Whateverr · February 11, 2020

Thanks a lot for this!