1.3. SQLite installation

1.3.1. Install SQLite on Windows ¶

• Please visit SQLite 下载页面 To download precompiled binaries from the Windows area

• You need to download sqlite-tools-win32- .zip 和 sqlite-dll-win32- .zip compressed file.

• Create the folder C:sqlite, and extract the above two compressed files under this folder, and you will get sqlite3.def, sqlite3.dll, and sqlite3.exe files.

• Add C:sqlite to the PATH environment variable, and finally, at the command prompt, use the sqlite3 command to display the following results.

C:\>sqlite3
SQLite version 3.7.15.2 2013-01-09 11:53:05
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite>

1.3.2. Install SQLite on Linux ¶

Currently, almost all versions of the Linux operating system come with SQLite. So, just use the following command to check if SQLite is installed on your machine.

$ sqlite3
SQLite version 3.7.15.2 2013-01-09 11:53:05
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite>

If you don’t see the above results, it means that SQLite is not installed on the Linux machine. So, let’s install SQLite by following these steps:

• Please visit SQLite 下载页面 Download from the source code area sqlite-autoconf-*.tar.gz .

• The steps are as follows:

$ tar xvzf sqlite-autoconf-3071502.tar.gz
$ cd sqlite-autoconf-3071502
$ ./configure --prefix=/usr/local
$ make
$ make install

The above steps will install SQLite on the Linux machine, which you can verify as explained above.

1.3.3. Install SQLite on Mac OS X ¶

The latest version of Mac OS X pre-installs SQLite, but if no installation is available, just follow these steps:

• Please visit SQLite 下载页面 Download from the source code area sqlite-autoconf-*.tar.gz .

• The steps are as follows:

$ tar xvzf sqlite-autoconf-3071502.tar.gz
$ cd sqlite-autoconf-3071502
$ ./configure --prefix=/usr/local
$ make
$ make install

The above steps will install SQLite on the Mac OS X machine, which you can verify using the following command:

$ sqlite3
SQLite version 3.7.15.2 2013-01-09 11:53:05
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite>

Finally, at the SQLite command prompt, use the SQLite command to do the exercise.