In this tutorial, we will be learning about SQLite database and how to connect it with python for the development of database applications. SQLite as the name says, it's a simple, single file database. There is no need of downloading and installing additional files. SQLite comes packed with most python installations. From version 2.5.x onward the SQLite module comes along as a default module.
Creating a database in SQLite is very simple as if we create a a directory or a file. Database in SQLite is created during the connection phase. Database will be stored as a file in the specified directory.
Now, let's connect to our database:
import sqlite3 con=sqlite3.connect('mydata.db')
From the above code block, we can see that, the connect method is provided with a parameter 'mydata.db' . This is what our database name is. If the file is already created, then the connect method will try to connect with the database or will create a new database file as 'mydata.db'.
Create a File and Save it as sqlconnect.py. Now, create a function to call everytime where we require database connectivity.
import sqlite3 def dbconnect(): con=sqlite3.connect('mydata.db') return con
In the next tutorial we will be learning about creating tables and Inserting data.