Skip to content

Instantly share code, notes, and snippets.

@tknr

tknr/optimize_sqlite_db.sh

Created March 21, 2019 16:21
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tknr/a756ac0573ff51b1196e3a54836687db to your computer and use it in GitHub Desktop.
Save tknr/a756ac0573ff51b1196e3a54836687db to your computer and use it in GitHub Desktop.
Download ZIP
optimize sqlite db files
Raw
optimize_sqlite_db.sh
## http://d-goo.hatenablog.com/entry/2013/07/30/124148
for db in `find ~/ -name *.db`;do echo ${db};sqlite3 ${db} vacuum; sqlite3 ${db} reindex;done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment