{"id":1042,"date":"2018-09-10T16:30:55","date_gmt":"2018-09-10T16:30:55","guid":{"rendered":"http:\/\/learnlearn.uk\/python\/?page_id=1042"},"modified":"2018-09-10T16:30:55","modified_gmt":"2018-09-10T16:30:55","slug":"python-sqlite-tutorials","status":"publish","type":"page","link":"https:\/\/learnlearn.uk\/python\/python-sqlite-tutorials\/","title":{"rendered":"Python SQLite Tutorials"},"content":{"rendered":"\n<div class=\"arconix-tabs-horizontal\"><ul class=\"arconix-tabs\"><li data-arconix-icon=\" \" data-arconix-color=\" \" class=\"arconix-tab tab-Introduction\"><a class=\"\" href=\"#tab-Introduction\">Introduction<\/a><\/li>\n<li data-arconix-icon=\" \" data-arconix-color=\" \" class=\"arconix-tab tab-CreateDatabasesampTables\"><a class=\"\" href=\"#tab-CreateDatabasesampTables\">Create Databases &amp; Tables<\/a><\/li>\n<li data-arconix-icon=\" \" data-arconix-color=\" \" class=\"arconix-tab tab-AddingItems\"><a class=\"\" href=\"#tab-AddingItems\">Adding Items<\/a><\/li>\n<li data-arconix-icon=\" \" data-arconix-color=\" \" class=\"arconix-tab tab-ViewingTablesItems\"><a class=\"\" href=\"#tab-ViewingTablesItems\">Viewing Tables \/ Items<\/a><\/li>\n<li data-arconix-icon=\" \" data-arconix-color=\" \" class=\"arconix-tab tab-UpdatingTablesItems\"><a class=\"\" href=\"#tab-UpdatingTablesItems\">Updating Tables \/ Items<\/a><\/li>\n<li data-arconix-icon=\" \" data-arconix-color=\" \" class=\"arconix-tab tab-DeletingItems\"><a class=\"\" href=\"#tab-DeletingItems\">Deleting Items<\/a><\/li><\/ul>\n<div class=\"arconix-panes\"><div class=\"arconix-pane pane-Introduction\">\n<p><strong>Introduction<\/strong><\/p>\n<p>SQLite databases are a powerful form of persistent file storage that are a great alternative to CSV files.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Advantages<\/strong><\/p>\n<ul>\n<li>Very powerful &#8211; you can do advanced queries ( like searching and sorting) very quickly<\/li>\n<li>You can create relational databases which are brilliant for larger or more complex projects<\/li>\n<li>Easy to manage the databases.<\/li>\n<li>Great for learning SQL queries that you will need in the GCSE Exam.<\/li>\n<\/ul>\n<p><strong>Disadvantages<\/strong><\/p>\n<ul>\n<li>More code at the start of a project to get started<\/li>\n<li>A little bit harder to learn than simple text files.<\/li>\n<\/ul>\n<\/div>\n<div class=\"arconix-pane pane-CreateDatabasesampTables\">\n<p><strong>Create Databases &amp; Tables<\/strong><\/p>\n<p><a href=\"https:\/\/drive.google.com\/open?id=1lqIdgTFjkZ6x3RUXgwV2SMBgl0SEj6f6\">Can&#8217;t access YouTube? Click here for the Google Drive version<\/a><\/p>\n<p><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/ED55kTWCaq8\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<\/div>\n<div class=\"arconix-pane pane-AddingItems\">\n<p><strong>Adding items to SQLite Tables<\/strong><\/p>\n<p><a href=\"https:\/\/drive.google.com\/file\/d\/1c9oYGaTJPTlCGea7-cynwz1Y0EJjCXuD\/view?usp=sharing\">Can&#8217;t access YouTube? Click here for the Google Drive version<\/a><\/p>\n<p><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/E6tUcbnh7hM\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<\/div>\n<div class=\"arconix-pane pane-ViewingTablesItems\">\n<p><strong>Viewing tables\/items in databases<\/strong><\/p>\n<p><a href=\"https:\/\/drive.google.com\/open?id=19pvBKsRffScwqcwVbhAK_C2K9jUkALOG\">Can&#8217;t access YouTube? Click here for the Google Drive version<\/a><\/p>\n<p><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/niN6de6JQYw\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<\/div>\n<div class=\"arconix-pane pane-UpdatingTablesItems\">\n<p><strong>Updating Tables \/ Items<\/strong><\/p>\n<p><a href=\"https:\/\/drive.google.com\/open?id=1H2vfiVRr0I9xdVx_VmmHEhN75BND-zDR\">Can&#8217;t access YouTube? Click here for the Google Drive version<\/a><\/p>\n<p><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/yS4V1CfNgEo\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<\/div>\n<div class=\"arconix-pane pane-DeletingItems\">\n<p><strong>Deleting items from tables<\/strong><\/p>\n<p><a href=\"https:\/\/drive.google.com\/open?id=1FFt7ip1FoEaHHbGnYvYZcz5tTAApURI3\">Can&#8217;t access YouTube? Click here for the Google Drive version<\/a><\/p>\n<p><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/XRs2zZoUX90\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><br \/>\n<\/div><\/div><\/div>\n\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Python SQLite Tutorials - Python<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/learnlearn.uk\/python\/python-sqlite-tutorials\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Python SQLite Tutorials - Python\" \/>\n<meta property=\"og:url\" content=\"https:\/\/learnlearn.uk\/python\/python-sqlite-tutorials\/\" \/>\n<meta property=\"og:site_name\" content=\"Python\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/learnlearn.uk\/python\/python-sqlite-tutorials\/\",\"url\":\"https:\/\/learnlearn.uk\/python\/python-sqlite-tutorials\/\",\"name\":\"Python SQLite Tutorials - Python\",\"isPartOf\":{\"@id\":\"https:\/\/learnlearn.uk\/python\/#website\"},\"datePublished\":\"2018-09-10T16:30:55+00:00\",\"dateModified\":\"2018-09-10T16:30:55+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/learnlearn.uk\/python\/python-sqlite-tutorials\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/learnlearn.uk\/python\/python-sqlite-tutorials\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/learnlearn.uk\/python\/python-sqlite-tutorials\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Python Unit Home\",\"item\":\"https:\/\/learnlearn.uk\/python\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Python SQLite Tutorials\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/learnlearn.uk\/python\/#website\",\"url\":\"https:\/\/learnlearn.uk\/python\/\",\"name\":\"Python\",\"description\":\"Programming\",\"publisher\":{\"@id\":\"https:\/\/learnlearn.uk\/python\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/learnlearn.uk\/python\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/learnlearn.uk\/python\/#organization\",\"name\":\"Python\",\"url\":\"https:\/\/learnlearn.uk\/python\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/learnlearn.uk\/python\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/learnlearn.uk\/python\/wp-content\/uploads\/sites\/4\/2019\/03\/LearnLearnLogowhite.png\",\"contentUrl\":\"https:\/\/learnlearn.uk\/python\/wp-content\/uploads\/sites\/4\/2019\/03\/LearnLearnLogowhite.png\",\"width\":710,\"height\":98,\"caption\":\"Python\"},\"image\":{\"@id\":\"https:\/\/learnlearn.uk\/python\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Python SQLite Tutorials - Python","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/learnlearn.uk\/python\/python-sqlite-tutorials\/","og_locale":"en_GB","og_type":"article","og_title":"Python SQLite Tutorials - Python","og_url":"https:\/\/learnlearn.uk\/python\/python-sqlite-tutorials\/","og_site_name":"Python","twitter_card":"summary_large_image","twitter_misc":{"Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/learnlearn.uk\/python\/python-sqlite-tutorials\/","url":"https:\/\/learnlearn.uk\/python\/python-sqlite-tutorials\/","name":"Python SQLite Tutorials - Python","isPartOf":{"@id":"https:\/\/learnlearn.uk\/python\/#website"},"datePublished":"2018-09-10T16:30:55+00:00","dateModified":"2018-09-10T16:30:55+00:00","breadcrumb":{"@id":"https:\/\/learnlearn.uk\/python\/python-sqlite-tutorials\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/learnlearn.uk\/python\/python-sqlite-tutorials\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/learnlearn.uk\/python\/python-sqlite-tutorials\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Python Unit Home","item":"https:\/\/learnlearn.uk\/python\/"},{"@type":"ListItem","position":2,"name":"Python SQLite Tutorials"}]},{"@type":"WebSite","@id":"https:\/\/learnlearn.uk\/python\/#website","url":"https:\/\/learnlearn.uk\/python\/","name":"Python","description":"Programming","publisher":{"@id":"https:\/\/learnlearn.uk\/python\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/learnlearn.uk\/python\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/learnlearn.uk\/python\/#organization","name":"Python","url":"https:\/\/learnlearn.uk\/python\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/learnlearn.uk\/python\/#\/schema\/logo\/image\/","url":"https:\/\/learnlearn.uk\/python\/wp-content\/uploads\/sites\/4\/2019\/03\/LearnLearnLogowhite.png","contentUrl":"https:\/\/learnlearn.uk\/python\/wp-content\/uploads\/sites\/4\/2019\/03\/LearnLearnLogowhite.png","width":710,"height":98,"caption":"Python"},"image":{"@id":"https:\/\/learnlearn.uk\/python\/#\/schema\/logo\/image\/"}}]}},"rttpg_featured_image_url":null,"rttpg_author":{"display_name":"learnlearnadmin","author_link":"https:\/\/learnlearn.uk\/python\/author\/learnlearnadmin\/"},"rttpg_comment":0,"rttpg_category":null,"rttpg_excerpt":null,"_links":{"self":[{"href":"https:\/\/learnlearn.uk\/python\/wp-json\/wp\/v2\/pages\/1042"}],"collection":[{"href":"https:\/\/learnlearn.uk\/python\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/learnlearn.uk\/python\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/learnlearn.uk\/python\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/learnlearn.uk\/python\/wp-json\/wp\/v2\/comments?post=1042"}],"version-history":[{"count":1,"href":"https:\/\/learnlearn.uk\/python\/wp-json\/wp\/v2\/pages\/1042\/revisions"}],"predecessor-version":[{"id":1043,"href":"https:\/\/learnlearn.uk\/python\/wp-json\/wp\/v2\/pages\/1042\/revisions\/1043"}],"wp:attachment":[{"href":"https:\/\/learnlearn.uk\/python\/wp-json\/wp\/v2\/media?parent=1042"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}