SQLite Installation

  Total Views : 51
  Comments : 0
 
  Keywords : Stepwise sqlite Installation process, How to Install sqlite on windows, sqlite installation process guide, Dowload and install sqlite on windows

Here we will learn step by step sqlite installation on windows process in detailed manner with screen shots.

SQLite Installation

To install SQLite in our system we need to download required executable file from SQLite website based on our OS platform like Windows, Linux, etc. To download SQLite executable file, use this url SQLite Download

 

Once open the URL we have different options available based on OS platform like Windows, Linux, Mac, etc. From here you can download the suitable files from available options based on your system OS and configuration (32 bit or 64 Bit).

 

Here we are going to use SQLite on windows OS platform for that we need to download command-line shell program files like as shown below

 

Download and install sqlite on windows

 

The SQLite command-line tool will contain following SQLite products

 

SQLite core: The SQLite core contains the actual database engine and public API.

 

SQLite3 command-line tool: The sqlite3 application is a command-line tool that is built on top of the SQLite core.

 

Tcl extension:  This library is essentially a copy of the SQLite core with the Tcl bindings tacked on.

 

SQLite analyzer tool: The SQLite analyzer is used to analyze database files.

Install SQLite

Once we download the files we will install SQLite on Windows OS system by using following steps.

 

  • Create a new folder “sqlite” in C or D or E drive based on your requirement like C:\sqlite.
  • Once we create new folder, extract the downloaded files content to new folder (C:\sqlite), now you will be able to see sqlite3.exe in C:\sqlite folder. 

We can start using sqlite directly by opening sqlite3.exe from folder or from command line window. In case if you want to open from command line window follow below steps.

Run SQLite using Command Line Window 

Open command line window and navigate to C:\sqlite folder like as shown below

 

Open command prompt and navigate to sqlite installation folder

 

Once you navigate to C:\sqlite folder enter sqlite3 and click on enter button in case if sqlite3 file exists then it will connect to in-memory database like as shown below.

 

Open sqlite file from command prompt

 

If you want to test further type .help command from sqlite> prompt to see all available commands in sqlite3 like as shown below.

 

ios sqlite help command result

 

This way we can install and run sqlite directly by using sqlite command-line tool or from command prompt. In case if you want visual interface tool to work with sqlite we have tool called DB SQLite Browser. DB Browser for SQLite is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite.

 

DB Browser SQLite Visual Interface Tool

 
 

NEXT

SQLite Syntax  
 

 Comments (0)

Be the first to give your valuable feedback

Leave a comment

  • Default Tutlane User