YouTip

# SQLite Installation An important feature of SQLite is that it is zero-configuration, meaning no complex installation or administration is required. This chapter explains the installation setup on Windows, Linux, and Mac OS X. ## Installing SQLite on Windows * Please visit the (http://www.sqlite.org/download.html) and download the precompiled binaries from the Windows section. * You need to download the **sqlite-tools-win32-*.zip** and **sqlite-dll-win32-*.zip** archives. * Create a folder C:sqlite and extract the two zip files into this folder. You will get the sqlite3.def, sqlite3.dll, and sqlite3.exe files. * Add C:sqlite to the PATH environment variable. Finally, at the command prompt, use the **sqlite3** command, and you will see the following result. C:>sqlite3 SQLite version 3.7.15.2 2013-01-09 11:53:05Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> ## Installing SQLite on Linux Currently, almost all versions of Linux come with SQLite. So, just use the following command to check if SQLite is already installed on your machine. $ sqlite3 SQLite version 3.7.15.2 2013-01-09 11:53:05Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> If you do not see the above result, it means SQLite is not installed on your Linux machine. Therefore, let's install SQLite by following the steps below: * Please visit the (http://www.sqlite.org/download.html) and download **sqlite-autoconf-*.tar.gz** from the source code section. * 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 your Linux machine. You can verify it as described above. ## Installing SQLite on Mac OS X The latest versions of Mac OS X come with SQLite pre-installed. However, if it is not available, simply follow these steps: * Please visit the (http://www.sqlite.org/download.html) and download **sqlite-autoconf-*.tar.gz** from the source code section. * 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 your Mac OS X machine. You can verify it using the following command: $ sqlite3 SQLite version 3.7.15.2 2013-01-09 11:53:05Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> Finally, at the SQLite command prompt, practice using SQLite commands.