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.
Importing SQLite Module:
import sqlite3
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:
Create a Database and make a connection:
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. Thank you.