You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Jeffrey Paul
4031bbf751
|
7 years ago | |
|---|---|---|
| sqlite2json | 7 years ago | |
| .gitignore | 9 years ago | |
| LICENSE | 9 years ago | |
| README.md | 7 years ago | |
| setup.py | 7 years ago | |
README.md
sqlite2json
This script dumps all* the tables in an sqlite database as json.
Usage
sqlite2json sqlitefile.db [--exclude=TABLE]
To dump the sqlite file where iMessages are stored:
sqlite2json ~/Library/Messages/chat.db
Here is a more useful version of the above example:
sqlite2json ~/Library/Messages/chat.db | jq -r .message[].text | grep -i loan
*The script doesn't dump the contents of of the sqlite_master table
Authors
-
John Gerlock
<john@pikkey.com> -
Jeffrey Paul
<sneak@sneak.berlin>