{"id":26781,"date":"2023-01-30T14:56:36","date_gmt":"2023-01-30T09:26:36","guid":{"rendered":"https:\/\/copyassignment.com\/?p=26781"},"modified":"2023-01-30T14:58:26","modified_gmt":"2023-01-30T09:28:26","slug":"sqlite-crud-operations-in-python","status":"publish","type":"post","link":"https:\/\/copyassignment.com\/sqlite-crud-operations-in-python\/","title":{"rendered":"SQLite | CRUD Operations in Python"},"content":{"rendered":"\n<p>CRUD stands for Create Read Update Delete. I will show you how to perform CRUD Operations in Python. You need basic Tkinter and SQLite knowledge before you read further. This app is straightforward, when you will open this app, a GUI with 4 green colored buttons will open to perform CRUD(create read update delete) operations. <a href=\"https:\/\/docs.python.org\/3\/library\/sqlite3.html\" target=\"_blank\" rel=\"noreferrer noopener\">SQLite3 library<\/a> comes inbuilt with Python.<\/p>\n\n\n\n<script async=\"\" src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\n<ins class=\"adsbygoogle\" style=\"display:block; text-align:center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-9886351916045880\" data-ad-slot=\"2002566052\"><\/ins>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script>\n\n\n\n<h2 class=\"wp-block-heading\">Folder structure for CRUD operations in Python<\/h2>\n\n\n\n<p>There are 5 files, and 1 main file handles GUI and works like the driver of the whole application. The other 4 files are there to perform CRUD operations in Python using the SQLite3 database. I have named those files with the CRUD name, making it easy to know which file does what. Check the image below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"208\" height=\"197\" data-src=\"https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/image-13.png\" alt=\"folder structure\" class=\"wp-image-26808 lazyload\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 208px; --smush-placeholder-aspect-ratio: 208\/197;\" \/><\/figure>\n\n\n\n<p>So, there are 5 files <strong><em>main.py<\/em><\/strong>, <strong><em>create.py<\/em><\/strong>, <strong><em>read.py<\/em><\/strong>, <strong><em>update.py<\/em><\/strong>, and <strong><em>delete.py<\/em><\/strong>. The folder(<a href=\"https:\/\/stackoverflow.com\/questions\/16869024\/what-is-pycache\" target=\"_blank\" rel=\"noreferrer noopener\">pycache<\/a>) you are seeing is auto-generated. I will give you the code for each python file separately. You need to create a separate folder with any name and create these 5 files as shown in the image above. You can run this app from <strong><em>main.py<\/em><\/strong> file.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Complete code for SQLite CRUD operations in Python<\/h2>\n\n\n\n<p>As the code is divided into 5 parts so it&#8217;s easy to understand which part does what. For the database part, I have created separate files and performed SQLite CRUD operations with handling errors and exceptions using try and except block. Also, the ID will be auto-generated every time user will create a new row. I have also added a feature of showing the message to the user when he performs a CRUD operation.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">main.py<\/h3>\n\n\n\n<div style=\"height: 250px; position:relative; margin-bottom: 50px;\" class=\"wp-block-simple-code-block-ace\"><div style=\"position:absolute;top:-20px;right:0px;cursor:pointer\" class=\"copy-simple-code-block\"><span class=\"dashicon dashicons dashicons-admin-page\"><\/span><\/div><pre class=\"wp-block-simple-code-block-ace\" style=\"position:absolute;top:0;right:0;bottom:0;left:0\" data-mode=\"python\" data-theme=\"xcode\" data-fontsize=\"14\" data-lines=\"Infinity\" data-showlines=\"true\" data-copy=\"true\">from tkinter import *\nimport random\nimport string\n\ntop = Tk()\ntop.title('CopyAssignment Tkinter CRUD SQLite')\ntop.geometry('430x400')\n\ndef CreateOperation():\n    from create import InsertData\n\n    top1 = Tk()\n    top1.geometry('300x200')\n    top1.title('Create operation of CRUD')\n\n    letters = string.ascii_lowercase\n    random_id = ''.join(random.choice(letters) for i in range(8))\n\n    name = StringVar(top1)\n    ID = StringVar(top1)\n\n    ID.set(random_id)\n\n    Label(top1, text='Name').grid(row=0, column=0, padx=20, pady=20, sticky='w')\n    Entry(top1, textvariable=name).grid(row=0, column=1, padx=20)\n\n    Label(top1, text='ID(auto generated)').grid(row=1, padx=20, column=0, sticky='w')\n    Entry(top1, textvariable=ID, state='disabled').grid(row=1, column=1)\n\n    Button(top1, text='Create', fg='white', bg='green', font=('Arial', 20), command=lambda: InsertData(name.get(), random_id)).grid(row=2, column=0, columnspan=2, pady=20)\n\n    top1.mainloop()\n\n\nButton(top, text='Create', bg='green', fg='white', width=12, font=('Arial', 18), command=lambda: CreateOperation()).grid(row=0, column=0, padx=25, pady=30)\n\ndef ReadOperation():\n    from read import Read\n\n    top2 = Tk()\n    top2.geometry('250x200')\n    top2.title('Read operation of CRUD')\n\n    Label(top2, text='Name').grid(row=0, column=0, padx=30, sticky='w')\n    Label(top2, text='   |      ').grid(row=0, column=1)\n    Label(top2, text='ID').grid(row=0, padx=20, column=2, sticky='w')\n\n    Label(top2, text='--------'*5).grid(row=1, padx=20,  column=0, columnspan=5)\n\n    data = Read()\n    for i in range(len(data)):\n        Label(top2, text=data[i][0]).grid(row=2+i, column=0, sticky='w', padx=20)\n        Label(top2, text='   |      ').grid(row=2+i, column=1)\n        Label(top2, text=data[i][1]).grid(row=2+i, column=2, sticky='w')\n\n    top2.mainloop()\n\n\nButton(top, text='Read', bg='green', fg='white', width=12, font=('Arial', 18), command=lambda: ReadOperation()).grid(row=0, column=1)\n\n\ndef UpdateOperation():\n    from read import Read\n    from update import Update\n\n    top3 = Tk()\n    top3.geometry('250x200')\n    top3.title('Update operation of CRUD')\n    \n    data = Read()\n    id_list = []\n    for i in data:\n        id_list.append(i[1])\n        \n    e = StringVar(top3)\n    e.set('Select ID')\n    OptionMenu(top3, e, *id_list).pack(pady=15)\n\n    name = StringVar(top3)\n    name.set('New name')\n    Entry(top3, textvariable=name).pack(pady=15)\n\n    def MyUpdate():\n        Update(name.get(), e.get())\n        top3.destroy()\n    Button(top3, text='Update', command=lambda: MyUpdate(), bg='green', fg='white', font=('Arial', 18)).pack(pady=15)\n\n    top3.mainloop()\n\n\nButton(top, text='Update', bg='green', fg='white', width=12, font=('Arial', 18), command=lambda: UpdateOperation()).grid(row=1, pady=20, column=0)\n\n\ndef DeleteOperation():\n    from read import Read\n    from delete import Delete\n\n    top4 = Tk()\n    top4.geometry('250x200')\n    top4.title('Delete operation of CRUD')\n    \n    data = Read()\n    id_list = []\n    for i in data:\n        id_list.append(i[1])\n        \n    e = StringVar(top4)\n    e.set('Select ID')\n    OptionMenu(top4, e, *id_list).pack()\n\n    def MyDelete():\n        Delete(e.get())\n        top4.destroy()\n    Button(top4, text='Delete', bg='green', fg='white', width=12, font=('Arial', 18), command=lambda: MyDelete()).pack(pady=20)\n\n    top4.mainloop()\n\n\nButton(top, text='Delete', bg='green', fg='white', width=12, font=('Arial', 18), command=lambda: DeleteOperation()).grid(row=1, column=1)\n\ntop.mainloop()<\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">create.py<\/h3>\n\n\n\n<script async=\"\" src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\n<ins class=\"adsbygoogle\" style=\"display:block; text-align:center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-9886351916045880\" data-ad-slot=\"2002566052\"><\/ins>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script>\n\n\n\n<div style=\"height: 250px; position:relative; margin-bottom: 50px;\" class=\"wp-block-simple-code-block-ace\"><div style=\"position:absolute;top:-20px;right:0px;cursor:pointer\" class=\"copy-simple-code-block\"><span class=\"dashicon dashicons dashicons-admin-page\"><\/span><\/div><pre class=\"wp-block-simple-code-block-ace\" style=\"position:absolute;top:0;right:0;bottom:0;left:0\" data-mode=\"python\" data-theme=\"xcode\" data-fontsize=\"14\" data-lines=\"Infinity\" data-showlines=\"true\" data-copy=\"true\">import sqlite3\nfrom tkinter import messagebox\n\ndef Create():\n    conn = sqlite3.connect('mydatabase.db')\n    cursor = conn.cursor()\n    \n    # statement to create a table in sqlite3 using python\n    cursor.execute(\"CREATE TABLE IF NOT EXISTS mytable (myname TEXT, id TEXT PRIMARY KEY)\")\n\n    conn.close()\n\ndef InsertData(name, id):\n    Create()\n    try:\n        conn = sqlite3.connect(\"mydatabase.db\")\n        cursor = conn.cursor()\n        \n        # statement to insert data into table in sqlite3 using python\n        cursor.execute(\"INSERT INTO mytable (myname, id) VALUES (?, ?)\", (name, id))\n        \n        conn.commit()\n        conn.close()\n        messagebox.showinfo('Success', 'Data inserted successfully')\n    except sqlite3.Error as e:\n        messagebox.showinfo('Error', e)\n    finally:\n        conn.close()<\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">read.py<\/h3>\n\n\n\n<div style=\"height: 250px; position:relative; margin-bottom: 50px;\" class=\"wp-block-simple-code-block-ace\"><div style=\"position:absolute;top:-20px;right:0px;cursor:pointer\" class=\"copy-simple-code-block\"><span class=\"dashicon dashicons dashicons-admin-page\"><\/span><\/div><pre class=\"wp-block-simple-code-block-ace\" style=\"position:absolute;top:0;right:0;bottom:0;left:0\" data-mode=\"python\" data-theme=\"xcode\" data-fontsize=\"14\" data-lines=\"Infinity\" data-showlines=\"true\" data-copy=\"true\">import sqlite3\n\ndef Read():\n    conn = sqlite3.connect('mydatabase.db')\n    cursor = conn.cursor()\n\n    # statement to read or fetch all rows from a table in sqlite3 using python\n    cursor.execute('SELECT * FROM mytable')\n    all_rows = cursor.fetchall()\n    \n    conn.close()\n\n    return all_rows<\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">update.py<\/h3>\n\n\n\n<div style=\"height: 250px; position:relative; margin-bottom: 50px;\" class=\"wp-block-simple-code-block-ace\"><div style=\"position:absolute;top:-20px;right:0px;cursor:pointer\" class=\"copy-simple-code-block\"><span class=\"dashicon dashicons dashicons-admin-page\"><\/span><\/div><pre class=\"wp-block-simple-code-block-ace\" style=\"position:absolute;top:0;right:0;bottom:0;left:0\" data-mode=\"python\" data-theme=\"xcode\" data-fontsize=\"14\" data-lines=\"Infinity\" data-showlines=\"true\" data-copy=\"true\">from tkinter import messagebox\nimport sqlite3\n\ndef Update(name, id):\n    try:\n        conn = sqlite3.connect('mydatabase.db')\n        c = conn.cursor()\n\n        # statement to update a row in sqlite3 using python\n        c.execute(\"UPDATE mytable SET myname=?  WHERE id=?\", (name, id))\n        \n        conn.commit()\n        conn.close()\n        messagebox.showinfo('Success', 'Data updated successfully')\n    except sqlite3.Error as e:\n        messagebox.showinfo('Error', e)\n    finally:\n        conn.close()<\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">delete.py<\/h3>\n\n\n\n<div style=\"height: 250px; position:relative; margin-bottom: 50px;\" class=\"wp-block-simple-code-block-ace\"><div style=\"position:absolute;top:-20px;right:0px;cursor:pointer\" class=\"copy-simple-code-block\"><span class=\"dashicon dashicons dashicons-admin-page\"><\/span><\/div><pre class=\"wp-block-simple-code-block-ace\" style=\"position:absolute;top:0;right:0;bottom:0;left:0\" data-mode=\"python\" data-theme=\"xcode\" data-fontsize=\"14\" data-lines=\"Infinity\" data-showlines=\"true\" data-copy=\"true\">import sqlite3\nfrom tkinter import messagebox\n\ndef Delete(id):\n    try:\n        conn = sqlite3.connect(\"mydatabase.db\")\n        cursor = conn.cursor()\n        \n        # statement to delete a row in sqlite3 using python\n        cursor.execute(\"DELETE FROM mytable WHERE id = ?\", (id,))\n        \n        conn.commit()\n        conn.close()\n        messagebox.showinfo('Success', 'Data deleted successfully')\n    except sqlite3.Error as e:\n        messagebox.showinfo('Error', e)\n    finally:\n        conn.close()<\/pre><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Output for SQLite CRUD operations in Python:<\/h2>\n\n\n\n<script async=\"\" src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\n<ins class=\"adsbygoogle\" style=\"display:block; text-align:center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-9886351916045880\" data-ad-slot=\"2002566052\"><\/ins>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script>\n\n\n\n<h3 class=\"wp-block-heading\">Image output:<\/h3>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img decoding=\"async\" data-src=\"https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/Screenshot-456.png\" alt=\"main screen of SQLite CRUD operations in Python\" class=\"wp-image-26877 lazyload\" width=\"498\" height=\"268\" data-srcset=\"https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/Screenshot-456.png 534w, https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/Screenshot-456-300x161.png 300w\" data-sizes=\"(max-width: 498px) 100vw, 498px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 498px; --smush-placeholder-aspect-ratio: 498\/268;\" \/><\/figure>\n<\/div>\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p><strong>Create operation<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"659\" height=\"575\" data-src=\"https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/Screenshot-457.png\" alt=\"create operation of crud in python\" class=\"wp-image-26876 lazyload\" data-srcset=\"https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/Screenshot-457.png 659w, https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/Screenshot-457-300x262.png 300w\" data-sizes=\"(max-width: 659px) 100vw, 659px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 659px; --smush-placeholder-aspect-ratio: 659\/575;\" \/><\/figure>\n\n\n\n<p><strong>Update operation<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img decoding=\"async\" data-src=\"https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/Screenshot-459.png\" alt=\"update operation of crud in python\" class=\"wp-image-26874 lazyload\" width=\"346\" height=\"329\" data-srcset=\"https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/Screenshot-459.png 603w, https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/Screenshot-459-300x286.png 300w\" data-sizes=\"(max-width: 346px) 100vw, 346px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 346px; --smush-placeholder-aspect-ratio: 346\/329;\" \/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p><strong>Read operation<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img decoding=\"async\" data-src=\"https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/Screenshot-458.png\" alt=\"read operation of crud in python\" class=\"wp-image-26875 lazyload\" width=\"308\" height=\"334\" data-srcset=\"https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/Screenshot-458.png 532w, https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/Screenshot-458-277x300.png 277w\" data-sizes=\"(max-width: 308px) 100vw, 308px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 308px; --smush-placeholder-aspect-ratio: 308\/334;\" \/><\/figure>\n\n\n\n<p><strong>Delete operation<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img decoding=\"async\" data-src=\"https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/Screenshot-460.png\" alt=\"delete operation of crud in python\" class=\"wp-image-26873 lazyload\" width=\"402\" height=\"332\" data-srcset=\"https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/Screenshot-460.png 584w, https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/Screenshot-460-300x248.png 300w\" data-sizes=\"(max-width: 402px) 100vw, 402px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 402px; --smush-placeholder-aspect-ratio: 402\/332;\" \/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Video output:<\/h3>\n\n\n<div style=\"width: 640px;\" class=\"wp-video\"><video class=\"wp-video-shortcode\" id=\"video-26781-1\" width=\"640\" height=\"360\" preload=\"metadata\" controls=\"controls\"><source type=\"video\/mp4\" src=\"https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/crud-sqlite-tkinter.mp4?_=1\" \/><a href=\"https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/crud-sqlite-tkinter.mp4\">https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/crud-sqlite-tkinter.mp4<\/a><\/video><\/div>\n\n\n\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-9886351916045880\"\n     crossorigin=\"anonymous\"><\/script>\n<ins class=\"adsbygoogle\"\n     style=\"display:block\"\n     data-ad-format=\"autorelaxed\"\n     data-ad-client=\"ca-pub-9886351916045880\"\n     data-ad-slot=\"7933252109\"><\/ins>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script>\n\n\n\n<p>Thank you for visiting <a href=\"https:\/\/copyassignment.com\/\">our website<\/a>.<\/p>\n\n\n\n<div style=\"text-align:center\" class=\"wp-block-atomic-blocks-ab-button ab-block-button\"><a href=\"https:\/\/copyassignment.com\/top-100-python-projects-with-source-code\/\" class=\"ab-button ab-button-shape-rounded ab-button-size-medium\" style=\"color:#ffffff;background-color:#3373dc\">Best 100+ Python Projects with source code<\/a><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>Also Read:<\/strong><\/p>\n\n\n<ul class=\"wp-block-latest-posts__list is-grid columns-3 wp-block-latest-posts\"><li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/create-your-own-chatgpt-with-python\/\">Create your own ChatGPT with\u00a0Python<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/sqlite-crud-operations-in-python\/\">SQLite | CRUD Operations in Python<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/event-management-system-project-in-python\/\">Event Management System Project in Python<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/ticket-booking-and-management-in-python\/\">Ticket Booking and Management in Python<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/hostel-management-system-project-in-python\/\">Hostel Management System Project in Python<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/sales-management-system-project-in-python\/\">Sales Management System Project in Python<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/bank-management-system-project-in-cpp\/\">Bank Management System Project in C++<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/python-download-file-from-url-4-methods\/\">Python Download File from URL | 4 Methods<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/python-programming-examples-fundamental-programs-in-python\/\">Python Programming Examples | Fundamental Programs in Python<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/spell-checker-in-python\/\">Spell Checker in Python<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/portfolio-management-system-in-python\/\">Portfolio Management System in Python<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/stickman-game-in-python\/\">Stickman Game in Python<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/contact-book-project-in-python\/\">Contact Book project in Python<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/loan-management-system-project-in-python\/\">Loan Management System Project in Python<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/cab-booking-system-in-python\/\">Cab Booking System in Python<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/brick-breaker-game-in-python\/\">Brick Breaker Game in Python<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/tank-game-in-python\/\">Tank game in Python<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/gui-piano-in-python\/\">GUI Piano in Python<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/ludo-game-in-python\/\">Ludo Game in Python<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/rock-paper-scissors-game-in-python\/\">Rock Paper Scissors Game in Python<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/snake-and-ladder-game-in-python\/\">Snake and Ladder Game in Python<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/puzzle-game-in-python\/\">Puzzle Game in Python<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/medical-store-management-system-project-in-python\/\">Medical Store Management System Project in\u00a0Python<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/creating-dino-game-in-python\/\">Creating Dino Game in Python<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/tic-tac-toe-game-in-python\/\">Tic Tac Toe Game in Python<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/test-typing-speed-using-python-app\/\">Test Typing Speed using Python App<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/scientific-calculator-in-python-2\/\">Scientific Calculator in Python<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/gui-to-do-list-app-in-python-tkinter\/\">GUI To-Do List App in Python Tkinter<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/scientific-calculator-in-python\/\">Scientific Calculator in Python using Tkinter<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/gui-chat-application-in-python-tkinter\/\">GUI Chat Application in Python Tkinter<\/a><\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>CRUD stands for Create Read Update Delete. I will show you how to perform CRUD Operations in Python. You need basic Tkinter and SQLite knowledge&#8230;<\/p>\n","protected":false},"author":74,"featured_media":26903,"comment_status":"open","ping_status":"open","sticky":true,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,1061,1403,1923],"tags":[],"class_list":["post-26781","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-allcategorites","category-gui-python-projects","category-python-projects","category-python-sqlite-qna","wpcat-22-id","wpcat-1061-id","wpcat-1403-id","wpcat-1923-id"],"_links":{"self":[{"href":"https:\/\/copyassignment.com\/wp-json\/wp\/v2\/posts\/26781","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/copyassignment.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/copyassignment.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/copyassignment.com\/wp-json\/wp\/v2\/users\/74"}],"replies":[{"embeddable":true,"href":"https:\/\/copyassignment.com\/wp-json\/wp\/v2\/comments?post=26781"}],"version-history":[{"count":0,"href":"https:\/\/copyassignment.com\/wp-json\/wp\/v2\/posts\/26781\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/copyassignment.com\/wp-json\/wp\/v2\/media\/26903"}],"wp:attachment":[{"href":"https:\/\/copyassignment.com\/wp-json\/wp\/v2\/media?parent=26781"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/copyassignment.com\/wp-json\/wp\/v2\/categories?post=26781"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/copyassignment.com\/wp-json\/wp\/v2\/tags?post=26781"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}