SQLite Setup on Windows



If you are interested in small scale project with database which require small space and lightweight then SQLite is good and easy to setup too.
Go to https://www.sqlite.org/ for more information and detailed explanation.
Now we will start to setup SQLite step by step.

Step 1   Go to https://www.sqlite.org/download.html site for download required stuff.
Step 2   There are options to select. So go for your option based on requirement.
                 We will use Precompiled Binaries for Windows for windows setup

Step 3   download two zip files 
                sqlite-dll-win32-x86-3200100.zip and sqlite-tools-win32-x86-3200100.zip from this site.
               So you are done almost.
Step 4   Create one folder in C:\sqlite and unzip your downloaded files in that.
Step 5   Add path in environment variable (Path- c:\sqlite) properly.
                you need not require "setting path" steps right ;)
Step 6  Now check SQLite setup is done or not, by opening cmd prompt.
               Use below command
             C:\sqlite>sqlite3
     SQLite version 3.20.1 2017-08-24 16:21:36             
     Enter ".help" for usage hints.                        
     Connected to a transient in-memory database.          
     Use ".open FILENAME" to reopen on a persistent database. 
            Or 
            By double clicking on sqlite3.exe from extracted folder.

Now you are free to use SQLite.

Comments

Popular posts from this blog

Setting up/Install JDK in Ubuntu/Linux

Set JAVA_HOME / PATH variables In Linux OS