djangosnippets: Tag "sqlite"

grep and delete sqlite tables

This is a slight improvment of a previous snippet of mine: http://www.djangosnippets.org/snippets/1776/ It is an interactive shell script that greps and deletes sqlite tables USAGE: ./pdrop.sh myquery mydbfile

db
sqlite
drop

Sun 11 Jul 2010 Read More

oneliner to delete SQLite tables

I use this oneliner to delete the matching tables in SQLite. Use carefully!

sqlite
drop
oneliner

Sun 11 Jul 2010 Read More

SQLite database vacuum script

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

db
utility
sqlite

Sun 11 Jul 2010 Read More

Tag "sqlite"

Snippet List