sqlite vacuum with django

Question

after insert and delete lots records into sqlite, the size of sqlite db file keeps growing, is there any way to use django vacuum the tables?

some settings that let sqlite auto-vacuum
or manually write own django command to vacuum

Updated:

I use sqlite database browser to execute following SQL:

vacuum [my table];
commit;

it works great, I just want to do it program way

related (for postgresql): https://stackoverflow.com/q/1017463 — djvg, Aug 02 '22 at 16:54

score 6 · Accepted Answer · answered Jul 09 '12 at 03:17

6

you can execute raw sql as follows:

from django.db import connection, transaction
cursor = connection.cursor()

# Data modifying operation - commit required
cursor.execute("vacuum my_table")
transaction.commit_unless_managed()

though, this was kind of interesting http://www.sqlite.org/lang_vacuum.html/pragma.html#pragma_auto_vacuum

maybe we can set the vacumm to be automatic, but it looks like it may worsen fragmentation.

cursor.execute("PRAGMA auto_vacuum=FULL")

http://www.sqlite.org/pragma.html#pragma_auto_vacuum

answered Jul 09 '12 at 03:17

Samy Vilar

10,800
2
39
34

many thanks, although I thought some settings in django models meta-data, but the problem got solved – pinkdawn Jul 09 '12 at 05:15
2

with Django 1.8.3 it needs ```transaction.commit()``` – Stéphane Aug 24 '16 at 09:51

sqlite vacuum with django

1 Answers1