GK SCIENTIST

General Knowledge One Stop Source
Menu
  • Home
  • Social Science
    • History
    • Political Science
    • Geography
  • Science
    • Physics
    • Chemistry
    • Biology
  • Chemistry Notes
  • Mathematics
  • Computer
  • Tutorial MySQL
  • Tutorial Python
  • Java Tutorial
  • English Grammar
  • English Essay
  • Indian Anthropology
  • Philosophy
  • Solved Paper
  • UPSC
  • Current Content
    • Current Affairs
    • RSTV News
    • Yojana and Kurukshetra Gist
  • Donate
  • Contact Us

If you are interested in advertising to our audience, submit the advertising enquiry form.

Advertising Enquiry
Computer

SQLite in Python

Gk Scientist December 7, 2022 No Comments
Tweet WhatsApp Telegram

SQLite in Python:

We can use the PyCharm code editor for this example. If you do not know about it then follow this link- How to install PyCharm for Python and create a program in it.

SQLite is a very popular relational database used in a wide variety of applications. Unlike other databases like MySQL, Oracle, etc., SQLite is a transactional SQL database engine that is self-contained and serverless. The entire database is a single file that can be placed anywhere in the file system. To access SQLite from Python, we need an SQLite driver for Python. Fortunately, the SQLite driver for Python is already included in Python standard library so we don’t need to install this.

Now we can create a database and table using SQLite in Python as shown below.

employee table create using python sqlite - SQLite in Python

When you run the code, the database and table are created. If you want to see whether the table is created or not, run the code two times because the second time it throws an error that the table already exists as shown above.

Note:- Follow this blog “Install DB Browser for SQLite on Windows” to see the table and fields created in it.

SQLite Database along with table created in it viewed in DB Browser as shown below.

employee table in db browser for sqlite - SQLite in Python

Right-click on employee_table you can browse the table as shown below.

browse table in db browser 1 - SQLite in Python

Tutorial MySQL
Tutorial Python
Database Management System (DBMS)
Computer Software and Hardware
Malicious Software (Malware)
Application Software
Utility Software
Python (programming language)– Wikipedia
Prev Article
Next Article

Related Articles

How to Create List in Python
Create List in Python: We can use the PyCharm code …
Gk Scientist November 27, 2022 Computer

How to Create List in Python

Python Random Module
Python Random Module: We can use the PyCharm code editor …
Gk Scientist December 3, 2022 Computer

Python Random Module

Wireless Networking
Wireless Networking: Wireless Networking facilitates data transmission through the earth’s …
Gk Scientist October 20, 2022 Computer

Wireless Networking

Create CheckBox in Java
Create CheckBox in Java: We can use the Eclipse IDE …
Gk Scientist January 14, 2023 Computer

Create CheckBox in Java

Java Super Keyword
Java Super Keyword: We can use the Eclipse IDE for …
Gk Scientist January 11, 2023 Computer

Java Super Keyword

How to Create Variables in Python
Create Variables in Python: We can use the PyCharm code …
Gk Scientist November 21, 2022 Computer

How to Create Variables in Python

Implement Queue in Python
Queue in Python: We can use the PyCharm code editor …
Gk Scientist November 29, 2022 Computer

Implement Queue in Python

Sets in Python
Sets in Python: We can use the PyCharm code editor …
Gk Scientist December 2, 2022 Computer

Sets in Python

Leave a Reply Cancel Reply

Search

  • Popular
  • Recent




GK SCIENTIST

General Knowledge One Stop Source

Information

  • About Us
  • Terms and Condition, Disclaimer
  • Contact Us

Android Apps

  • IAS App For English Medium Students
  • IAS Basics App For English Medium Students
  • IAS Hindi App For Hindi Medium Students
DMCA.com Protection Status

Popular Tags

Biology (33) Biology Questions (88) Chemistry (57) Computer (215) Current Affairs (4) Current Content (0) Economy (17) English Essay (172) English Grammar (75) English Literature (10) Geography (83) History (259) Indian Anthropology (11) Indian Polity (14) JKAS Mains Question Papers (17) Mathematics (68) Moral Science (7) NCERT & Other Boards Books (25) Philosophy (114) Physics (89) Political Science (132) RS TV News (33) Science (553) Social Anthropology (7) Social Science (17) Solved Paper (47) UPSC (7) UPSC Mains Question Papers (26)

Downloads

  • NCERT Books
  • Old NCERT Books
  • NIOS Books For IAS, SSC, and State PSC Exam
  • Tamil Nadu Board Books: Important For UPSC, SSC, and State PSC Exam
  • Modern Indian and World History Notes For IAS Exam
  • UPSC Topper 2013 Gaurav Agrawal Notes For IAS Preparation
  • UPSC IAS Prelims General Studies – Previous Year Papers
  • UPSC Mains Question Papers

Copyright © 2023 GK SCIENTIST
Theme by MyThemeShop.com& Hosted On Cloudways

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh
 

Loading Comments...