{"id":32210,"date":"2019-10-31T21:45:40","date_gmt":"2019-10-31T18:45:40","guid":{"rendered":"https:\/\/prohoster.info\/blog\/reliz-subd-sqlite-3-28\/"},"modified":"2019-10-31T21:45:40","modified_gmt":"2019-10-31T18:45:40","slug":"reliz-subd-sqlite-3-28","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sv\/blog\/news\/reliz-subd-sqlite-3-28","title":{"rendered":"Utgivning av databashanteraren SQLite 3.28","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><noindex><a rel=\"nofollow\" href=\"https:\/\/www.mail-archive.com\/sqlite-announce@sqlite.org\/msg00078.html\">Presenteras<\/a><\/noindex> utgivning <noindex><a rel=\"nofollow\" href=\"http:\/\/sqlite.org\/\">SQLite 3.28.0<\/a><\/noindex>, en l\u00e4ttviktsdatabas som presenteras som ett plugin-bibliotek. Koden f\u00f6r SQLite distribueras som allm\u00e4n egendom (public domain), vilket betyder att den kan anv\u00e4ndas utan begr\u00e4nsningar och kostnadsfritt f\u00f6r alla \u00e4ndam\u00e5l. Utvecklarna av SQLite f\u00e5r ekonomiskt st\u00f6d fr\u00e5n ett s\u00e4rskilt konsortium, som inkluderar f\u00f6retag som Adobe, Oracle, Mozilla, Bentley och Bloomberg. <\/p>\n<p>Huvud <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/releaselog\/3_28_0.html\">f\u00f6r<\/a><\/noindex>:<\/p>\n<ul>\n<li class=\"l\"> <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html\">Ut\u00f6kade<\/a><\/noindex>  f\u00f6nsterfunktioner (window-funktioner eller analytiska funktioner som g\u00f6r det m\u00f6jligt att f\u00f6r varje rad i fr\u00e5gan utf\u00f6ra ber\u00e4kningar med hj\u00e4lp av andra rader): st\u00f6d f\u00f6r uttryck har lagts till <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html#wexcls\">EXCLUDE<\/a><\/noindex>, m\u00f6jligheten att anv\u00e4nda <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html#wchaining\">kedjor<\/a><\/noindex> f\u00f6nsterfunktioner (ett f\u00f6nster definieras inom ett annat), s\u00e4kerst\u00e4lls <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html#grouptype\">st\u00f6d f\u00f6r<\/a><\/noindex> gruppering med hj\u00e4lp av GROUP-uttryck, och RANGE-begr\u00e4nsningar har implementerats  <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html#exprrange\">PRECEDING<\/a><\/noindex> och <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html#exprrange\">FOLLOWING<\/a><\/noindex>;\n<li class=\"l\"> F\u00f6rb\u00e4ttrad implementering av kommandot &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/lang_vacuum.html#vacuuminto\">VACUUM INTO<\/a><\/noindex>&#171;, som nu kan anv\u00e4ndas med databaser som \u00e4r tillg\u00e4ngliga i skrivskyddat l\u00e4ge;\n<li class=\"l\"> Nya optimeringar av f\u00f6rfr\u00e5gningar har lagts till: <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/optoverview.html#like_opt\">Accelererad<\/a><\/noindex> utf\u00f6randet av LIKE-uttryck tillsammans med nyckelordet ESCAPE och med aktiverat l\u00e4ge &#171;PRAGMA case_sensitive_like&#187;. Om det finns <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/partialindex.html\">partiellt index<\/a><\/noindex> har \u00f6verfl\u00f6diga kontroller av uppenbart sanna villkor som anges i WHERE-uttrycket uteslutits;\n<li class=\"l\"> Ett kommando har lagts till i CLI-gr\u00e4nssnittet &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/cli.html#param\">.parameter<\/a><\/noindex>&#187; f\u00f6r att ange <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/lang_expr.html#varparam\">bifogade substitut<\/a><\/noindex> (masker som kan anv\u00e4ndas i alla SQL-uttryck). I kommandot &#171;.archive&#187; har alternativet &#171;&#8212;update&#187; omarbetats, vilket nu utel\u00e4mnar of\u00f6r\u00e4ndrade filer som redan finns i arkivet, och alternativet &#171;&#8212;insert&#187; har lagts till f\u00f6r att inkludera filer i arkivet;\n<li class=\"l\"> Ett till\u00e4gg har lagts till <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/src\/file\/ext\/misc\/fossildelta.c\">fossildelta.c<\/a><\/noindex>, som g\u00f6r det m\u00f6jligt att skapa, till\u00e4mpa och analysera <noindex><a rel=\"nofollow\" href=\"https:\/\/www.fossil-scm.org\/fossil\/doc\/trunk\/www\/delta_format.wiki\">formatet<\/a><\/noindex> delta-f\u00f6r\u00e4ndringar Fossil, till\u00e4mpligt i RBU-till\u00e4gget;\n<li class=\"l\"> Tillf\u00f6rlitligheten vid arbete med skadade databasfiler har \u00f6kat;\n<li class=\"l\"> Ett spegel av projektets repository har startats p\u00e5 <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sqlite\/sqlite\">GitHub<\/a><\/noindex> (huvud <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/src\">arkiv<\/a><\/noindex> st\u00f6ds med hj\u00e4lp av versionshanteringssystemet <noindex><a rel=\"nofollow\" href=\"https:\/\/www.fossil-scm.org\/\">Fossil<\/a><\/noindex>, skapat av SQLite:s f\u00f6rfattare).\n<\/ul>\n<p><noindex><a rel=\"nofollow\" name=\"link\"><\/a><\/noindex><\/p>\n<p>K\u00e4lla: <a \ncontent=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=50558\">opennet.ru<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0440\u0435\u043b\u0438\u0437 SQLite 3.28.0, \u043b\u0435\u0433\u043a\u043e\u0432\u0435\u0441\u043d\u043e\u0439 \u0421\u0423\u0411\u0414, \u043e\u0444\u043e\u0440\u043c\u043b\u0435\u043d\u043d\u043e\u0439 \u0432 \u0432\u0438\u0434\u0435 \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0430\u0435\u043c\u043e\u0439 \u0431\u0438\u0431\u043b\u0438\u043e\u0442\u0435\u043a\u0438. \u041a\u043e\u0434 SQLite \u0440\u0430\u0441\u043f\u0440\u043e\u0441\u0442\u0440\u0430\u043d\u044f\u0435\u0442\u0441\u044f \u043a\u0430\u043a \u043e\u0431\u0449\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u043e\u0435 \u0434\u043e\u0441\u0442\u043e\u044f\u043d\u0438\u0435 (public domain), \u0442.\u0435. \u043c\u043e\u0436\u0435\u0442 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c\u0441\u044f \u0431\u0435\u0437 \u043e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u0439 \u0438 \u0431\u0435\u0437\u0432\u043e\u0437\u043c\u0435\u0437\u0434\u043d\u043e \u0432 \u043b\u044e\u0431\u044b\u0445 \u0446\u0435\u043b\u044f\u0445. \u0424\u0438\u043d\u0430\u043d\u0441\u043e\u0432\u0443\u044e \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0443 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u043e\u0432 SQLite \u043e\u0441\u0443\u0449\u0435\u0441\u0442\u0432\u043b\u044f\u0435\u0442 \u0441\u043f\u0435\u0446\u0438\u0430\u043b\u044c\u043d\u043e \u0441\u043e\u0437\u0434\u0430\u043d\u043d\u044b\u0439 \u043a\u043e\u043d\u0441\u043e\u0440\u0446\u0438\u0443\u043c, \u0432 \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0432\u0445\u043e\u0434\u044f\u0442 \u0442\u0430\u043a\u0438\u0435 \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u0438, \u043a\u0430\u043a Adobe, Oracle, Mozilla, Bentley \u0438 Bloomberg. \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f: \u0420\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u044b \u043e\u043a\u043e\u043d\u043d\u044b\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 (window-\u0444\u0443\u043d\u043a\u0446\u0438\u0438 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-32210","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.4 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0440\u0435\u043b\u0438\u0437 SQLite.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/sv\/blog\/news\/reliz-subd-sqlite-3-28\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.4\" \/>\n\t\t<meta property=\"og:locale\" content=\"sv_SE\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u0420\u0435\u043b\u0438\u0437 \u0421\u0423\u0411\u0414 SQLite 3.28 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0440\u0435\u043b\u0438\u0437 SQLite.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sv\/blog\/news\/reliz-subd-sqlite-3-28\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2019-10-31T18:45:40+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2019-10-31T18:45:40+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Utg\u00e5van av databashanteringssystemet SQLite 3.28 | ProHoster","description":"SQLite-versionen har presenterats.","canonical_url":"https:\/\/prohoster.info\/sv\/blog\/news\/reliz-subd-sqlite-3-28","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sv_SE","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0420\u0435\u043b\u0438\u0437 \u0421\u0423\u0411\u0414 SQLite 3.28 | ProHoster","og:description":"\u041f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0440\u0435\u043b\u0438\u0437 SQLite.","og:url":"https:\/\/prohoster.info\/sv\/blog\/news\/reliz-subd-sqlite-3-28","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2019-10-31T18:45:40+00:00","article:modified_time":"2019-10-31T18:45:40+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"32210","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-01-21 09:48:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-03-01 03:02:47","updated":"2026-01-21 09:48:19","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/posts\/32210","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/comments?post=32210"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/posts\/32210\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/media?parent=32210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/categories?post=32210"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/tags?post=32210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}