In this article, database connection with the python program is discussed. Connecting a program with a database is considered a tough task in any programming language. It is used to connect the front-end of your application with the back-end database. Python with its native builtin modules made this thing easy too.
This needs the basic understanding of SQL.
Here, we are going to connect SQLite with Python. Python has a native library for SQLite. Let us explain how it works.
- To use SQLite, we must import sqlite3.
- Then create a connection using connect() method and pass the name of the database you want to access if there is a file with that name, it will open that file. Otherwise, Python will create a file with the given name.
- After this, a cursor object is called to be capable to send commands to the SQL. Cursor is a control structure used to traverse and fetch the records of the database. Cursor has a major role in working with Python. All the commands will be executed using cursor object only.
- To create a table in the database, create an object and write the SQL command in it with being commented. Example:- sql_comm = ”SQL statement”
- And executing the command is very easy. Call the cursor method execute and pass the name of the sql command as a parameter in it. Save a number of commands as the sql_comm and execute them. After you perform all your activities, save the changes in the file by committing those changes and then lose the connection.
In this section, we have discussed how to create a table and how to add new rows in the database.
Fetching the data from record is simple as the inserting them. The execute method uses the SQL command of getting all the data from the table using “Select * from table_name” and all the table data can be fetched in an object in the form of list of lists.
It should be noted that the database file that will be created will be in the same folder as that of the python file. If we wish to change the path of the file, change the path while opening the file.
This article is contributed by Rishabh Bansal. If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to email@example.com. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.
- Difference between Structured Query Language (SQL) and Transact-SQL (T-SQL)
- SQL | Procedures in PL/SQL
- SQL | Difference between functions and stored procedures in PL/SQL
- Difference between SQL and T-SQL
- SQL using Python and SQLite | Set 2
- SQL using Python | Set 3 (Handling large data)
- Mitigation of SQL Injection Attack using Prepared Statements (Parameterized Queries)
- SQL | USING Clause
- Swap two numbers in PL/SQL without using temp
- SQL | Checking Existing Constraints on a Table using Data Dictionaries
- Combining aggregate and non-aggregate values in SQL using Joins and Over clause
- SQL using C/C++ and SQLite
- Copy tables between databases in SQL Server using Import-and-Export Wizard
- Display Sequence of Numbers in SQL Using LEVEL
- Count the number of a special day between two dates by using PL/SQL
- SQL query using COUNT and HAVING clause
- Advantages and Disadvantages of Using Stored Procedures - SQL
- Manipulate R Data Frames Using SQL
- Read SQL database table into a Pandas DataFrame using SQLAlchemy
- SQL | Query to select NAME from table using different options
Improved By : tejshreelavatre