{"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\/cs\/blog\/news\/pervyj-stabilnyj-reliz-subd-duckdb","title":{"rendered":"Prvn\u00ed stabiln\u00ed verze datab\u00e1ze DuckDB","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Po \u0161esti letech v\u00fdvoje byla p\u0159edstavena verze 1.0 datab\u00e1ze DuckDB, kter\u00e1 je prezentov\u00e1na jako alternativa SQLite pro analytick\u00e9 dotazy. DuckDB kombinuje vlastnosti SQLite, jako je kompaktnost, mo\u017enost p\u0159ipojen\u00ed ve form\u011b vestav\u011bn\u00e9 knihovny, ukl\u00e1d\u00e1n\u00ed datab\u00e1ze do jednoho souboru a pohodln\u00e9 CLI rozhran\u00ed, s prost\u0159edky a optimalizacemi pro prov\u00e1d\u011bn\u00ed analytick\u00fdch dotaz\u016f, pokr\u00fdvaj\u00edc\u00edch zna\u010dnou \u010d\u00e1st ulo\u017een\u00fdch dat, nap\u0159\u00edklad prov\u00e1d\u011bj\u00edc\u00edch agregaci cel\u00e9ho obsahu tabulek nebo slou\u010den\u00ed n\u011bkolika velk\u00fdch tabulek. K\u00f3d projektu je naps\u00e1n v C++ a je distribuov\u00e1n pod licenc\u00ed MIT. <\/p>\n

Verze 1.0 je ozna\u010dena jako prvn\u00ed stabiln\u00ed verze projektu, p\u0159i jej\u00ed\u017e p\u0159\u00edprav\u011b bylo hlavn\u00ed pozornost v\u011bnov\u00e1no zv\u00fd\u0161en\u00ed stability, nikoli roz\u0161i\u0159ov\u00e1n\u00ed funkcionality. V nov\u00e9 verzi je tak\u00e9 zaji\u0161t\u011bno ukotven\u00ed form\u00e1tu ukl\u00e1d\u00e1n\u00ed dat, pro kter\u00fd od posledn\u00edho vyd\u00e1n\u00ed zaji\u0161\u0165uje zp\u011btnou kompatibilitu. V budouc\u00edch verz\u00edch se v\u00fdvoj\u00e1\u0159i pl\u00e1nuj\u00ed v\u00edce opatrn\u011b p\u0159istupovat k p\u0159id\u00e1v\u00e1n\u00ed nov\u00fdch funkc\u00ed a pe\u010dovat o zachov\u00e1n\u00ed kompatibility mezi verzemi, jako\u017e i stabilizaci SQL dialektu a C API. Pokud bude v budoucnu pot\u0159eba zm\u011bnit semantiku SQL, v\u00fdvoj\u00e1\u0159i p\u0159edem zve\u0159ejn\u00ed upozorn\u011bn\u00ed o nadch\u00e1zej\u00edc\u00edch zm\u011bn\u00e1ch a poskytou obejit\u00ed pro zachov\u00e1n\u00ed funk\u010dnosti st\u00e1vaj\u00edc\u00edho k\u00f3du. <\/p>\n

DuckDB podporuje roz\u0161\u00ed\u0159en\u00fd dialekt jazyka SQL, kter\u00fd zahrnuje dal\u0161\u00ed mo\u017enosti pro zpracov\u00e1n\u00ed velmi slo\u017eit\u00fdch a dlouho b\u011b\u017e\u00edc\u00edch dotaz\u016f. Nap\u0159\u00edklad je mo\u017en\u00e9 pou\u017e\u00edt slo\u017eit\u00e9 typy (pole, struktury, unie) a prov\u00e1d\u011bt libovoln\u00e9 a vno\u0159en\u00e9 korelovan\u00e9 poddotazy. Podporov\u00e1no je sou\u010dasn\u00e9 prov\u00e1d\u011bn\u00ed n\u011bkolika dotaz\u016f, prov\u00e1d\u011bn\u00ed dotaz\u016f p\u0159\u00edmo z soubor\u016f ve form\u00e1tu CSV a Parquet. K dispozici je podpora importu z datab\u00e1ze PostgreSQL. <\/p>\n

Krom\u011b SQLite shell k\u00f3du projekt vyu\u017e\u00edv\u00e1 parser vy\u010dlen\u011bn\u00fd do samostatn\u00e9 knihovny z PostgreSQL, komponentu Date Math z MonetDB, vlastn\u00ed implementaci oknov\u00fdch funkc\u00ed (na z\u00e1klad\u011b algoritmu Segment Tree Aggregation), zpracovatel regul\u00e1rn\u00edch v\u00fdraz\u016f zalo\u017een\u00fd na knihovn\u011b RE2, vlastn\u00ed optimaliz\u00e1tor dotaz\u016f, MVCC mechanismus pro spr\u00e1vu soub\u011b\u017en\u00e9ho vykon\u00e1v\u00e1n\u00ed \u00faloh (Multi-Version Concurrency Control) a tak\u00e9 vektorov\u00fd engine vykon\u00e1v\u00e1n\u00ed dotaz\u016f zalo\u017een\u00fd na algoritmu Hyper-Pipelining Query Execution, kter\u00fd umo\u017e\u0148uje zpracov\u00e1vat velk\u00e9 mno\u017estv\u00ed hodnot v jednom operaci.
\n
Zdroj: opennet.ru<\/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\udd47Prvn\u00ed stabiln\u00ed vyd\u00e1n\u00ed DBMS DuckDB | ProHoster","description":"Po \u0161esti letech v\u00fdvoje byl p\u0159edstaven vyd\u00e1n\u00ed DBMS DuckDB 1.0, kter\u00e9 je prezentov\u00e1no jako alternativa SQLite pro analytick\u00e9 dotazy.","canonical_url":"https:\/\/prohoster.info\/cs\/blog\/news\/pervyj-stabilnyj-reliz-subd-duckdb","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"cs_CZ","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\/cs\/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\/cs\/wp-json\/wp\/v2\/posts\/116338","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/comments?post=116338"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/116338\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media?parent=116338"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/categories?post=116338"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/tags?post=116338"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}