SQLite Installation

SQLite is known for its exceptional zero-configuration features, which means no complex settings or management are required. This chapter will guide you through the process of setting up SQLite on Windows, Linux, and macosx.

Install SQLite on Windows

• Step 1− Go toSQLite Download Pageand then download the pre-compiled binary files from the Windows section.

• Step 2 − Download sqlite-shell-win32-*.zip and sqlite-dll-win32-*.zip compressed file.

• Step 3 − Create a folder C:\>sqlite and unzip the two compressed files in the folder, which will provide you with sqlite3.def, sqlite3.dll and sqlite3.exe file.

• Step 4 − Add C:\>sqlite to the PATH environment variable, and finally go to the command prompt and issue sqlite3The command will 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>

Install SQLite on Linux

Today, almost all versions of Linux OS provide SQLite. Therefore, you just need to issue the following command to check if SQLite is already installed on your computer.

$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 do not see the above results, it indicates that SQLite is not installed on your Linux machine. The following are the steps to install SQLite:-

• Step 1− Go toSQLite Download Page,Then download sqlite from the source code section-autoconf-*.tar.gz.

• Step 2 − Run the following commands −

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

The above commands end the installation of SQLite on a Linux machine. You can verify it according to the instructions above.

Install SQLite on Mac OS X

Although the latest version of Mac OS X is pre-installed with SQLite, if you do not have an available installation, please follow the steps below-

• Step 1− Go toSQLite Download PageThen download sqlite from the source code section-autoconf-*.tar.gz.

• Step 2 − Run the following commands −

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

The process will end with the SQLite installation on a Mac OS X computer. You can verify this by issuing 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, you have the SQLite command prompt where you can enter SQLite commands for practice.