Getting started with SQLite in python

SQLite is a self-contained, server-less, config-free transactional SQL database engine. Python gained the sqlite3 module all the way back in version 2.5 which means that you can create SQLite database with any current Python without downloading any additional dependencies. Mozilla uses SQLite databases for its popular Firefox browser to store bookmarks and other various pieces of information. In this chapter you will learn the following:

• How to create a SQLite database
• How to insert data into a table
• How to edit the data
• How to delete the data
• Basic SQL queries

In other words, rather than covering bits and pieces of the sqlite3 module, we’ll go through how to actually use it.

If you want to inspect your database visually, you can use the SQLite Manager plugin for Firefox (just Google for it) or if you like the command line, you can use SQLite’s command line shell.