Javatpoint Logo
Javatpoint Logo

Connect SQLite with Python

First you have to install Python and SQLite on your syatem.

Install Python

Use the following code:

SQLite Connect sqlite with python 1

Press y and installation will be completed within seconds.

Install SQLite

Installation steps

type in the following command:

After installation check installation, sqlite terminal will give you a prompt and version info ?

Go to desired folder and create database:

sqlite3 database.db

It'll create database.db in the folder you've given the command.

To check if your database is created, use the following command in sqlite3 terminal:

Note: To connect SQLite with Python, you do not need to install the connection module separately because its being shipped by default along with Python version 2.5.x onwards.


SQLite with Python

Create a python file "connect.py", having the following code:

Execute the following statement on command prompt:

SQLite Connect sqlite with python 2

Now connection is created with the javatpoint database. Now you can create a table.

Create a table

Create a table "Employees" within the database "javatpoint".

Create a python file "createtable.py", having the following code:

Execute the following statement on command prompt:

SQLite Connect sqlite with python 3

A table "Employees" is created in the "javatpoint" database.

Insert Records

Insert some records in "Employees" table.

Create a python file "connection.py", having the following code:

Execute the following statement on command prompt:

SQLite Connect sqlite with python 4

Records are inserted successfully.

Select Records

Now you can fetch and display your records from the table "Employees" by using SELECT statement.

Create a python file "select.py", having the following code:

Execute the following statement on command prompt:

SQLite Connect sqlite with python 5

See all the records you have inserted before.

By same procedures, you can update and delete the table in SQLite database usnig Python.






Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA