[SQLite]--SQLite installation process on Windows, Linux and Mac OS x.

One: Install SQLite on Windows

1, download

Please visit the SQLite download page http://www.sqlite.org/download.html to download the precompiled binaries from the Windows area. Need to download Sqlite-shell-win32-*.zip and Sqlite-dll-win32-*.zip compressed files, Download the Sqlite-dll-win32-x86-3080600.zip and Sqlite-shell-win32-x86-3080600.zip installation packages here. The 2 installation packages are as follows:

Http://www.sqlite.org/2014/sqlite-shell-win32-x86-3080600.zip

Http://www.sqlite.org/2014/sqlite-dll-win32-x86-3080600.zip

2, installation

Create the folder C:\>sqlite, and in this folder to extract the above two compressed files, you will get Sqlite3.def, Sqlite3.dll and Sqlite3.exe files. As shown below:

3, SET Environment variables:

Win7 System below:

Lower left corner, select the Start menu, right-click on the right computer option, select the Properties menu, select Advanced system Settings options, select Advanced , and then select environment Variables , in the system variables option inside the path bar at the end of the face value of the Add C:\sqlite, click OK button to save exit, as shown in:


4, Operation demonstration verification

Once added, use the Sqlite3 command in the Cmd.exe command line as follows:

C:\users\administrator>sqlite3 Ti

SQLite version 3.8.6 2014-08-15 11:46:33

Enter '. Help ' for usage hints.

sqlite> CREATE TABLE t1 (id int);

sqlite> INSERT into T1 select 1;

Sqlite>. Headers on

sqlite>. Mode columns

Sqlite> select * from T1;

Id

----------

1

Sqlite>

Sqlite>

Sqlite>. Exit

C:\users\administrator>, as shown:

Second: Install SQLite on Linux

1. Verify that you have your own version of SQLite
Today, almost all versions of the Linux operating system are included with SQLite. So, just use the following command to check if SQLite is already installed on your machine.

[Email protected] sqlite-autoconf-3080600]# sqlite3

SQLite version 3.6.20

Enter '. Help ' for instructions

Enter SQL statements terminated with a ";"

Sqlite>
Already installed, but the SQLite version is not up to date.

2, to install the latest 3.8.6 version

is: http://www.sqlite.org/2014/sqlite-autoconf-3080600.tar.gz

[Email protected] ~]# wget http://www.sqlite.org/2014/sqlite-autoconf-3080600.tar.gz

[Email protected] ~]#

Start installation

[Email protected] ~]# TAR-XVF sqlite-autoconf-3080600.tar.gz

[Email protected] ~]# CD sqlite-autoconf-3080600

[Email protected] sqlite-autoconf-3080600]#/configure--prefix=/usr/local

[[email protected] sqlite-autoconf-3080600]# make

[[email protected] sqlite-autoconf-3080600]# make install

Complete the installation to see if the latest version has been updated:

[Email protected] sqlite-autoconf-3080600]# sqlite3

SQLite version 3.6.20

Enter '. Help ' for instructions

Enter SQL statements terminated with a ";"

Sqlite>. Exit

[Email protected] sqlite-autoconf-3080600]#

Manually add Sqlite3 update to the latest version

[Email protected] sqlite-autoconf-3080600]# cp/usr/bin/sqlite3/usr/bin/sqlite3.bak.3.6.2

[email protected] sqlite-autoconf-3080600]# CP Sqlite3/usr/bin/sqlite3

Cp:overwrite '/usr/bin/sqlite3 '? Y

[Email protected] sqlite-autoconf-3080600]# sqlite3 ti

SQLite version 3.8.6 2014-08-15 11:46:33

Enter '. Help ' for usage hints.

Sqlite>

Sqlite>. Table

Sqlite>

Ok,linux above now default is already the latest 3.8.6 version of SQLite.

Three: Install SQLite on Mac OS X

PS: No more Mac OS x installed, the following is Baidu out, you can learn from it.

1, download
The latest version of Mac OS X will pre-install SQLite, but if no installation is available, simply follow the steps below:

To install the latest version of 3.8.6, and the Linux Sqlite3 installation version is the same.

The software address is: http://www.sqlite.org/2014/sqlite-autoconf-3080600.tar.gz

Start Download Installation

$ wget http://www.sqlite.org/2014/sqlite-autoconf-3080600.tar.gz

2, installation

$tar XVFZ sqlite-autoconf-3080600.tar.gz

$CD sqlite-autoconf-3080600

$./configure--prefix=/usr/local

$make

$make Install

3, Login SQLite authentication

The above steps will install SQLite on your Mac OS X machine, which you can verify with the following commands:

$sqlite 3

SQLite version 3.8.6 2014-08-11 11:46:33

Enter '. Help ' for usage hints.

Sqlite>

You can then perform the Sqlite3 operation at the Sqlite3 command prompt.

[SQLite]--SQLite installation process on Windows, Linux and Mac OS x.