{"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\/fr\/blog\/news\/reliz-subd-sqlite-3-32-proekt-duckdb-razvivaet-variant-sqlite-dlya-analiticheskih-zaprosov","title":{"rendered":"Sortie de la base de donn\u00e9es SQLite 3.32. Le projet DuckDB d\u00e9veloppe une variante de SQLite pour les requ\u00eates analytiques","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/changes.html\">Publi\u00e9<\/a><\/noindex> la sortie <noindex><a rel=\"nofollow\" href=\"http:\/\/sqlite.org\/\">SQLite 3.32.0<\/a><\/noindex>, une base de donn\u00e9es l\u00e9g\u00e8re sous forme de biblioth\u00e8que int\u00e9grable. Le code SQLite est distribu\u00e9 dans le domaine public, c'est-\u00e0-dire qu'il peut \u00eatre utilis\u00e9 sans restrictions et gratuitement \u00e0 des fins diverses. Le soutien financier des d\u00e9veloppeurs de SQLite est assur\u00e9 par un consortium sp\u00e9cialement cr\u00e9\u00e9, comprenant des entreprises telles qu'Adobe, Oracle, Mozilla, Bentley et Bloomberg. <\/p>\n<p>Principales <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/releaselog\/3_32_0.html\">modifications<\/a><\/noindex>:<\/p>\n<ul>\n<li class=\"l\"> l'op\u00e9rateur de s\u00e9quence optionnelle <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/lang_analyze.html#approx\">approximatif<\/a><\/noindex> Une variante de la commande ANALYZE, qui permet dans de tr\u00e8s grandes bases de donn\u00e9es de se passer d'une collecte compl\u00e8te de statistiques, sans effectuer un balayage complet des index. La limite du nombre d'enregistrements lors de la num\u00e9risation d'un index est d\u00e9finie par une nouvelle directive &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/pragma.html#pragma_analysis_limit\">PRAGMA analysis_limit<\/a><\/noindex>\u00bb.\n<li class=\"l\"> Une nouvelle table virtuelle &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/bytecodevtab.html\">bytecode<\/a><\/noindex>&#171;, qui propose des informations sur <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/opcode.html\">le bytecode<\/a><\/noindex> des expressions pr\u00e9d\u00e9finies (<noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/c3ref\/stmt.html\">prepared statement<\/a><\/noindex>).\n<li class=\"l\"> Ajout d'un niveau VFS <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/cksumvfs.html\">checksum<\/a><\/noindex>, ajoutant des checksums de 8 octets \u00e0 la fin de chaque page de donn\u00e9es dans la base de donn\u00e9es et les v\u00e9rifiant \u00e0 chaque lecture de la base de donn\u00e9es. Ce niveau permet d'identifier les corruptions de la base de donn\u00e9es r\u00e9sultant de distorsions al\u00e9atoires de bits dans les p\u00e9riph\u00e9riques de stockage.\n<li class=\"l\"> Ajout d'une nouvelle fonction SQL <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/lang_corefunc.html#iif\">iif(X,Y,Z)<\/a><\/noindex>, retournant la valeur Y si l'expression X est vraie, ou Z sinon.\n<li class=\"l\"> Dans les expressions INSERT et UPDATE, le <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/src\/info\/86ba67afafded936\">utilisons<\/a><\/noindex> liage des types de colonnes (<noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/datatype3.html#affinity\">column affinity<\/a><\/noindex>) est d\u00e9sormais effectu\u00e9 avant l'\u00e9valuation des conditions dans le bloc <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/lang_createtable.html#ckconst\">CHECK<\/a><\/noindex>.\n<li class=\"l\"> La limite du nombre de param\u00e8tres a \u00e9t\u00e9 augment\u00e9e de 999 \u00e0 32766.\n<li class=\"l\"> Ajout d'une extension <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/uintcseq.html\">S\u00e9quence de collation UINT<\/a><\/noindex> avec mise en \u0153uvre du tri des s\u00e9quences prenant en compte les entiers dans le texte afin de trier ce texte dans l'ordre num\u00e9rique.\n<li class=\"l\"> Dans l'interface de la ligne de commande, les options &#171;&#8212;csv&#187;, &#171;&#8212;ascii&#187; et &#171;&#8212;skip&#187; ont \u00e9t\u00e9 ajout\u00e9es \u00e0 la commande &#171;.import&#187;. Dans la commande &#171;.dump&#187;, l'utilisation de plusieurs mod\u00e8les LIKE avec la fusion des tables correspondant aux masques donn\u00e9s en sortie est autoris\u00e9e. Une commande &#171;.oom&#187; a \u00e9t\u00e9 ajout\u00e9e pour les builds de d\u00e9bogage. Les commandes &#171;.excel&#187;, &#171;.output&#187; et &#171;.once&#187; ont ajout\u00e9 l'option &#171;&#8212;bom&#187;. L'option &#171;&#8212;schema&#187; a \u00e9t\u00e9 ajout\u00e9e \u00e0 la commande &#171;.filectrl&#187;.\n<li class=\"l\"> L'expression sp\u00e9cifi\u00e9e avec l'op\u00e9rateur LIKE ESCAPE red\u00e9finit d\u00e9sormais les caract\u00e8res g\u00e9n\u00e9riques, se conformant au comportement de PostgreSQL.\n<\/ul>\n<p>On peut \u00e9galement noter le d\u00e9veloppement d'un nouveau SGBD <noindex><a rel=\"nofollow\" href=\"https:\/\/www.duckdb.org\/\">DuckDB<\/a><\/noindex>, qui d\u00e9veloppe une version de SQLite optimis\u00e9e pour l'ex\u00e9cution <noindex><a rel=\"nofollow\" href=\"https:\/\/ru.wikipedia.org\/wiki\/OLAP\">de requ\u00eates analytiques<\/a><\/noindex>.<br \/>\nEn plus du code shell de SQLite, le projet utilise un parseur extrait de PostgreSQL, un composant Date Math de <noindex><a rel=\"nofollow\" href=\"https:\/\/www.monetdb.org\/\">MonetDB<\/a><\/noindex>, sa propre impl\u00e9mentation des fonctions de fen\u00eatre (bas\u00e9e sur l'algorithme Segment Tree Aggregation), un moteur d'ex\u00e9cution de requ\u00eates vectoris\u00e9 (bas\u00e9 sur l'algorithme Hyper-Pipelining Query Execution), un gestionnaire d'expressions r\u00e9guli\u00e8res bas\u00e9 sur la biblioth\u00e8que <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=25765\">RE2<\/a><\/noindex>, un optimiseur de requ\u00eates propre et un m\u00e9canisme de contr\u00f4le de concurrence multi-version (Multi-Version Concurrency Control).<br \/>\nLe code du projet <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/cwida\/duckdb\">est distribu\u00e9<\/a><\/noindex> sous licence MIT. Le d\u00e9veloppement est encore \u00e0 un stade <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/cwida\/duckdb\/releases\">la cr\u00e9ation<\/a><\/noindex> de versions exp\u00e9rimentales.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"link\"><\/a><\/noindex><\/p>\n<p>Source : <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.2 - 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\/fr\/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.2\" \/>\n\t\t<meta property=\"og:locale\" content=\"fr_FR\" \/>\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\/fr\/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\udd47La version de la SGBD SQLite 3.32. Le projet DuckDB d\u00e9veloppe une variante de SQLite pour les requ\u00eates analytiques | ProHoster","description":"La version 3.32.0 de SQLite a \u00e9t\u00e9 publi\u00e9e, une SGBD l\u00e9g\u00e8re, pr\u00e9sent\u00e9e dans.","canonical_url":"https:\/\/prohoster.info\/fr\/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":"fr_FR","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\/fr\/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\/fr\/wp-json\/wp\/v2\/posts\/82740","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/comments?post=82740"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/posts\/82740\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/media?parent=82740"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/categories?post=82740"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/tags?post=82740"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}