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:
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.
- 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-1: Which of the following can you do with the Database Browser for SQLite?
- True
- Try again!
- False
- You will do simple operations in the database manager and more complex operations will be most conveniently done in Python.
Q-2: True or False? It is convenient to do all changes and operations in a database manager.
Before you keep reading...
Making great stuff takes time and $$. If you appreciate the book you are reading now and want to keep quality materials free for other students please consider a donation to Runestone Academy. We ask that you consider a $10 donation, but if you can give more thats great, if $10 is too much for your budget we would be happy with whatever you can afford as a show of support.