{"id":3008,"date":"2016-08-12T09:30:59","date_gmt":"2016-08-12T13:30:59","guid":{"rendered":"http:\/\/local.brightwhiz\/?p=3008"},"modified":"2016-08-12T09:30:59","modified_gmt":"2016-08-12T13:30:59","slug":"sqlite-release-3-14-1","status":"publish","type":"post","link":"http:\/\/local.brightwhiz\/sqlite-release-3-14-1\/","title":{"rendered":"SQLite Release 3.14.1 With Several Enhancements now Available"},"content":{"rendered":"<p>A minor update <a href=\"\/\/local.brightwhiz\/tag\/sqlite\/\" target=\"_blank\" rel=\"noopener\">SQLite <\/a>Release 3.14.1 has been released as a fix to the previously released SQLite <a href=\"\/\/local.brightwhiz\/tag\/tools\/\" target=\"_blank\" rel=\"noopener\">tool<\/a>. This update is known as the PI release (3.14).<\/p>\n<p>SQLite software library is designed as a drop-in replacement, server-less transactional database engine. The <a href=\"\/\/local.brightwhiz\/tag\/sql\/\" target=\"_blank\" rel=\"noopener\">SQL<\/a> <a href=\"\/\/local.brightwhiz\/tag\/database\/\" target=\"_blank\" rel=\"noopener\">database<\/a> engine is self-contained and requires zero configurations. The library is <a href=\"\/\/local.brightwhiz\/tag\/open-source\/\" target=\"_blank\" rel=\"noopener\">open source<\/a> and cross-platform and sits in the public domain.<!--more--><\/p>\n<h2>What&#8217;s new in SQLite Release 3.14.1<\/h2>\n<p>SQLite Release 3.14.1 fixes the page-cache &#8220;truncate&#8221; and results in a performance enhancement. Changes in version 3.14 include a few bug fixes such as the ALTER TABLE bug where descending indexes where being corrupted when adding a column in the legacy file format.<\/p>\n<p>There was also a NULL pointer dereference crash when a WHERE clause references a non-existent collating sequence. A performance regression in the ORDER BY LIMIT has also been fixed.<\/p>\n<p>There are also several new features within the json1_extension. There is a new database hash utility now in the release. There is an improved algorithm for running queries with both an ORDER BY and a LIMIT.<\/p>\n<p>The CSV virtual table for reading RFC 4180 formatted comma-separated value files has been added in this release.<\/p>\n<p>There is also an improvement within the query planner. This helps the OR optimization on virtual tables even if one or more of the disjuncts use the LIKE, GLOB, REGEXP, MATCH operators.<\/p>\n<p>To see the whole list of changes you can visit the release log page <a href=\"https:\/\/www.sqlite.org\/releaselog\/3_14_1.html\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A minor update SQLite Release 3.14.1 has been released as a fix to the previously released SQLite tool. This update is known as the PI release (3.14). SQLite software library&#8230;<\/p>\n","protected":false},"author":1,"featured_media":3009,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,28,16],"tags":[111,180,184,220,350,424,433,449,549,551],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQLite Release 3.14.1 now Available for Download<\/title>\n<meta name=\"description\" content=\"A new version of SQLite Release 3.14.1 also known as the PI release has been announced for general availability and come with several updates and fixes.\" \/>\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-release-3-14-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQLite Release 3.14.1 now Available for Download\" \/>\n<meta property=\"og:description\" content=\"A new version of SQLite Release 3.14.1 also known as the PI release has been announced for general availability and come with several updates and fixes.\" \/>\n<meta property=\"og:url\" content=\"http:\/\/local.brightwhiz\/sqlite-release-3-14-1\/\" \/>\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-08-12T13:30:59+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2016\/08\/SQLite-Release-3.14.1.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-release-3-14-1\/#article\",\"isPartOf\":{\"@id\":\"http:\/\/local.brightwhiz\/sqlite-release-3-14-1\/\"},\"author\":{\"name\":\"Michael Bright\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32\"},\"headline\":\"SQLite Release 3.14.1 With Several Enhancements now Available\",\"datePublished\":\"2016-08-12T13:30:59+00:00\",\"dateModified\":\"2016-08-12T13:30:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/local.brightwhiz\/sqlite-release-3-14-1\/\"},\"wordCount\":245,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\/\/local.brightwhiz\/#organization\"},\"image\":{\"@id\":\"http:\/\/local.brightwhiz\/sqlite-release-3-14-1\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2016\/08\/SQLite-Release-3.14.1.jpg\",\"keywords\":[\"C++\",\"Database\",\"Debugging\",\"Embedded\",\"Libraries\",\"Open Source\",\"Optimization\",\"Performance\",\"SQL\",\"SQLite\"],\"articleSection\":[\"News\",\"Software\",\"Technology\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\/\/local.brightwhiz\/sqlite-release-3-14-1\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/local.brightwhiz\/sqlite-release-3-14-1\/\",\"url\":\"http:\/\/local.brightwhiz\/sqlite-release-3-14-1\/\",\"name\":\"SQLite Release 3.14.1 now Available for Download\",\"isPartOf\":{\"@id\":\"http:\/\/local.brightwhiz\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/local.brightwhiz\/sqlite-release-3-14-1\/#primaryimage\"},\"image\":{\"@id\":\"http:\/\/local.brightwhiz\/sqlite-release-3-14-1\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2016\/08\/SQLite-Release-3.14.1.jpg\",\"datePublished\":\"2016-08-12T13:30:59+00:00\",\"dateModified\":\"2016-08-12T13:30:59+00:00\",\"description\":\"A new version of SQLite Release 3.14.1 also known as the PI release has been announced for general availability and come with several updates and fixes.\",\"breadcrumb\":{\"@id\":\"http:\/\/local.brightwhiz\/sqlite-release-3-14-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/local.brightwhiz\/sqlite-release-3-14-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/local.brightwhiz\/sqlite-release-3-14-1\/#primaryimage\",\"url\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2016\/08\/SQLite-Release-3.14.1.jpg\",\"contentUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2016\/08\/SQLite-Release-3.14.1.jpg\",\"width\":1200,\"height\":630,\"caption\":\"SQLite Release 3.14.1\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/local.brightwhiz\/sqlite-release-3-14-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/local.brightwhiz\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQLite Release 3.14.1 With Several Enhancements now Available\"}]},{\"@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:\/\/x.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 Release 3.14.1 now Available for Download","description":"A new version of SQLite Release 3.14.1 also known as the PI release has been announced for general availability and come with several updates and fixes.","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-release-3-14-1\/","og_locale":"en_US","og_type":"article","og_title":"SQLite Release 3.14.1 now Available for Download","og_description":"A new version of SQLite Release 3.14.1 also known as the PI release has been announced for general availability and come with several updates and fixes.","og_url":"http:\/\/local.brightwhiz\/sqlite-release-3-14-1\/","og_site_name":"Brightwhiz.com","article_publisher":"https:\/\/www.facebook.com\/brightwhiz\/","article_published_time":"2016-08-12T13:30:59+00:00","og_image":[{"width":1200,"height":630,"url":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2016\/08\/SQLite-Release-3.14.1.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-release-3-14-1\/#article","isPartOf":{"@id":"http:\/\/local.brightwhiz\/sqlite-release-3-14-1\/"},"author":{"name":"Michael Bright","@id":"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32"},"headline":"SQLite Release 3.14.1 With Several Enhancements now Available","datePublished":"2016-08-12T13:30:59+00:00","dateModified":"2016-08-12T13:30:59+00:00","mainEntityOfPage":{"@id":"http:\/\/local.brightwhiz\/sqlite-release-3-14-1\/"},"wordCount":245,"commentCount":0,"publisher":{"@id":"http:\/\/local.brightwhiz\/#organization"},"image":{"@id":"http:\/\/local.brightwhiz\/sqlite-release-3-14-1\/#primaryimage"},"thumbnailUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2016\/08\/SQLite-Release-3.14.1.jpg","keywords":["C++","Database","Debugging","Embedded","Libraries","Open Source","Optimization","Performance","SQL","SQLite"],"articleSection":["News","Software","Technology"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/local.brightwhiz\/sqlite-release-3-14-1\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/local.brightwhiz\/sqlite-release-3-14-1\/","url":"http:\/\/local.brightwhiz\/sqlite-release-3-14-1\/","name":"SQLite Release 3.14.1 now Available for Download","isPartOf":{"@id":"http:\/\/local.brightwhiz\/#website"},"primaryImageOfPage":{"@id":"http:\/\/local.brightwhiz\/sqlite-release-3-14-1\/#primaryimage"},"image":{"@id":"http:\/\/local.brightwhiz\/sqlite-release-3-14-1\/#primaryimage"},"thumbnailUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2016\/08\/SQLite-Release-3.14.1.jpg","datePublished":"2016-08-12T13:30:59+00:00","dateModified":"2016-08-12T13:30:59+00:00","description":"A new version of SQLite Release 3.14.1 also known as the PI release has been announced for general availability and come with several updates and fixes.","breadcrumb":{"@id":"http:\/\/local.brightwhiz\/sqlite-release-3-14-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/local.brightwhiz\/sqlite-release-3-14-1\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/local.brightwhiz\/sqlite-release-3-14-1\/#primaryimage","url":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2016\/08\/SQLite-Release-3.14.1.jpg","contentUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2016\/08\/SQLite-Release-3.14.1.jpg","width":1200,"height":630,"caption":"SQLite Release 3.14.1"},{"@type":"BreadcrumbList","@id":"http:\/\/local.brightwhiz\/sqlite-release-3-14-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/local.brightwhiz\/"},{"@type":"ListItem","position":2,"name":"SQLite Release 3.14.1 With Several Enhancements now Available"}]},{"@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:\/\/x.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\/3008"}],"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=3008"}],"version-history":[{"count":0,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/posts\/3008\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/media\/3009"}],"wp:attachment":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/media?parent=3008"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/categories?post=3008"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/tags?post=3008"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}