I am using SQLiteManager. I'd a 280KB database that bloated to in excess of 12MB in only eventually. I wasn't doing anything atypical. I still have only about 4-6 light leads to the whole database.
After I open the database file having a text editor, I see pages upon pages of single quotes (').
Also, SQLiteManager inserts a large number of single quotes into the TinyText characteristics which i have every occasionally. This really is visible on SQLiteManager's Web UI.
Any ideas regarding what's happening?
Whatever SQLiteManager does, can it is run VACUUM? In the event that frees the area, after that you can get it run periodically check this out link to learn more:
Also, you are able to set auto_vacuum to FULL: