Greg Back

Exploring Sqlite databases

It's often useful to peek around a sqlite database file from the command line, especially those that applications use for storing their own internal data. In this case, I was interested in looking at how Firefox stores a user's browsing history (which happens to be in the file called places.sqlite inside the Firefox profile directory). Anyway, here are some commands you can run:

$ sqlite places.sqlite
sqlite> .help
sqlite> .tables
sqlite> .dbinfo
sqlite> PRAGMA table_info(moz_places)
sqlite> .quit

moz_places is the name of the specific table I was interested in.

links

social