{"id":116338,"date":"2024-06-04T21:39:58","date_gmt":"2024-06-04T19:39:58","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/pervyj-stabilnyj-reliz-subd-duckdb"},"modified":"2024-06-04T21:39:58","modified_gmt":"2024-06-04T19:39:58","slug":"pervyj-stabilnyj-reliz-subd-duckdb","status":"publish","type":"post","link":"https:\/\/prohoster.info\/lv\/blog\/news\/pervyj-stabilnyj-reliz-subd-duckdb","title":{"rendered":"Pirmais stabilais DuckDB datub\u0101zes rel\u012bzs","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

P\u0113c se\u0161u gadu izstr\u0101des ir izlaista DuckDB 1.0, kas tiek pozicion\u0113ta k\u0101 SQLite variants anal\u012btiskiem vaic\u0101jumiem. DuckDB apvieno t\u0101das SQLite \u012bpa\u0161\u012bbas k\u0101 kompakts izm\u0113rs, iesp\u0113ja piesl\u0113gties k\u0101 ieb\u016bv\u0113ta bibliot\u0113ka, datub\u0101zes glab\u0101\u0161ana vien\u0101 fail\u0101 un \u0113rts CLI interfeiss, ar l\u012bdzek\u013ciem un optimiz\u0101cij\u0101m, lai veiktu anal\u012btiskos vaic\u0101jumus, kas aptver noz\u012bm\u012bgu da\u013cu no glab\u0101tajiem datiem, piem\u0113ram, veicot agreg\u0101ciju visam tabulu saturam vai apvienojot vair\u0101kas lielas tabulas. Projekta kods ir uzrakst\u012bts C++ valod\u0101 un izplat\u012bts ar MIT licenci. <\/p>\n

Versija 1.0 ir atz\u012bm\u0113ta k\u0101 pirm\u0101 stabil\u0101 projekta izlase, kuras sagatavo\u0161anas laik\u0101 galven\u0101 uzman\u012bba tika piev\u0113rsta stabilit\u0101tes paaugstin\u0101\u0161anai, nevis funkcionalit\u0101tes palielin\u0101\u0161anai. Jaunaj\u0101 versij\u0101 ar\u012b tiek nostiprin\u0101ts datu glab\u0101\u0161anas form\u0101ta fiks\u0101cijas princips, kura d\u0113\u013c kop\u0161 iepriek\u0161\u0113j\u0101s izlases tiek nodro\u0161in\u0101ta atpaka\u013csader\u012bba. N\u0101kamaj\u0101s izlaidumos izstr\u0101d\u0101t\u0101ji pl\u0101no piesardz\u012bg\u0101k piev\u0113rsties jauno iesp\u0113ju pievieno\u0161anai un saglab\u0101t sader\u012bbu starp izlaidumiem, k\u0101 ar\u012b stabiliz\u0113t SQL dialektu un C API. Ja n\u0101kotn\u0113 b\u016bs j\u0101maina SQL semantika, izstr\u0101d\u0101t\u0101ji iepriek\u0161 public\u0113s br\u012bdin\u0101jumus par gaid\u0101maj\u0101m izmai\u0146\u0101m un pied\u0101v\u0101s apiet ce\u013cus, lai saglab\u0101tu eso\u0161\u0101 koda darb\u012bbu. <\/p>\n

DuckDB atbalsta papla\u0161in\u0101tu SQL valodas dialektu, kas ietver papildu iesp\u0113jas \u013coti sare\u017e\u0123\u012btu un ilgsto\u0161i izpild\u0101mu vaic\u0101jumu apstr\u0101dei. Piem\u0113ram, iesp\u0113jama sare\u017e\u0123\u012btu tipu (mas\u012bvi, strukt\u016bras, apvienojumi) izmanto\u0161ana, k\u0101 ar\u012b p\u0113c piepras\u012bjuma izpild\u012bt sare\u017e\u0123\u012btus un iegultus korrel\u0113jo\u0161os apak\u0161vaic\u0101jumus. Atbalsta vienlaic\u012bgu vair\u0101ku vaic\u0101jumu izpildi, vaic\u0101jumu izpildi tie\u0161i no failiem CSV un Parquet form\u0101t\u0101. Ir pieejams atbalsts import\u0113\u0161anai no PostgreSQL datub\u0101z\u0113m. <\/p>\n

Papildus SQLite shell kodam, projekt\u0101 tiek izmantota PostgreSQL izsniegta parser bibliot\u0113ka, MonetDB Date Math komponents, pa\u0161a izstr\u0101d\u0101ta logu funkciju realiz\u0101cija (balst\u012bta uz Segment Tree Aggregation algoritma), regul\u0101ro izteiksmju apstr\u0101d\u0101t\u0101js, kas balst\u012bts uz RE2 bibliot\u0113ku, savs vaic\u0101jumu optimiz\u0113t\u0101js, MVCC meh\u0101nisms (Multi-Version Concurrency Control) paral\u0113lo uzdevumu izpildes p\u0101rvald\u012b\u0161anai, k\u0101 ar\u012b vektoriz\u0113ts vaic\u0101jumu izpildes dzin\u0113js, kas balst\u012bts uz Hyper-Pipelining Query Execution algoritma, \u013caujot vien\u0101 oper\u0101cij\u0101 apstr\u0101d\u0101t lielus v\u0113rt\u012bbu kopumus.
\n
Avots: opennet.lv<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

\u041f\u043e\u0441\u043b\u0435 \u0448\u0435\u0441\u0442\u0438 \u043b\u0435\u0442 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 DuckDB 1.0, \u043f\u043e\u0437\u0438\u0446\u0438\u043e\u043d\u0438\u0440\u0443\u0435\u043c\u043e\u0439 \u043a\u0430\u043a \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. DuckDB \u0441\u043e\u0447\u0435\u0442\u0430\u0435\u0442 \u0442\u0430\u043a\u0438\u0435 \u0441\u0432\u043e\u0439\u0441\u0442\u0432\u0430 SQLite, \u043a\u0430\u043a \u043a\u043e\u043c\u043f\u0430\u043a\u0442\u043d\u043e\u0441\u0442\u044c, \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f \u0432 \u0444\u043e\u0440\u043c\u0435 \u0432\u0441\u0442\u0440\u0430\u0438\u0432\u0430\u0435\u043c\u043e\u0439 \u0431\u0438\u0431\u043b\u0438\u043e\u0442\u0435\u043a\u0438, \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u0435 \u0411\u0414 \u0432 \u043e\u0434\u043d\u043e\u043c \u0444\u0430\u0439\u043b\u0435 \u0438 \u0443\u0434\u043e\u0431\u043d\u044b\u0439 CLI-\u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441, \u0441\u043e \u0441\u0440\u0435\u0434\u0441\u0442\u0432\u0430\u043c\u0438 \u0438 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u044f\u043c\u0438 \u0434\u043b\u044f \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0445 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432, \u043e\u0445\u0432\u0430\u0442\u044b\u0432\u0430\u044e\u0449\u0438\u0445 \u0437\u043d\u0430\u0447\u0438\u0442\u0435\u043b\u044c\u043d\u0443\u044e \u0447\u0430\u0441\u0442\u044c \u0445\u0440\u0430\u043d\u0438\u043c\u044b\u0445 \u0434\u0430\u043d\u043d\u044b\u0445, \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u044e\u0449\u0438\u0445 \u0430\u0433\u0440\u0435\u0433\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0432\u0441\u0435\u0433\u043e \u0441\u043e\u0434\u0435\u0440\u0436\u0438\u043c\u043e\u0433\u043e […]<\/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-116338","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47Pirmais stabilais DuckDB DBMS izlaidums | ProHoster","description":"P\u0113c se\u0161u gadu izstr\u0101des ir prezent\u0113ta DuckDB 1.0 DBMS versija, kas pozicion\u0113ta k\u0101 SQLite anal\u012btiskajiem vaic\u0101jumiem alternat\u012bva.","canonical_url":"https:\/\/prohoster.info\/lv\/blog\/news\/pervyj-stabilnyj-reliz-subd-duckdb","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"lv_LV","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\u041f\u0435\u0440\u0432\u044b\u0439 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u043b\u0438\u0437 \u0421\u0423\u0411\u0414 DuckDB | ProHoster","og:description":"\u041f\u043e\u0441\u043b\u0435 \u0448\u0435\u0441\u0442\u0438 \u043b\u0435\u0442 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 DuckDB 1.0, \u043f\u043e\u0437\u0438\u0446\u0438\u043e\u043d\u0438\u0440\u0443\u0435\u043c\u043e\u0439 \u043a\u0430\u043a \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.","og:url":"https:\/\/prohoster.info\/lv\/blog\/news\/pervyj-stabilnyj-reliz-subd-duckdb","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":"2024-06-04T19:39:58+00:00","article:modified_time":"2024-06-04T19:39:58+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"116338","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":"default","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-23 01:43:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-01-23 01:43:19","updated":"2026-01-23 01:43:19","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/116338","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/comments?post=116338"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/116338\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/media?parent=116338"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/categories?post=116338"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/tags?post=116338"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}