{"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\/da\/blog\/news\/reliz-subd-sqlite-3-28","title":{"rendered":"Udgivelse af SQLite-databasesystem 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\">Pr\u00e6senteret<\/a><\/noindex> udgivelse <noindex><a rel=\"nofollow\" href=\"http:\/\/sqlite.org\/\">SQLite 3.28.0<\/a><\/noindex>, en letv\u00e6gts databasesystem, der er udformet som et tilslutningsbibliotek. Koden til SQLite distribueres som offentlig dom\u00e6ne (public domain), det vil sige, at den kan bruges uden begr\u00e6nsninger og gratis til enhver form for form\u00e5l. Den finansielle st\u00f8tte til SQLite-udviklerne ydes af et konsortium, som er oprettet specielt til dette form\u00e5l og omfatter virksomheder som Adobe, Oracle, Mozilla, Bentley og Bloomberg. <\/p>\n<p>Vigtige <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/releaselog\/3_28_0.html\">Optimeringer<\/a><\/noindex>:<\/p>\n<ul>\n<li class=\"l\"> <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html\">Udvidet<\/a><\/noindex>  vinduesfunktioner (window-funktioner eller analytiske funktioner, der tillader at udf\u00f8re beregninger for hver r\u00e6kke af foresp\u00f8rgslen ved at bruge andre r\u00e6kker): tilf\u00f8jet underst\u00f8ttelse af udtryk <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html#wexcls\">EXCLUDE<\/a><\/noindex>, muligheden for at bruge <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html#wchaining\">k\u00e6der<\/a><\/noindex> vinduesfunktioner (et vindue defineres i omr\u00e5det af et andet), og sikret <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html#grouptype\">underst\u00f8ttelse af<\/a><\/noindex> gruppering ved hj\u00e6lp af GROUP-udtryk, og implementeret RANGE-begr\u00e6nsninger  <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html#exprrange\">PRECEDING<\/a><\/noindex> og <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html#exprrange\">FOLLOWING<\/a><\/noindex>;\n<li class=\"l\"> En forbedret implementering af kommandoen &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/lang_vacuum.html#vacuuminto\">VACUUM INTO<\/a><\/noindex>&#171;, som nu kan bruges med databaser, der kun er tilg\u00e6ngelige i skrivebeskyttet tilstand;\n<li class=\"l\"> Tilf\u00f8jet nye optimeringer af foresp\u00f8rgsler: <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/optoverview.html#like_opt\">Hastigheden for<\/a><\/noindex> funktionen af LIKE-udtryk sammen med n\u00f8gleordet ESCAPE og n\u00e5r &#171;PRAGMA case_sensitive_like&#187; er aktiveret. Hvis der er tilstede <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/partialindex.html\">delvis indeks<\/a><\/noindex> ekskluderet un\u00f8dvendige kontrol af \u00e5benlyst sande betingelser angivet i WHERE-udtrykket;\n<li class=\"l\"> En kommando &#171; tilf\u00f8jet til CLI-gr\u00e6nsefladen,<noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/cli.html#param\">.parameter<\/a><\/noindex>&#187; for at angive <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/lang_expr.html#varparam\">vedh\u00e6ftede pladsholdere<\/a><\/noindex> (masker, der kan bruges i alle SQL-udtryk). I kommandoen &#171;.archive&#187; er indstillingen &#171;&#8212;update&#187; blevet \u00e6ndret, s\u00e5 den nu springer over u\u00e6ndrede filer, der allerede findes i arkivet, og der er tilf\u00f8jet en indstilling &#171;&#8212;insert&#187; for at inkludere filer i arkivet;\n<li class=\"l\"> Tilf\u00f8jet udvidelse <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/src\/file\/ext\/misc\/fossildelta.c\">fossildelta.c<\/a><\/noindex>, som muligg\u00f8r at oprette, anvende og analysere <noindex><a rel=\"nofollow\" href=\"https:\/\/www.fossil-scm.org\/fossil\/doc\/trunk\/www\/delta_format.wiki\">formatet<\/a><\/noindex> delta-\u00e6ndringer Fossil, anvendt i RBU-udvidelsen;\n<li class=\"l\"> \u00d8get p\u00e5lidelighed i arbejdet med beskadigede databasefiler;\n<li class=\"l\"> Et spejl af projektets repository er startet p\u00e5 <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sqlite\/sqlite\">GitHub<\/a><\/noindex> (prim\u00e6r <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/src\">repository<\/a><\/noindex> underst\u00f8ttet ved hj\u00e6lp af editionskontrolsystemet <noindex><a rel=\"nofollow\" href=\"https:\/\/www.fossil-scm.org\/\">Fossil<\/a><\/noindex>, skabt af forfatteren af SQLite).\n<\/ul>\n<p><noindex><a rel=\"nofollow\" name=\"link\"><\/a><\/noindex><\/p>\n<p>Kilde: <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.3 - 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\/da\/blog\/news\/reliz-subd-sqlite-3-28\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"da_DK\" \/>\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\/da\/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\udd47Udgivelse af DBMS SQLite 3.28 | ProHoster","description":"SQLite-udgaven er pr\u00e6senteret.","canonical_url":"https:\/\/prohoster.info\/da\/blog\/news\/reliz-subd-sqlite-3-28","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"da_DK","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\/da\/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\/da\/wp-json\/wp\/v2\/posts\/32210","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/comments?post=32210"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/posts\/32210\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/media?parent=32210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/categories?post=32210"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/tags?post=32210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}