I was attempting to view the contents of what I thought was a SQLite3 database file so I needed a GUI of some sort to do so. Anyhow first I decided to install SQLite. Once I did this and created a test database to make sure to SQLite GUI was working I finally decided the file I was trying to open was not a SQLite3 database file.

Install/Run SQLite:

  1. Download SQLite: First visit this page to download SQLite. The Windows precompiled binaries are located near the bottom of the page.
  2. Unpack SQLite: In my case the latest version of SQLite was 3.6.14 so the downloaded file was named sqlite-3_6_14.zip. Right click this file and choose to uncompress in the same directory. This will produce a sqlite3.exe file.
  3. Install SQLite: Now double click on the sqlite.exe file to install SQLite.
  4. Test SQLite:To test SQLite open up a command prompt window and type “sqlite3″. To get some help with SQLite type “.help” and to close sqlite3 type “.quit” .

Create a Test SQLite Database:

  1. Create SQLite Test Database: Issue the below command from a Windows Command Prompt window from the folder where you extracted the sqlite3.exe to create a test SQLite database.
    sqlite3 sqlite.db
    

    The below example image shows the command to issue from a Windows Command Prompt to launch a sqlite3 shell while generating a sqlite3 database at the same time.

    Launch SQLite3 Shell From Windows Command Prompt:

    Run SQLite3 Shell Via Windows Command Prompt

    Remember to exit out of the sqlite3 command prompt type the below.

    .quit
    
  2. Create a SQLite Table: Issue the below command to create a table in the test database.
    sqlite3 sqlite.db "create table tb1 (tb1key INTEGER PRIMARY KEY,data TEXT,num double,timeEnter DATE);"
    
  3. Add Data Into Test Database: Now issue each of the three commands below to insert data into the test database table we created.
    sqlite3 sqlite.db "insert into tb1 (data,num) values ('Test data',9);"
    sqlite3 sqlite.db "insert into tb1 (data,num) values ('More test data',8);"
    sqlite3 sqlite.db "insert into tb1 (data,num) values ('Third set of data',7);"
    
  4. View Test SQLite Data:Now list all of the rows in the test table located in the test sqlite database.
    sqlite3 sqlite.db "select * from tb1";
    

Install SQLite GUI for Windows:

  1. Download SQLite GUI SQTView:Visit download.com to download the latest version of SQTView located here.
  2. Install SQTView:The downloaded file will be named inSQTV.exe. Double click this file to install SQTView.
  3. Test SQTView:Once installed locate the application in the Start Menu under Program Files in the APSoft folder. Now locate the testdb.db file you created with the sqlite3 CLI commands. Open this file to verify everything is functioning properly. You will not be able to edit the database with SQTView. This application is only for viewing SQLite2 and SQLite3 database files.

The above will allow you to create a sqlite3 database and view the database with the SQTView GUI for Windows.


List Price: $59.99 USD
New From: $19.98 USD In Stock
Used from: $9.00 USD In Stock

Using SQLite (Paperback)

By (author): Jay A. Kreibich


List Price: $49.99 USD
New From: $33.82 USD In Stock
Used from: $28.44 USD In Stock

DeliciousStumbleUponDiggTwitterFacebookRedditLinkedInEmail
Tags: , , , , , , , ,
21 Responses to “SQLite3 GUI For Windows XP, Install SQLite On Windows”
  1. Marco says:

    Hi,

    Just wondering if you can help me out. I’ve downloaded SQLite3.exe (the latest version as of Feb 5/10) into a directory but unfortunately no database/tables are being saved when using the “Create” function. Everything works when in memory but that’s it… nothing is saved to my hard drive.

    For example, I can do the following without an issue:
    create table ztest (name string);
    insert into ztest values (“joe”);
    insert into ztest values (“mike”);
    select * from ztest;

    doing all this I will get the following result:
    joe
    mike

    Therefore I know SQLite3 is working, I just can’t figure out why the database/tables are not being saved on my hard drive so that I can call up the database/tables again… any suggestions?

    Thanks!

    [Reply]

    alex Reply:

    Hello Marco,

    What specific operating system are you using? Do you receive any errors? Have you enabled logging and if so are there any clues in the log files?

    My first though would be that it is some sort of permissions issue but I am not really sure without more information.

    Thanks.
    alex

    [Reply]

  2. Marco says:

    Hi Alex,

    Thanks for getting back to me. Actually, things seem to be working now but don’t ask me how, have no idea! I thought it was permission issues as well but believe that isn’t the case. I guess I was just doing something wrong. Anyway, things are working so all is good for now.

    One more question: Any idea on whether it’s possible to get access to the database via Excel? Want to use Excel as a front end and to work with some of the data.

    Many thanks!
    Marco

    [Reply]

    alex Reply:

    Hello Marco,

    Since accessing SQLite3 via Excel is off topic I would suggest asking this question on QD Engage which is a section of Question Defense that allows any user to ask a question and any other user to answer that question. Any technical questions that you have on any subject can be posted there and it allows a much larger group of users to answer the questions in a more timely manner.

    If you already found the answer we would love to hear what it was.

    Thanks.
    alex

    [Reply]

  3. Vadi says:

    Alex, I have followed the “Install SQLite” instructions, I am ok till Step #3 which is installing SQLite. When I am trying to follow step #4 which is I have opened the command prompt and keyed in the command “sqlite3″, below is the response I get.

    ‘”sqlite3″‘ is not recognized as internal or external command, operable program or batch file.

    Same is true when I key in .help command. Do I need to do something more than following step #1, 2 and 3. Please guide me to resolve this problem. Thanks in advance…

    [Reply]

    Vadi Reply:

    Alex, I am getting the below mentioned error now:

    Error: near “sqlite3″: syntax error

    [Reply]

  4. Vadi says:

    Alex, got it working thanks… I was trying the 4th step from some other directory in DOS. I have to change my directory to the one where SQLite exe was placed. It works fine now…

    [Reply]

    alex Reply:

    Hello Vadi,

    Great to hear. Thanks for taking the time to come back to the site and note the resolution so if others run into the same issue they will be able to read the comments for your tip.

    Thanks!
    alex

    [Reply]

  5. Bunta says:

    Hi,

    I downloaded sqlite-shell-win32-x86-3071000 and sqlite-dll-win32-x86-3071000 from the mentioned link. The exe is present under the sqlite-shell-win32-x86-3071000 folder. On double-clicking the exe, only a command prompt opened, no installation happened. Please inform how to install it.

    Regards,
    Bunta

    [Reply]

    alex Reply:

    Hello Bunta,

    The file you downloaded in simply the SQLite3 command shell. I have updated the first couple steps in an attempt to make the article more clear. If you look further down in the article there is also instructions for a SQLite GUI for Windows. Hope that helps.

    Thanks.
    alex

    [Reply]

  6. Lawrence says:

    Hi all,I have just learnt about SQLite3. I don’t know much about but I have one major question. Can you have both MySQL and SQLite3 in the same computer?

    Thanks!

    [Reply]

    alex Reply:

    Hello Lawrence,

    Absolutely no reason why you cannot have both SQLite3 and MySQL running on the same computer.

    Hope that helps.

    Thanks.
    alex

    [Reply]

    Lawrence Reply:

    Thanks a lot Alex. That really helps. Does that mean there will not be a collision in port assignment. As in MySQL will still be in port number 3306?

    [Reply]

    alex Reply:

    Hello Lawrence,

    Correct. Also you can easily change the MySQL default port using the my.cnf configuration file which is located in the /etc/ directory by default on many Linux distros.

    Thanks.
    alex

    [Reply]

  7. Anubhab says:

    Hi Alex,
    I have successfully installed (Windows 7) sqlite3 and it’s working. Now my problem is, whenever I write something like “sqlite 3 test.db”, it is waiting for more inputs (I am a newcomer here, so I do not know the terminologies yet).

    For example,
    sqlite> sqlite3 test.db
    …>
    …>

    What I am doing wrong? Thank you in advance.

    [Reply]

    Anubhab Reply:

    OK, now I’ve found that I was missing a ‘;’, but still there is a problem.
    I can not create a database.

    Whenever I try-

    sqlite3 sqlite.db “create table tb1 (tb1key INTEGER PRIMARY KEY,data TEXT,num double,timeEnter DATE);”

    The following lines are shown:

    Error: near “sqlite3″ : syntax error

    Please help me.

    [Reply]

    alex Reply:

    Hello Anubhab,

    Look at the comment posted by John Nash below as I believe it will assist you in resolving your problem. If not respond to this comment with whatever details you have and I will see if we can help out.

    Thanks.
    alex

    [Reply]

  8. John Nash says:

    You should run the sqlite3 from DOS command prompt, and not from sqlite3 command prompt.
    Example:
    c:\Users\test> sqlite3 sqlite.db
    SQLite version 3.7.14.1 2012-10-04 19:37:12
    Enter “.help” for instructions
    Enter SQL statements terminated with a “;”
    sqlite>

    and at this prompt you can give sql queries:
    sqlite> create table tb1 (tb1key INTEGER PRIMARY KEY,data TEXT,num double,timeEnter DATE);
    sqlite> .tables
    tb1

    [Reply]

    alex Reply:

    Hello John,

    Thank you for providing the above information to Anubhab as I am sure others will find it useful as well.

    Thanks.
    alex

    [Reply]

  9. monti says:

    When I am opening again sqlite3 previously stored data is gone(tables). everything is fine regarding permission.Why is that not being stored in hard drive?

    [Reply]

    alex Reply:

    Hello monti,

    There are so many factors that could cause such a thing its hard to answer without having all of the details. Even with the details there are still tons of outside factors that could cause data loss. Regardless of any of those items I would suggest making sure you backup SQLite3 data ion a regular basis, you update SQLite3 to the latest version, and that you update the base operating system to the latest version with the latest patches to make sure SQLite3 is interacting with the latest software.

    Unfortunately there will likely not be a ton of info that others could provide without knowing operating system, operating system version, environment information, etc. but backing up data from any database on a regular basis is always recommended.

    Thanks.
    alex

    [Reply]

  10.  
Leave a Reply

*Type the letter/number combination in the abvoe field before clicking submit.

*