DB Browser

DB Browser for SQLite is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite. It is for users and developers who want to create databases, search, and edit data. We will be using it to create and test our SQL before implementing that SQL in our Python applications.

Creating a database¶

The video below demonstrates how to create a new database using DB Browser for SQLite.

Creating a table¶

The video below demonstrates how to create a new table using DB Browser for SQLite.

Creating tables with relationships¶

Manually entering data¶

For most of our work with database we will be entering data using SQL commands. However, there may be times when you want to manually enter data into a table. The video below demonstrates how to do this using DB Browser for SQLite.