{"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\/ro\/blog\/news\/reliz-subd-sqlite-3-32-proekt-duckdb-razvivaet-variant-sqlite-dlya-analiticheskih-zaprosov","title":{"rendered":"Lansarea SGBD-ului SQLite 3.32. Proiectul DuckDB dezvolt\u0103 o variant\u0103 SQLite pentru interog\u0103ri analitice","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/changes.html\">Publicat<\/a><\/noindex> lansare <noindex><a rel=\"nofollow\" href=\"http:\/\/sqlite.org\/\">SQLite 3.32.0<\/a><\/noindex>, o baz\u0103 de date u\u0219oar\u0103, disponibil\u0103 ca bibliotec\u0103 de conectare. Codul SQLite este distribuit ca domeniu public, adic\u0103 poate fi utilizat f\u0103r\u0103 restric\u021bii \u0219i gratuit \u00een orice scop. Suportul financiar pentru dezvoltatorii SQLite este asigurat de un consor\u021biu creat special, care include companii precum Adobe, Oracle, Mozilla, Bentley \u0219i Bloomberg. <\/p>\n<p>Principalele <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/releaselog\/3_32_0.html\">modific\u0103ri<\/a><\/noindex>:<\/p>\n<ul>\n<li class=\"l\"> Implementat <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/lang_analyze.html#approx\">aproximativ<\/a><\/noindex> o variant al comenzii ANALYZE care permite \u00een baze de date foarte mari s\u0103 ob\u021bin\u0103 statistici par\u021biale, f\u0103r\u0103 scanarea complet\u0103 a indicilor. Limita la num\u0103rul de \u00eenregistr\u0103ri la scanarea unui index este stabilit\u0103 prin noua directiv\u0103 &#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\"> A fost ad\u0103ugat\u0103 o nou\u0103 tabel\u0103 virtual\u0103 &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/bytecodevtab.html\">bytecode<\/a><\/noindex>&#171;, \u00een care este oferit\u0103 informa\u021bia despre <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/opcode.html\">bytecode<\/a><\/noindex> al expresiilor precompilate (<noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/c3ref\/stmt.html\">prepared statement<\/a><\/noindex>).\n<li class=\"l\"> A fost ad\u0103ugat\u0103 o interfa\u021b\u0103 VFS <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/cksumvfs.html\">checksum<\/a><\/noindex>, ad\u0103ug\u00e2nd sume de control de 8 bi\u021bi la sf\u00e2r\u0219itul fiec\u0103rei pagini de date \u00een baza de date \u0219i verific\u00e2ndu-le la fiecare citire din baza de date. Interfa\u021ba permite detectarea deterior\u0103rilor bazei de date cauzate de distorsiuni accidentale ale bi\u021bilor \u00een dispozitivele de stocare.\n<li class=\"l\"> A fost ad\u0103ugat\u0103 o nou\u0103 func\u021bie SQL <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/lang_corefunc.html#iif\">iif(X,Y,Z)<\/a><\/noindex>, return\u00e2nd valoarea Y, dac\u0103 expresia X este adev\u0103rat\u0103, sau Z, altfel.\n<li class=\"l\"> \u00cen expresiile INSERT \u0219i UPDATE acum \u00eentotdeauna <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/src\/info\/86ba67afafded936\">folosim<\/a><\/noindex> se aplic\u0103 restric\u021bia tipurilor de coloane (<noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/datatype3.html#affinity\">column affinity<\/a><\/noindex>) \u00eenainte de calcularea condi\u021biilor \u00een blocul <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/lang_createtable.html#ckconst\">CHECK<\/a><\/noindex>.\n<li class=\"l\"> Limita pentru num\u0103rul de parametri a fost crescut\u0103 de la 999 la 32766.\n<li class=\"l\"> A fost ad\u0103ugat un extension <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/uintcseq.html\">UINT collating sequence<\/a><\/noindex> cu implementarea sort\u0103rii secven\u021belor, av\u00e2nd \u00een vedere numerele \u00eentregi \u00een text pentru a le sorta \u00een ordine numeric\u0103.\n<li class=\"l\"> \u00cen interfa\u021ba liniei de comand\u0103, comanda &#171;.import&#187; a fost \u00eembog\u0103\u021bit\u0103 cu op\u021biunile &#171;&#8212;csv&#187;, &#171;&#8212;ascii&#187; \u0219i &#171;&#8212;skip&#187;. Comanda &#171;.dump&#187; permite utilizarea mai multor \u0219abloane LIKE cu combinarea \u00een ie\u0219ire a tuturor tabelelor corespunz\u0103toare m\u0103\u0219tilor specificate. A fost ad\u0103ugat\u0103 comanda &#171;.oom&#187; pentru compil\u0103rile de depanare. Op\u021biunea &#171;&#8212;bom&#187; a fost inclus\u0103 \u00een comenzile &#171;.excel&#187;, &#171;.output&#187; \u0219i &#171;.once&#187;. La comanda &#171;.filectrl&#187; a fost ad\u0103ugat\u0103 op\u021biunea &#171;&#8212;schema&#187;.\n<li class=\"l\"> Expresia specificat\u0103 cu operatorul LIKE ESCAPE acum redefine\u0219te caracterele de substitu\u021bie, ceea ce corespunde comportamentului \u00een PostgreSQL.\n<\/ul>\n<p>De asemenea, se poate men\u021biona dezvoltarea noului SGBD <noindex><a rel=\"nofollow\" href=\"https:\/\/www.duckdb.org\/\">DuckDB<\/a><\/noindex>, \u00een care se dezvolt\u0103 o variant\u0103 SQLite, optimizat\u0103 pentru executarea <noindex><a rel=\"nofollow\" href=\"https:\/\/ru.wikipedia.org\/wiki\/OLAP\">interog\u0103rilor analitice<\/a><\/noindex>.<br \/>\n\u00cen plus fa\u021b\u0103 de codul shell din SQLite, proiectul utilizeaz\u0103 un parser externalizat din PostgreSQL, componenta Date Math din <noindex><a rel=\"nofollow\" href=\"https:\/\/www.monetdb.org\/\">MonetDB<\/a><\/noindex>, propria implementare a func\u021biilor de fereastr\u0103 (bazat\u0103 pe algoritmul Segment Tree Aggregation), un motor de execu\u021bie de interog\u0103ri vectorizat (bazat pe algoritmul Hyper-Pipelining Query Execution), un procesor de expresii regulate bazat pe biblioteca <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=25765\">RE2<\/a><\/noindex>, optimizatorii proprii de interog\u0103ri \u0219i mecanismul MVCC de gestionare a execu\u021biei concurente a sarcinilor (Controlul Concuren\u021bei pe Versiuni Multiple).<br \/>\nCodul proiectului <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/cwida\/duckdb\">se r\u0103sp\u00e2nde\u0219te<\/a><\/noindex> sub licen\u021ba MIT. Dezvoltarea este \u00eenc\u0103 \u00een faza <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/cwida\/duckdb\/releases\">formarea<\/a><\/noindex> versiunilor experimentale.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"link\"><\/a><\/noindex><\/p>\n<p>Sursa: <a \ncontent=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=53018\">opennet.ro<\/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.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\/ro\/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.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"ro_RO\" \/>\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\/ro\/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\udd47Lansarea SGBD-ului SQLite 3.32. Proiectul DuckDB dezvolt\u0103 o variant\u0103 SQLite pentru interog\u0103ri analitice | ProHoster","description":"A fost publicat\u0103 versiunea SQLite 3.32.0, un SGBD u\u0219or, conceput \u00een.","canonical_url":"https:\/\/prohoster.info\/ro\/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":"ro_RO","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\/ro\/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\/ro\/wp-json\/wp\/v2\/posts\/82740","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/comments?post=82740"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/82740\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/media?parent=82740"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/categories?post=82740"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/tags?post=82740"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}