{"id":7584,"date":"2019-02-12T02:18:53","date_gmt":"2019-02-12T07:18:53","guid":{"rendered":"http:\/\/local.brightwhiz\/?p=7584"},"modified":"2019-02-12T02:18:53","modified_gmt":"2019-02-12T07:18:53","slug":"sqlite-release-3-27-1-download","status":"publish","type":"post","link":"http:\/\/local.brightwhiz\/sqlite-release-3-27-1-download\/","title":{"rendered":"SQLite Release 3.27.1 Available for Download"},"content":{"rendered":"<p>SQLite Release 3.27.1 has been announced for general availability. It comes with a couple of bug fixes and changes carried forward from the previous release.<\/p>\n<p><a href=\"http:\/\/local.brightwhiz\/tag\/sqlite\/\">SQLite<\/a> is an open source,\u00a0 self-contained, transactional, zero-configuration, serverless <a href=\"http:\/\/local.brightwhiz\/tag\/sql\/\">SQL<\/a> <a href=\"http:\/\/local.brightwhiz\/tag\/database\/\">database<\/a> engine. It is implemented as an in-process library with code written in C that is in the public domain. This means you can freely use it for commercial and personal projects alike.<\/p>\n<p>This new version fixes a bug in the query optimizer dealing with an adverse interaction between the OR optimization and the optimization that tries to use values read directly from an expression index instead of recomputing the expression.<\/p>\n<p>It also includes other changes carried forward from the previous release with details that can be found <a href=\"https:\/\/www.sqlite.org\/releaselog\/3_27_1.html\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n<p>If you are not interested in those details you can simply get yourself a copy of SQLite Release 3.27.1 from the download page <a href=\"https:\/\/www.sqlite.org\/download.html\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQLite Release 3.27.1 has been announced for general availability. It comes with a couple of bug fixes and changes carried forward from the previous release. SQLite is an open source,\u00a0&#8230;<\/p>\n","protected":false},"author":1,"featured_media":7585,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25,13,16],"tags":[111,164,177,180,220,350,424,433,449,543,549,551,591],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQLite Release 3.27.1 has Been Announced for General Availability<\/title>\n<meta name=\"description\" content=\"SQLite Release 3.27.1 the open source serverless database engine has been announced and is now available for production use mainly as a bug fix update.\" \/>\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-27-1-download\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQLite Release 3.27.1 has Been Announced for General Availability\" \/>\n<meta property=\"og:description\" content=\"SQLite Release 3.27.1 the open source serverless database engine has been announced and is now available for production use mainly as a bug fix update.\" \/>\n<meta property=\"og:url\" content=\"http:\/\/local.brightwhiz\/sqlite-release-3-27-1-download\/\" \/>\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=\"2019-02-12T07:18:53+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2019\/02\/peacock-feather-sqlite.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-27-1-download\/#article\",\"isPartOf\":{\"@id\":\"http:\/\/local.brightwhiz\/sqlite-release-3-27-1-download\/\"},\"author\":{\"name\":\"Michael Bright\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32\"},\"headline\":\"SQLite Release 3.27.1 Available for Download\",\"datePublished\":\"2019-02-12T07:18:53+00:00\",\"dateModified\":\"2019-02-12T07:18:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/local.brightwhiz\/sqlite-release-3-27-1-download\/\"},\"wordCount\":151,\"publisher\":{\"@id\":\"http:\/\/local.brightwhiz\/#organization\"},\"image\":{\"@id\":\"http:\/\/local.brightwhiz\/sqlite-release-3-27-1-download\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2019\/02\/peacock-feather-sqlite.jpg\",\"keywords\":[\"C++\",\"Cross Platform\",\"Data\",\"Database\",\"Embedded\",\"Libraries\",\"Open Source\",\"Optimization\",\"Performance\",\"Software Design\",\"SQL\",\"SQLite\",\"Tools\"],\"articleSection\":[\"Libraries\",\"News\",\"Technology\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/local.brightwhiz\/sqlite-release-3-27-1-download\/\",\"url\":\"http:\/\/local.brightwhiz\/sqlite-release-3-27-1-download\/\",\"name\":\"SQLite Release 3.27.1 has Been Announced for General Availability\",\"isPartOf\":{\"@id\":\"http:\/\/local.brightwhiz\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/local.brightwhiz\/sqlite-release-3-27-1-download\/#primaryimage\"},\"image\":{\"@id\":\"http:\/\/local.brightwhiz\/sqlite-release-3-27-1-download\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2019\/02\/peacock-feather-sqlite.jpg\",\"datePublished\":\"2019-02-12T07:18:53+00:00\",\"dateModified\":\"2019-02-12T07:18:53+00:00\",\"description\":\"SQLite Release 3.27.1 the open source serverless database engine has been announced and is now available for production use mainly as a bug fix update.\",\"breadcrumb\":{\"@id\":\"http:\/\/local.brightwhiz\/sqlite-release-3-27-1-download\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/local.brightwhiz\/sqlite-release-3-27-1-download\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/local.brightwhiz\/sqlite-release-3-27-1-download\/#primaryimage\",\"url\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2019\/02\/peacock-feather-sqlite.jpg\",\"contentUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2019\/02\/peacock-feather-sqlite.jpg\",\"width\":1200,\"height\":630,\"caption\":\"SQLite Release 3.27.1\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/local.brightwhiz\/sqlite-release-3-27-1-download\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/local.brightwhiz\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQLite Release 3.27.1 Available for Download\"}]},{\"@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.27.1 has Been Announced for General Availability","description":"SQLite Release 3.27.1 the open source serverless database engine has been announced and is now available for production use mainly as a bug fix update.","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-27-1-download\/","og_locale":"en_US","og_type":"article","og_title":"SQLite Release 3.27.1 has Been Announced for General Availability","og_description":"SQLite Release 3.27.1 the open source serverless database engine has been announced and is now available for production use mainly as a bug fix update.","og_url":"http:\/\/local.brightwhiz\/sqlite-release-3-27-1-download\/","og_site_name":"Brightwhiz.com","article_publisher":"https:\/\/www.facebook.com\/brightwhiz\/","article_published_time":"2019-02-12T07:18:53+00:00","og_image":[{"width":1200,"height":630,"url":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2019\/02\/peacock-feather-sqlite.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-27-1-download\/#article","isPartOf":{"@id":"http:\/\/local.brightwhiz\/sqlite-release-3-27-1-download\/"},"author":{"name":"Michael Bright","@id":"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32"},"headline":"SQLite Release 3.27.1 Available for Download","datePublished":"2019-02-12T07:18:53+00:00","dateModified":"2019-02-12T07:18:53+00:00","mainEntityOfPage":{"@id":"http:\/\/local.brightwhiz\/sqlite-release-3-27-1-download\/"},"wordCount":151,"publisher":{"@id":"http:\/\/local.brightwhiz\/#organization"},"image":{"@id":"http:\/\/local.brightwhiz\/sqlite-release-3-27-1-download\/#primaryimage"},"thumbnailUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2019\/02\/peacock-feather-sqlite.jpg","keywords":["C++","Cross Platform","Data","Database","Embedded","Libraries","Open Source","Optimization","Performance","Software Design","SQL","SQLite","Tools"],"articleSection":["Libraries","News","Technology"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"http:\/\/local.brightwhiz\/sqlite-release-3-27-1-download\/","url":"http:\/\/local.brightwhiz\/sqlite-release-3-27-1-download\/","name":"SQLite Release 3.27.1 has Been Announced for General Availability","isPartOf":{"@id":"http:\/\/local.brightwhiz\/#website"},"primaryImageOfPage":{"@id":"http:\/\/local.brightwhiz\/sqlite-release-3-27-1-download\/#primaryimage"},"image":{"@id":"http:\/\/local.brightwhiz\/sqlite-release-3-27-1-download\/#primaryimage"},"thumbnailUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2019\/02\/peacock-feather-sqlite.jpg","datePublished":"2019-02-12T07:18:53+00:00","dateModified":"2019-02-12T07:18:53+00:00","description":"SQLite Release 3.27.1 the open source serverless database engine has been announced and is now available for production use mainly as a bug fix update.","breadcrumb":{"@id":"http:\/\/local.brightwhiz\/sqlite-release-3-27-1-download\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/local.brightwhiz\/sqlite-release-3-27-1-download\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/local.brightwhiz\/sqlite-release-3-27-1-download\/#primaryimage","url":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2019\/02\/peacock-feather-sqlite.jpg","contentUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2019\/02\/peacock-feather-sqlite.jpg","width":1200,"height":630,"caption":"SQLite Release 3.27.1"},{"@type":"BreadcrumbList","@id":"http:\/\/local.brightwhiz\/sqlite-release-3-27-1-download\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/local.brightwhiz\/"},{"@type":"ListItem","position":2,"name":"SQLite Release 3.27.1 Available for Download"}]},{"@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\/7584"}],"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=7584"}],"version-history":[{"count":0,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/posts\/7584\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/media\/7585"}],"wp:attachment":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/media?parent=7584"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/categories?post=7584"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/tags?post=7584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}