using databases and sql column attribute table relation row tuple figure relational databases database browser for sqlite while this will focus on using python to work with data in sqlite database filesmany operations can be done more conveniently using software called the database browser for sqlite which is freely available fromusing the browser you can easily create tablesinsert dataedit dataor run simple sql queries on the data in the database in sensethe database browser is similar to text editor when working with text files when you want to do one or very few operations on text fileyou can just open it in text editor and make the changes you want when you have many changes that you need to do to text fileoften you will write 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 creating database table databases require more defined structure than python lists or dictionaries when we create database table we must tell the database in advance the names of each of the columns in the table and the type of data which we are planning to store in each column when the database software knows the type of data in each columnit can choose the most efficient way to store and look up the data based on the type of data you can look at the various data types supported by sqlite at the following urldefining structure for your data up front may seem inconvenient at the beginningbut the payoff is fast access to your data even when the database contains large amount of data sqlite actually does allow some flexibility in the type of data stored in columnbut we will keep our data types strict in this so the concepts apply equally to other database systems such as mysql