{"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\/it\/blog\/news\/reliz-subd-sqlite-3-32-proekt-duckdb-razvivaet-variant-sqlite-dlya-analiticheskih-zaprosov","title":{"rendered":"Rilascio del DBMS SQLite 3.32. Il progetto DuckDB sviluppa una variante di SQLite per query analitiche","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/changes.html\">Pubblicato<\/a><\/noindex> il rilascio <noindex><a rel=\"nofollow\" href=\"http:\/\/sqlite.org\/\">SQLite 3.32.0<\/a><\/noindex>, un DBMS leggero, fornito come libreria collegabile. Il codice di SQLite \u00e8 distribuito come dominio pubblico, cio\u00e8 pu\u00f2 essere utilizzato senza restrizioni e gratuitamente per qualsiasi scopo. Il supporto finanziario per gli sviluppatori di SQLite \u00e8 fornito da un consorzio appositamente creato, che comprende aziende come Adobe, Oracle, Mozilla, Bentley e Bloomberg. <\/p>\n<p>Principali <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/releaselog\/3_32_0.html\">cambiamenti<\/a><\/noindex>:<\/p>\n<ul>\n<li class=\"l\"> Realizzato <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/lang_analyze.html#approx\">approssimato<\/a><\/noindex> Una variante del comando ANALYZE che consente di eseguire una raccolta parziale delle statistiche su database molto grandi, senza effettuare una scansione completa degli indici. Il limite sul numero di record durante la scansione di un singolo indice \u00e8 impostato tramite la nuova direttiva &#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\"> Aggiunta una nuova tabella virtuale &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/bytecodevtab.html\">bytecode<\/a><\/noindex>&#171;, che offre informazioni su <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/opcode.html\">bytecode<\/a><\/noindex> di espressioni precompilate (<noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/c3ref\/stmt.html\">prepared statement<\/a><\/noindex>).\n<li class=\"l\"> Aggiunta una layer VFS <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/cksumvfs.html\">checksum<\/a><\/noindex>, che aggiunge checksum di 8 byte alla fine di ogni pagina di dati nel DB e li verifica ad ogni lettura dal DB. Il layer consente di rilevare danni nel DB causati da distorsioni casuali dei bit nei dispositivi di memorizzazione.\n<li class=\"l\"> Aggiunta una nuova funzione SQL <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/lang_corefunc.html#iif\">iif(X,Y,Z)<\/a><\/noindex>, che restituisce il valore Y se l'espressione X \u00e8 vera, o Z, altrimenti.\n<li class=\"l\"> Nelle espressioni INSERT e UPDATE ora viene sempre <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/src\/info\/86ba67afafded936\">applicato<\/a><\/noindex> il vincolo sui tipi di colonna (<noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/datatype3.html#affinity\">column affinity<\/a><\/noindex>) prima della valutazione delle condizioni nel blocco <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/lang_createtable.html#ckconst\">CHECK<\/a><\/noindex>.\n<li class=\"l\"> Il limite sul numero di parametri \u00e8 stato aumentato da 999 a 32766.\n<li class=\"l\"> Aggiunta un'estensione <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/uintcseq.html\">UINT collating sequence<\/a><\/noindex> con implementazione dell'ordinamento delle sequenze, tenendo conto dei numeri interi nel testo per ordinare questo testo in ordine numerico.\n<li class=\"l\"> Nell'interfaccia della riga di comando, al comando &#171;.import&#187; sono state aggiunte le opzioni &#171;&#8212;csv&#187;, &#171;&#8212;ascii&#187; e &#171;&#8212;skip&#187;. Nel comando &#171;.dump&#187; \u00e8 consentito l'uso di pi\u00f9 modelli LIKE con la fusione in uscita di tutte le tabelle che corrispondono ai modelli specificati. Aggiunto il comando &#171;.oom&#187; per build di debug. Al comando &#171;.excel&#187;, &#171;.output&#187; e &#171;.once&#187; \u00e8 stata aggiunta l'opzione &#171;&#8212;bom&#187;. Al comando &#171;.filectrl&#187; \u00e8 stata aggiunta l'opzione &#171;&#8212;schema&#187;.\n<li class=\"l\"> L'espressione specificata con l'operatore LIKE ora ridefinisce i caratteri jolly, il che corrisponde al comportamento di PostgreSQL.\n<\/ul>\n<p>In aggiunta, si segnala lo sviluppo di un nuovo DBMS <noindex><a rel=\"nofollow\" href=\"https:\/\/www.duckdb.org\/\">DuckDB<\/a><\/noindex>, in cui viene sviluppata una variante di SQLite ottimizzata per l'esecuzione <noindex><a rel=\"nofollow\" href=\"https:\/\/ru.wikipedia.org\/wiki\/OLAP\">query analitici<\/a><\/noindex>.<br \/>\nOltre al codice di interfaccia di SQLite, il progetto utilizza un parser separato da PostgreSQL, il componente Date Math di <noindex><a rel=\"nofollow\" href=\"https:\/\/www.monetdb.org\/\">MonetDB<\/a><\/noindex>, la sua implementazione delle funzioni a finestra (basata sull'algoritmo Segment Tree Aggregation), un motore di esecuzione delle query vettorializzato (basato sull'algoritmo Hyper-Pipelining Query Execution), un elaboratore di espressioni regolari basato sulla libreria <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=25765\">RE2<\/a><\/noindex>, un ottimizzatore di query proprietario e un meccanismo di controllo della concorrenza MVCC (Multi-Version Concurrency Control).<br \/>\nCodice del progetto <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/cwida\/duckdb\">\u00e8 distribuito<\/a><\/noindex> sotto licenza MIT. Lo sviluppo \u00e8 ancora nella fase di <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/cwida\/duckdb\/releases\">formazione<\/a><\/noindex> delle versioni sperimentali.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"link\"><\/a><\/noindex><\/p>\n<p>Fonte: <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.1.1 - 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\/it\/blog\/news\/reliz-subd-sqlite-3-32-proekt-duckdb-razvivaet-variant-sqlite-dlya-analiticheskih-zaprosov\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"it_IT\" \/>\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\/it\/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\udd47Rilascio del DBMS SQLite 3.32. Il progetto DuckDB sviluppa una variante di SQLite per query analitiche | ProHoster","description":"Pubblicata la versione SQLite 3.32.0, un DBMS leggero, formattato in.","canonical_url":"https:\/\/prohoster.info\/it\/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":"it_IT","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\/it\/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\/it\/wp-json\/wp\/v2\/posts\/82740","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/comments?post=82740"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/posts\/82740\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/media?parent=82740"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/categories?post=82740"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/tags?post=82740"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}