Menu
I cannot find any example on the net of how the SQLite 3 vacuum command is done on a database.
926
The VACUUM command works by copying the contents of the database into a temporary database file and then overwriting the original with the contents of the temporary file. When overwriting the original, a rollback journal or write-ahead log WAL file is used just as it would be for any other database transaction.
Just open a connection and execute the VACUUM command;
conn=sqlite3.connect(SQLITE_FILE) conn.execute("VACUUM") conn.close() If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
