import sqlite3
import os

try:
    os.remove('test.db')
except:
    pass

conn = sqlite3.connect('test.db')

# create table
sql = ('CREATE TABLE test ( '
       'id INTEGER PRIMARY KEY AUTOINCREMENT, '
       'name TEXT, '
       'address TEXT);'
       )
conn.execute(sql)

# selcet
sql = 'SELECT * FROM test'
conn.execute(sql).fetchall()

# VACUUM
conn.execute('begin')
conn.execute('VACUUM')

# close
conn.close()