rezhajulio

BACKUP_FILE=backups/`date +%Y%m%d_%H%M`.db
sqlite3 -readonly path/to/your.db ".backup $BACKUP_FILE"
sqlite3 $BACKUP_FILE "vacuum;"
bzip2 -9 $BACKUP_FILE

rezhajulio

Keybase proof

I hereby claim:

• I am rezhajulio on github.
• I am kimiamania (https://keybase.io/kimiamania) on keybase.
• I have a public key ASA__uYzq9ZY4Qbdx6J4DOdcZVCQboKSv7QhYVkxoE-nlgo

To claim this, I am signing this object:

rezhajulio

# Get documents, where writters are Joel Coen and Ethan Coen.
db.movieDetails.find({ "writters" : ["Joel Coen", "Ethan Coen"] }).count()

# Get documents, where Jeff Bridges is playing leading role.
> db.movieDetails.find({ "actors.0": "Jeff Bridges" }).pretty()