sqlite2json/README.md

26 lines
531 B
Markdown
Raw Permalink Normal View History

# sqlite2json
2014-03-04 19:59:13 +00:00
This script dumps all\* the tables in an sqlite database as json.
2014-03-04 19:59:13 +00:00
## 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>`