Parsing SQLite databases with DB Browser for SQLite
DB Browser for SQLite is a free tool that can be used for SQLite database analysis. It has great functionalities for such data analysis.
Getting ready
Open the DB Browser for the SQLite program website in your browser. Select the version of the program that is suitable for your operating system and download it. Double-click the icon of the downloaded file and follow the instructions to install it.
How to do it…
Double-click the icon of the DB Browser for the SQLite program; it will start the program. You can create your SQLite database or analyze the one that already exists. In this chapter, we will describe how to analyze the contents of the mmssms.db
file.
Click Open Database
. Select the file, which you will examine. Click OK
:
Toolbar of the DB Browser for SQLite
The examined file will be uploaded in the program. The main window of the program has four tabs:
Database Structure
: Displays the structure of the database.Browse Data
: Displays the...