SQLite DB Browser Database viewer graphic

This viewer is called: SQLite Database Browser 2.0

This viewer can create a new SQLite file database, you can create table indexes, write SQL statements, edit table data

However, the SQLite database engine version supported by this viewer is a bit lower, so how do you use SQLite DB Browser 2.0 first?

Main interface

You can drag the SQLite db file into the software without clicking on the "Open" button

New Database

Since the new database, the software is the type of save all files, the new finished will find that the file has no suffix name, this time you can first close the database

Renaming a database file, such as a new database, with a file name of 123, can be renamed to 123.db

If you open with EditPlus, you will see that the header of the file has SQLite format 3

You can see the path to the database file in the title bar of the software

Writing and executing SQL statements

browsing data and editing table data

After modifying the table data, remember to click the "Apply Changes" button

Modify Table Structure

Renaming table names, adding fields, modifying fields, deleting fields

Modify the table structure, index, create a new table after the click on the Save button, otherwise the modification is not valid

Seems to introduce SQLite Database Browser 2.0 This tool is a little more space.