Login

SQLite database vacuum script

Author:
pbx
Posted:
May 13, 2007
Language:
Python
Version:
.96
Score:
4 (after 4 ratings)

This script can be run periodically (e.g. as a nightly cronjob) to keep a SQLite database with high churn from growing unnecessarily large.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
from django.conf import settings

def vacuum_db():
    from django.db import connection
    cursor = connection.cursor()
    cursor.execute("VACUUM")
    connection.close()

if __name__ == "__main__":
    print "Vacuuming database..."
    before = os.stat(settings.DATABASE_NAME).st_size
    print "Size before: %s bytes" % before
    vacuum_db()
    after = os.stat(settings.DATABASE_NAME).st_size
    print "Size after: %s bytes" % after
    print "Reclaimed: %s bytes" % (before - after)

More like this

  1. Form field with fixed value by roam 1 week, 4 days ago
  2. New Snippet! by Antoliny0919 2 weeks, 3 days ago
  3. Add Toggle Switch Widget to Django Forms by OgliariNatan 3 months, 1 week ago
  4. get_object_or_none by azwdevops 6 months, 4 weeks ago
  5. Mask sensitive data from logger by agusmakmun 8 months, 3 weeks ago

Comments

dariosky (on January 21, 2011):

An update to make it work with multiple connection in Django 1.2:

from django.db import transaction, connections

def vacuum_db(using='default'):
    cursor = connections[using].cursor()
    cursor.execute("VACUUM")
    transaction.set_dirty(using=using)

#

Please login first before commenting.