Go to file

Jeffrey Paul 4031bbf751 Merge branch 'master' of github.com:john-g-g/sqlite2json Signed-off-by: Jeffrey Paul <jp@eeqj.com>		2016-05-07 04:08:09 +02:00
sqlite2json	actually fixes #4 now	2016-05-07 04:05:52 +02:00
.gitignore	Init	2014-02-14 14:37:21 -05:00
LICENSE	Initial commit	2014-02-14 11:34:04 -08:00
README.md	version bump to 1.0.1, added me to authors	2016-05-07 04:07:21 +02:00
setup.py	version bump to 1.0.1, added me to authors	2016-05-07 04:07:21 +02:00

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