Analyzing the database
In most modern Linux distributions and macOS, SQLite is already installed, and therefore you can run the sqlite3
command-line utility.
In Windows, if you want to work with the sqlite3.exe
command-line utility, you have to download the bundle of command-line tools for managing SQLite database files from the downloads section of the SQLite webpage at http://www.sqlite.org/download.html. For example, the ZIP file that includes the command-line tools for version 3.20.1 is sqlite-tools-win32-x8 6-3200100.zip
. The name for the file changes with the SQLite version. You just need to make sure that you download the bundle of command-line tools and not the ZIP file that provides the SQLite DLLs. After you unzip the file, you can include the folder that includes the command-line tools in the PATH environment variable, or you can access the sqlite3.exe
command-line utility by specifying the full path to it.
Run the following command to list the generated tables. The first argument...