{"id":2479,"date":"2016-05-19T05:17:09","date_gmt":"2016-05-19T09:17:09","guid":{"rendered":"http:\/\/local.brightwhiz\/?p=2479"},"modified":"2016-05-19T05:17:09","modified_gmt":"2016-05-19T09:17:09","slug":"sqlite-3-13-0-download-available","status":"publish","type":"post","link":"http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/","title":{"rendered":"The new Update of SQLite 3.13.0 has Been Released"},"content":{"rendered":"<p>The immediate availability of\u00a0SQLite 3.13.0 has been announced by the development team that maintains it. This cross-platform <a href=\"\/\/local.brightwhiz\/tag\/open-source\/\">open source<\/a> <a href=\"\/\/local.brightwhiz\/tag\/libraries\/\">library<\/a> is available as a free download.<\/p>\n<p>SQLite is used in several applications across a wide range of industries. <a href=\"\/\/local.brightwhiz\/tag\/sqlite\/\">SQLite<\/a> can be described as a self-contained, serverless, zero-configuration, transactional <a href=\"\/\/local.brightwhiz\/tag\/sql\/\">SQL<\/a> <a href=\"\/\/local.brightwhiz\/tag\/database\/\">database<\/a> engine.<!--more--><\/p>\n<h2>What&#8217;s new in SQLite 3.13.0<\/h2>\n<p>With SQLite 3.13.0 comes with several bug fixes some of which include fixes to multi-row one-pass <code>DELETE<\/code> optimization. This issue was specific to self-referential subqueries in the WHERE clause. Again with <code>DELETE<\/code>, the possibility of a segfault related to\u00a0a <code>rowid<\/code> table with an <code>INTEGER PRIMARY KEY<\/code> and the <code>WHERE<\/code> clause contains &#8220;<code>OR<\/code>&#8220;. There is also a fix on a locking race condition in Windows when more than one process attempts to recover the same hot journal at the same time.<\/p>\n<p>Improvements in SQLite 3.13.0 include improved Unicode filename handling in the Windows command-line shell. There is a new <code>sqlite3_db_config SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION<\/code> interface which allows the <code>sqlite3_load_extension()<\/code> C-API to be enabled when <code>load_extension()<\/code> is disabled.<\/p>\n<p>The temporary directory search algorithm on Unix platforms now allows directories with write and execute permissions to serve as temporary directories. Also, delay of IO on TEMP files to be delayed for as long as possible even avoiding it completely.<\/p>\n<p>There is a whole host of changes that can be found on <a href=\"https:\/\/www.sqlite.org\/changes.html\" target=\"_blank\" rel=\"noopener\">the changelog page<\/a> so I would advise you head on over there and check them out. If you just want to download the latest copy of SQLite 3.13.0 you can simply go to the official download page and get yourself the appropriate copy.<\/p>\n<p>The guys at Guru99 have set up<a href=\"https:\/\/www.guru99.com\/download-install-sqlite.html\" target=\"_blank\" rel=\"noopener\"> some detailed tips on how to download and install SQLite<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The immediate availability of\u00a0SQLite 3.13.0 has been announced by the development team that maintains it. This cross-platform open source library is available as a free download. SQLite is used in&#8230;<\/p>\n","protected":false},"author":1,"featured_media":2480,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,28,16],"tags":[111,180,220,350,424,433,471,544,545,549,551,591],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQLite 3.13.0 is now Available for Download<\/title>\n<meta name=\"description\" content=\"The latest release of SQLite 3.13.0 update has been released and is now available for download with an array of bug fixes and feature updates\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQLite 3.13.0 is now Available for Download\" \/>\n<meta property=\"og:description\" content=\"The latest release of SQLite 3.13.0 update has been released and is now available for download with an array of bug fixes and feature updates\" \/>\n<meta property=\"og:url\" content=\"http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/\" \/>\n<meta property=\"og:site_name\" content=\"Brightwhiz.com\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/brightwhiz\/\" \/>\n<meta property=\"article:published_time\" content=\"2016-05-19T09:17:09+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2016\/05\/SQLite-3.13.0-Horses.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Michael Bright\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@brightwhizmag\" \/>\n<meta name=\"twitter:site\" content=\"@brightwhizmag\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Michael Bright\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/#article\",\"isPartOf\":{\"@id\":\"http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/\"},\"author\":{\"name\":\"Michael Bright\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32\"},\"headline\":\"The new Update of SQLite 3.13.0 has Been Released\",\"datePublished\":\"2016-05-19T09:17:09+00:00\",\"dateModified\":\"2016-05-19T09:17:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/\"},\"wordCount\":275,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\/\/local.brightwhiz\/#organization\"},\"image\":{\"@id\":\"http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2016\/05\/SQLite-3.13.0-Horses.jpg\",\"keywords\":[\"C++\",\"Database\",\"Embedded\",\"Libraries\",\"Open Source\",\"Optimization\",\"Programming\",\"Software development\",\"Software Engineering\",\"SQL\",\"SQLite\",\"Tools\"],\"articleSection\":[\"News\",\"Software\",\"Technology\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/\",\"url\":\"http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/\",\"name\":\"SQLite 3.13.0 is now Available for Download\",\"isPartOf\":{\"@id\":\"http:\/\/local.brightwhiz\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/#primaryimage\"},\"image\":{\"@id\":\"http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2016\/05\/SQLite-3.13.0-Horses.jpg\",\"datePublished\":\"2016-05-19T09:17:09+00:00\",\"dateModified\":\"2016-05-19T09:17:09+00:00\",\"description\":\"The latest release of SQLite 3.13.0 update has been released and is now available for download with an array of bug fixes and feature updates\",\"breadcrumb\":{\"@id\":\"http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/#primaryimage\",\"url\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2016\/05\/SQLite-3.13.0-Horses.jpg\",\"contentUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2016\/05\/SQLite-3.13.0-Horses.jpg\",\"width\":1200,\"height\":630,\"caption\":\"SQLite 3.13.0 Download Horses\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/local.brightwhiz\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The new Update of SQLite 3.13.0 has Been Released\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/local.brightwhiz\/#website\",\"url\":\"http:\/\/local.brightwhiz\/\",\"name\":\"Brightwhiz.com\",\"description\":\"Best Tech guides, Tutorials, and News\",\"publisher\":{\"@id\":\"http:\/\/local.brightwhiz\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/local.brightwhiz\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"http:\/\/local.brightwhiz\/#organization\",\"name\":\"Brightwhiz\",\"url\":\"http:\/\/local.brightwhiz\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/logo\/image\/\",\"url\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2021\/11\/brightwhiz-com-logo-orange.png\",\"contentUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2021\/11\/brightwhiz-com-logo-orange.png\",\"width\":706,\"height\":135,\"caption\":\"Brightwhiz\"},\"image\":{\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/brightwhiz\/\",\"https:\/\/twitter.com\/brightwhizmag\",\"https:\/\/instagram.com\/bright_whiz\/\",\"https:\/\/www.pinterest.com\/sobbayi\/\",\"https:\/\/www.youtube.com\/channel\/UC6sCdP_d_RiTIM7ErFT-PSQ\"]},{\"@type\":\"Person\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32\",\"name\":\"Michael Bright\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/1.gravatar.com\/avatar\/da90485875ff0aafa38fdd494abe87d1?s=96&d=mm&r=g\",\"contentUrl\":\"http:\/\/1.gravatar.com\/avatar\/da90485875ff0aafa38fdd494abe87d1?s=96&d=mm&r=g\",\"caption\":\"Michael Bright\"},\"sameAs\":[\"https:\/\/sobbayi.com\"],\"url\":\"http:\/\/local.brightwhiz\/author\/sobbayiadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQLite 3.13.0 is now Available for Download","description":"The latest release of SQLite 3.13.0 update has been released and is now available for download with an array of bug fixes and feature updates","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":"http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/","og_locale":"en_US","og_type":"article","og_title":"SQLite 3.13.0 is now Available for Download","og_description":"The latest release of SQLite 3.13.0 update has been released and is now available for download with an array of bug fixes and feature updates","og_url":"http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/","og_site_name":"Brightwhiz.com","article_publisher":"https:\/\/www.facebook.com\/brightwhiz\/","article_published_time":"2016-05-19T09:17:09+00:00","og_image":[{"width":1200,"height":630,"url":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2016\/05\/SQLite-3.13.0-Horses.jpg","type":"image\/jpeg"}],"author":"Michael Bright","twitter_card":"summary_large_image","twitter_creator":"@brightwhizmag","twitter_site":"@brightwhizmag","twitter_misc":{"Written by":"Michael Bright","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/#article","isPartOf":{"@id":"http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/"},"author":{"name":"Michael Bright","@id":"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32"},"headline":"The new Update of SQLite 3.13.0 has Been Released","datePublished":"2016-05-19T09:17:09+00:00","dateModified":"2016-05-19T09:17:09+00:00","mainEntityOfPage":{"@id":"http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/"},"wordCount":275,"commentCount":0,"publisher":{"@id":"http:\/\/local.brightwhiz\/#organization"},"image":{"@id":"http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/#primaryimage"},"thumbnailUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2016\/05\/SQLite-3.13.0-Horses.jpg","keywords":["C++","Database","Embedded","Libraries","Open Source","Optimization","Programming","Software development","Software Engineering","SQL","SQLite","Tools"],"articleSection":["News","Software","Technology"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/","url":"http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/","name":"SQLite 3.13.0 is now Available for Download","isPartOf":{"@id":"http:\/\/local.brightwhiz\/#website"},"primaryImageOfPage":{"@id":"http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/#primaryimage"},"image":{"@id":"http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/#primaryimage"},"thumbnailUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2016\/05\/SQLite-3.13.0-Horses.jpg","datePublished":"2016-05-19T09:17:09+00:00","dateModified":"2016-05-19T09:17:09+00:00","description":"The latest release of SQLite 3.13.0 update has been released and is now available for download with an array of bug fixes and feature updates","breadcrumb":{"@id":"http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/#primaryimage","url":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2016\/05\/SQLite-3.13.0-Horses.jpg","contentUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2016\/05\/SQLite-3.13.0-Horses.jpg","width":1200,"height":630,"caption":"SQLite 3.13.0 Download Horses"},{"@type":"BreadcrumbList","@id":"http:\/\/local.brightwhiz\/sqlite-3-13-0-download-available\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/local.brightwhiz\/"},{"@type":"ListItem","position":2,"name":"The new Update of SQLite 3.13.0 has Been Released"}]},{"@type":"WebSite","@id":"http:\/\/local.brightwhiz\/#website","url":"http:\/\/local.brightwhiz\/","name":"Brightwhiz.com","description":"Best Tech guides, Tutorials, and News","publisher":{"@id":"http:\/\/local.brightwhiz\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/local.brightwhiz\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"http:\/\/local.brightwhiz\/#organization","name":"Brightwhiz","url":"http:\/\/local.brightwhiz\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/local.brightwhiz\/#\/schema\/logo\/image\/","url":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2021\/11\/brightwhiz-com-logo-orange.png","contentUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2021\/11\/brightwhiz-com-logo-orange.png","width":706,"height":135,"caption":"Brightwhiz"},"image":{"@id":"http:\/\/local.brightwhiz\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/brightwhiz\/","https:\/\/twitter.com\/brightwhizmag","https:\/\/instagram.com\/bright_whiz\/","https:\/\/www.pinterest.com\/sobbayi\/","https:\/\/www.youtube.com\/channel\/UC6sCdP_d_RiTIM7ErFT-PSQ"]},{"@type":"Person","@id":"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32","name":"Michael Bright","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/local.brightwhiz\/#\/schema\/person\/image\/","url":"http:\/\/1.gravatar.com\/avatar\/da90485875ff0aafa38fdd494abe87d1?s=96&d=mm&r=g","contentUrl":"http:\/\/1.gravatar.com\/avatar\/da90485875ff0aafa38fdd494abe87d1?s=96&d=mm&r=g","caption":"Michael Bright"},"sameAs":["https:\/\/sobbayi.com"],"url":"http:\/\/local.brightwhiz\/author\/sobbayiadmin\/"}]}},"_links":{"self":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/posts\/2479"}],"collection":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/comments?post=2479"}],"version-history":[{"count":0,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/posts\/2479\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/media\/2480"}],"wp:attachment":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/media?parent=2479"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/categories?post=2479"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/tags?post=2479"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}