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

SqLite Tutorial

  SqLite - HOME   SqLite - Intro   SqLite - Installation   SqLite - Syntax   SqLite - Data Types   SqLite - Create DB   SqLite - Create Table   SqLite - Select   SqLite - Distinct   SqLite - Where   SqLite - And & Or   SqLite - Order By   SqLite - Insert Into   SqLite - Update   SqLite - Delete   SqLite - Injection   SqLite - Select Top   SqLite - Like   SqLite - Wildcards   SqLite - In   SqLite - Between   SqLite - Aliases   SqLite - Joins   SqLite - Inner Join   SqLite - Left Join   SqLite - Right Join   SqLite - Full Join   SqLite - Union   SqLite - Select Into   SqLite - Insert Into Select   SqLite - Constraints   SqLite - Not Null   SqLite - Unique   SqLite - Primary Key   SqLite - Foreign Key   SqLite - Check   SqLite - Default   SqLite - Create Index   SqLite - Drop   SqLite - Alter   SqLite - Auto Increment   SqLite - Views   SqLite - Dates   SqLite - Null Values   SqLite - Null Functions   SqLite - Data Types   SqLite - DB Data Types

SqLite Functions

  SqLite - Functions   SqLite - Avg()   SqLite - Count()   SqLite - First()   SqLite - Last()   SqLite - Max()   SqLite - Min()   SqLite - Sum()   SqLite - Group By   SqLite - Having   SqLite - Ucase()   SqLite - Lcase()   SqLite - Mid()   SqLite - Len()   SqLite - Round()   SqLite - Now()   SqLite - Format()