21.3. Database Browser for SQLite

While this chapter will focus on using Python to work with data in SQLite database files, many operations can be done more conveniently using software called the Database Browser for SQLite which is freely available from:

http://sqlitebrowser.org/

Using the browser you can easily create tables, insert data, edit data, or run simple SQL queries on the data in the database.

In a sense, the database browser is similar to a text editor when working with text files. When you want to do one or very few operations on a text file, you can just open it in a text editor and make the changes you want. When you have many changes that you need to do to a text file, often you will write a simple Python program. You will find the same pattern when working with databases. You will do simple operations in the database manager and more complex operations will be most conveniently done in Python.

Q-1: Which of the following can you do with the Database Browser for SQLite?

• Create a table
• You can create tables
• Insert data
• You can insert data
• Edit data
• You can edit data
• Select data
• You can select data

Q-2: True or False? It is convenient to do all changes and operations in a database manager.

• True
• Try again!
• False
• You will do simple operations in the database manager and more complex operations will be most conveniently done in Python.

You have attempted of activities on this page