Run VACUUM

sql

VACUUM;

Explanation

Can reduce file size after large deletes or schema churn.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Backup and maintenance

Write a fresh copy of the database to a new file.

Open In sheetsqlsame section

Verify the database structure and content consistency.

Open In sheetsqlsame section

Create a backup from inside sqlite3.

Open In sheettextsame section

Execute inserts and DDL from a seed script.

Open In sheetbash1 tag match

Set shell parsing options before import.

Write selected rows to a CSV file.