Latest web development tutorials

SQLite installation

An important feature is the zero-configuration SQLite, which means that no complex installation or management. This chapter will cover Windows, Linux installation settings and Mac OS X on.

Install SQLite on Windows

  • Visit the SQLite download page , download the precompiled binaries from the Windows area.

  • You need to downloadsqlite-shell-win32 -. * Zip and sqlite-dll-win32 -. *Zip archive.

  • Create a folder C: \ sqlite, compression and decompression of the above two files in this folder, the resulting sqlite3.def, sqlite3.dll and sqlite3.exe files.

  • Add C: \ sqlite to the PATH environment variable, and finally at the command prompt, use thesqlite3 command, 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

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

$ 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 means not installed SQLite on Linux machines. So, let's install SQLite in accordance with the following steps:

  • Visit the SQLite download page , download the source code fromsqlite-autoconf area -. * Tar.gz.

  • Proceed as follows: 

$ Tar xvfz sqlite-autoconf-3071502.tar.gz
$ Cd sqlite-autoconf-3071502
$. / Configure --prefix = / usr / local
$ Make
$ Make install

The above steps will install SQLite on a Linux machine, you can verify in accordance with the above explanation.

Install SQLite on a Mac OS X

The latest version of Mac OS X pre-installed SQLite, but if you do not have available, simply follow the following steps:

  • Visit the SQLite download page , download the source code fromsqlite-autoconf area -. * Tar.gz.

  • Proceed as follows: 

$ Tar xvfz sqlite-autoconf-3071502.tar.gz
$ Cd sqlite-autoconf-3071502
$. / Configure --prefix = / usr / local
$ Make
$ Make install

The above steps will install SQLite on a Mac OS X machine, you can verify with 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, in the SQLite command prompt, use the SQLite command to do the exercises.