Sqlite VACUUM is a bug?

Question

SQLite

Kind
Prompt, in a DB records often appear and are deleted, read here that it is necessary to write still the VACUUM command. How to write? if just

vacuum;

, then the error is:

cannot VACUUM from within a transaction:

Answer 1

Faced a similar problem. It only occurred when I ran VACUUM along with other commands, like so:

self.db.execute("DELETE FROM %s" % table_name)
self.db.execute("REINDEX %s" % table_name)
self.db.execute("VACUUM")        
self.db.commit()

I solved the problem by adding a separate commit for the vacuum:

self.db.execute("DELETE FROM %s" % table_name)
self.db.execute("REINDEX %s" % table_name)
self.db.commit()
self.db.execute("VACUUM")        
self.db.commit()