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
Snippet List
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
oneliner to delete SQLite tables
I use this oneliner to delete the matching tables in SQLite. Use carefully!
- sqlite
- drop
- oneliner