{"id":82740,"date":"2020-05-24T19:42:08","date_gmt":"2020-05-24T17:42:08","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/reliz-subd-sqlite-3-32-proekt-duckdb-razvivaet-variant-sqlite-dlya-analiticheskih-zaprosov"},"modified":"2020-05-24T19:42:08","modified_gmt":"2020-05-24T17:42:08","slug":"reliz-subd-sqlite-3-32-proekt-duckdb-razvivaet-variant-sqlite-dlya-analiticheskih-zaprosov","status":"publish","type":"post","link":"https:\/\/prohoster.info\/da\/blog\/news\/reliz-subd-sqlite-3-32-proekt-duckdb-razvivaet-variant-sqlite-dlya-analiticheskih-zaprosov","title":{"rendered":"Udgivelse af DBMS SQLite 3.32. Projektet DuckDB udvikler en variant af SQLite til analytiske foresp\u00f8rgsler","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/changes.html\">Publiceret<\/a><\/noindex> udgivelse <noindex><a rel=\"nofollow\" href=\"http:\/\/sqlite.org\/\">SQLite 3.32.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_32_0.html\">Optimeringer<\/a><\/noindex>:<\/p>\n<ul>\n<li class=\"l\"> Implementeret <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/lang_analyze.html#approx\">approximativ<\/a><\/noindex> en variant af ANALYZE-kommandoen, der g\u00f8r det muligt at omg\u00e5s fuld scanning af indekser i meget store databaser ved hj\u00e6lp af delvis indsamling af statistik. Begr\u00e6nsningen for antallet af r\u00e6kker under scanning af et enkelt indeks angives med den nye direktiv &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/pragma.html#pragma_analysis_limit\">PRAGMA analysis_limit<\/a><\/noindex>&#171;.\n<li class=\"l\"> En ny virtuel tabel &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/bytecodevtab.html\">bytecode<\/a><\/noindex>&#171;, som indeholder oplysninger om <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/opcode.html\">bytecode<\/a><\/noindex> af forudforberedte udtryk (<noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/c3ref\/stmt.html\">prepared statement<\/a><\/noindex>).\n<li class=\"l\"> Tilf\u00f8jet VFS-lag <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/cksumvfs.html\">checksum<\/a><\/noindex>, der tilf\u00f8jer 8-byte kontrolsummer til slutningen af hver datasektion i databasen og kontrollerer dem ved hver l\u00e6sning fra databasen. Dette lag muligg\u00f8r at opdage databasens beskadigelse som f\u00f8lge af tilf\u00e6ldig forvridning af bits i lagringsenheder.\n<li class=\"l\"> Tilf\u00f8jet en ny SQL-funktion <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/lang_corefunc.html#iif\">iif(X,Y,Z)<\/a><\/noindex>, der returnerer v\u00e6rdien Y, hvis udtrykket X er sandt, eller Z ellers.\n<li class=\"l\"> I INSERT- og UPDATE-udtryk anvendes nu altid <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/src\/info\/86ba67afafded936\">typeforbindelse<\/a><\/noindex> af kolonner (<noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/datatype3.html#affinity\">column affinity<\/a><\/noindex>) f\u00f8r betingelserne i blokken <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/lang_createtable.html#ckconst\">CHECK<\/a><\/noindex>.\n<li class=\"l\"> Gr\u00e6nsen for antallet af parametre er h\u00e6vet fra 999 til 32766.\n<li class=\"l\"> Tilf\u00f8jet udvidelse <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/uintcseq.html\">UINT kollationsr\u00e6kkef\u00f8lge<\/a><\/noindex> med implementering af sortering af sekvenser, der tager h\u00f8jde for heltal i teksten for at sortere denne tekst i numerisk r\u00e6kkef\u00f8lge.\n<li class=\"l\"> I kommandolinjegr\u00e6nsefladen er der tilf\u00f8jet muligheder til kommandoen &#171;.import&#187;: &#171;&#8212;csv&#187;, &#171;&#8212;ascii&#187; og &#171;&#8212;skip&#187;. I kommandoen &#171;.dump&#187; er det nu tilladt at bruge flere LIKE-m\u00f8nstre, der sammenfletter alle tabeller, der opfylder de angivne masker. Kommandoen &#171;.oom&#187; er tilf\u00f8jet til debug-versioner. Der er tilf\u00f8jet en mulighed &#171;&#8212;bom&#187; til kommandoerne &#171;.excel&#187;, &#171;.output&#187; og &#171;.once&#187;. Der er tilf\u00f8jet en mulighed &#171;&#8212;schema&#187; til kommandoen &#171;.filectrl&#187;.\n<li class=\"l\"> Det angivne udtryk med operatoren LIKE ESCAPE overstyrer nu pladsholdertegnene, hvilket svarer til opf\u00f8relsen af PostgreSQL.\n<\/ul>\n<p>Derudover kan man bem\u00e6rke udviklingen af den nye DBMS <noindex><a rel=\"nofollow\" href=\"https:\/\/www.duckdb.org\/\">DuckDB<\/a><\/noindex>, hvor en variant af SQLite udvikles, optimeret til udf\u00f8relse af <noindex><a rel=\"nofollow\" href=\"https:\/\/ru.wikipedia.org\/wiki\/OLAP\">analytiske foresp\u00f8rgsler<\/a><\/noindex>.<br \/>\nUdover shell-koden fra SQLite anvender projektet en parser fra PostgreSQL, der er adskilt i et eget bibliotek, Date Math-komponenten fra <noindex><a rel=\"nofollow\" href=\"https:\/\/www.monetdb.org\/\">MonetDB<\/a><\/noindex>, sin egen implementering af vinduesfunktioner (baseret p\u00e5 Segment Tree Aggregation-algoritmen), en vektoriseret foresp\u00f8rgselsmotor (baseret p\u00e5 Hyper-Pipelining Query Execution-algoritmen), og en regul\u00e6r udtryksbehandler baseret p\u00e5 biblioteket <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=25765\">RE2<\/a><\/noindex>, egne foresp\u00f8rgselsoptimeringsv\u00e6rkt\u00f8jer og MVCC-mekanisme til h\u00e5ndtering af samtidige opgaver (Multi-Version Concurrency Control).<br \/>\nProjektkode <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/cwida\/duckdb\">distribueres<\/a><\/noindex> under MIT-licensen. Udviklingen er stadig p\u00e5 fase <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/cwida\/duckdb\/releases\">af dannelse<\/a><\/noindex> af eksperimentelle udgivelser.<\/p>\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=53018\">opennet.ru<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0440\u0435\u043b\u0438\u0437 SQLite 3.32.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\u0435\u0430\u043b\u0438\u0437\u043e\u0432\u0430\u043d \u0430\u043f\u043f\u0440\u043e\u043a\u0441\u0438\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u0439 \u0432\u0430\u0440\u0438\u0430\u043d\u0442 \u043a\u043e\u043c\u0430\u043d\u0434\u044b [&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-82740","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=\"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0440\u0435\u043b\u0438\u0437 SQLite 3.32.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.\" \/>\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-32-proekt-duckdb-razvivaet-variant-sqlite-dlya-analiticheskih-zaprosov\" \/>\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.32. \u041f\u0440\u043e\u0435\u043a\u0442 DuckDB \u0440\u0430\u0437\u0432\u0438\u0432\u0430\u0435\u0442 \u0432\u0430\u0440\u0438\u0430\u043d\u0442 SQLite \u0434\u043b\u044f \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0445 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0440\u0435\u043b\u0438\u0437 SQLite 3.32.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.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/da\/blog\/news\/reliz-subd-sqlite-3-32-proekt-duckdb-razvivaet-variant-sqlite-dlya-analiticheskih-zaprosov\" \/>\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=\"2020-05-24T17:42:08+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-05-24T17:42:08+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\udd47Udgivelsen af DBMS SQLite 3.32. Projektet DuckDB udvikler en variant af SQLite til analytiske foresp\u00f8rgsler | ProHoster","description":"Udgivelsen af SQLite 3.32.0, en letv\u00e6gts DBMS, er offentliggjort, designet i.","canonical_url":"https:\/\/prohoster.info\/da\/blog\/news\/reliz-subd-sqlite-3-32-proekt-duckdb-razvivaet-variant-sqlite-dlya-analiticheskih-zaprosov","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.32. \u041f\u0440\u043e\u0435\u043a\u0442 DuckDB \u0440\u0430\u0437\u0432\u0438\u0432\u0430\u0435\u0442 \u0432\u0430\u0440\u0438\u0430\u043d\u0442 SQLite \u0434\u043b\u044f \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0445 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 | ProHoster","og:description":"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0440\u0435\u043b\u0438\u0437 SQLite 3.32.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.","og:url":"https:\/\/prohoster.info\/da\/blog\/news\/reliz-subd-sqlite-3-32-proekt-duckdb-razvivaet-variant-sqlite-dlya-analiticheskih-zaprosov","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":"2020-05-24T17:42:08+00:00","article:modified_time":"2020-05-24T17:42:08+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"82740","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":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 15:32:25","updated":"2022-09-27 20:24:39","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\/82740","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=82740"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/posts\/82740\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/media?parent=82740"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/categories?post=82740"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/tags?post=82740"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}