In this tutorial, you will learn the available GUI tools for SQLite.

The basic SQLite software comes with cmd (command prompt) mode, but handling large data is very difficult in cmd mode. The alternative solution is GUI tool.

We have many number of GUI(Graphical User Interface) tools to work with SQLite. You can choose your right GUI tool from the below URL.

Below mentioned are the three main vendors which offer free GUI tool to work with SQLite. You can download them from their website.

http://sqlitestudio.pl/?act=download

http://sqliteman.yarpen.cz/

http://sourceforge.net/projects/sqlitebrowser/

Here am going to demonstrate the Sqliteman tool.

Sqliteman is a portable GUI tool which does not require installation.

Download Sqliteman from its official website http://sqliteman.yarpen.cz/

Once the download is complete, extract the file and go to sqliteman-1.2.2 (here version is 1.2.2) folder. It looks like below

 

gui-tool-1

Click the Sqliteman application icon. It will open a new window

 

gui-tool-2

 

If you want to create new database, click file->new and give a name and click save button

 

gui-tool-3

 

Once you click the save button, the window will appear as mentioned below

 

gui-tool-4