SQLite - Installation

Install SQLite3 on Windows

  • Step 1 - Visit   SqLite - official download page. Search for "Precompiled Binaries for Windows" Section.
  • Step 2 - Download the zip file called sqlite-dll-win32-x86-xxxx.zip or sqlite-dll-win64-x64-xxxx.zip depending upon your system configuration.
  • Step 3 - Also download sqlite-tools-win32-x86-xxxx.zip fron tahe same place.
  • Step 4 - Create a folder in your C directory called sqlite. In C:\sqlite unzip both the files which you have downloaded.
  • Step 5 - Now you C:\sqlite folder will contain the following files
    sqldiff.exe
    sqlite3.def 
    sqlite3.dll
    sqlite3.exe
    sqlite3_analyzer.exe
  • Step 6 - Now add C:\sqlite to your envirenment variables.
  • Step 7 - Open Command promt and type sqlite3 there. You will se the following results after executing the command
    C:\sqlite>sqlite3
    SQLite version 3.13.0 2016-05-18 10:57:30
    Enter ".help" for usage hints.
    Connected to a transient in-memory database.
    Use ".open FILENAME" to reopen on a persistent database.
    sqlite>
                                        

Install SQLite3 on Linux

Now a days Most of the Linux distributions , if not all, are being shipped with Sqlite. So before installing Sqlite manually, its not a bad idea to check if the sqlite is installed on your linux system or not.

So open your terminal and type sqlite3 in it. If you the the following result on terminal then sqlite is already present on yout Linux operating system.

$sqlite3
SQLite version 3.13.0 2016-05-18 10:57:30
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite>
                            

If in case sqlite is not installed on your system, the you can also install SQLite from Source on Linux

So open your terminal and type the following commands to install it

$ wget http://www.sqlite.org/2016/sqlite-amalgamation-3130000.zip
$ tar xvfz sqlite-autoconf-3070603.tar.gz
$ cd sqlite-autoconf-3070603
$ ./configure
$ make
$ make install
                            

Install SQLite3 on Mac OS X

Now a days Most of the Mac OS X distributions , if not all, are being shipped with Sqlite. So before installing Sqlite manually, its not a bad idea to check if the sqlite is installed on your Mac OS X system or not.

So open your terminal and type sqlite3 in it. If you the the following result on terminal then sqlite is already present on yout Mac OS X operating system.

$sqlite3
SQLite version 3.13.0 2016-05-18 10:57:30
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite>
                            

If in case sqlite is not installed on your system, the you can also install SQLite from Source on Mac OS X

So open your terminal and type the following commands to install it

$ wget http://www.sqlite.org/2016/sqlite-amalgamation-3130000.zip
$ tar xvfz sqlite-autoconf-3070603.tar.gz
$ cd sqlite-autoconf-3070603
$ ./configure
$ make
$ make install