Hat \u00e9v fejleszt\u00e9s ut\u00e1n megjelent a DuckDB 1.0 adatb\u00e1zis-kezel\u0151 rendszer, amelyet az SQLite analitikai lek\u00e9rdez\u00e9sek alternat\u00edv\u00e1jak\u00e9nt pozicion\u00e1lnak. A DuckDB \u00f6tv\u00f6zi az SQLite olyan jellemz\u0151it, mint a sz\u0171k m\u00e9ret, a be\u00e1gyazhat\u00f3 k\u00f6nyvt\u00e1r form\u00e1j\u00e1ban t\u00f6rt\u00e9n\u0151 csatlakoztat\u00e1s lehet\u0151s\u00e9ge, az adatb\u00e1zis egyetlen f\u00e1jlban t\u00f6rt\u00e9n\u0151 t\u00e1rol\u00e1sa, valamint a felhaszn\u00e1l\u00f3bar\u00e1t CLI fel\u00fclet, az analitikai lek\u00e9rdez\u00e9sek v\u00e9grehajt\u00e1s\u00e1hoz sz\u00fcks\u00e9ges eszk\u00f6z\u00f6kkel \u00e9s optimaliz\u00e1l\u00e1sokkal, amelyek jelent\u0151s r\u00e9szt \u00f6lelnek fel a t\u00e1rolt adatokb\u00f3l, p\u00e9ld\u00e1ul aggreg\u00e1lva a t\u00e1bl\u00e1k teljes tartalm\u00e1t vagy t\u00f6bb nagy t\u00e1bla egyes\u00edt\u00e9s\u00e9vel. A projekt k\u00f3dja C++ nyelven \u00edr\u00f3dott \u00e9s MIT licenc alatt terjesztik. <\/p>\n
Az 1.0-\u00e1s verzi\u00f3 a projekt els\u0151 stabil kiad\u00e1sak\u00e9nt van megjel\u00f6lve, amelynek el\u0151k\u00e9sz\u00edt\u00e9se sor\u00e1n a stabilit\u00e1s n\u00f6vel\u00e9s\u00e9re helyezt\u00e9k a hangs\u00falyt, nem a funkcionalit\u00e1s b\u0151v\u00edt\u00e9s\u00e9re. Az \u00faj verzi\u00f3ban r\u00f6gz\u00edtett\u00e9k az adatment\u00e9si form\u00e1tum, amely a legut\u00f3bbi kiad\u00e1s \u00f3ta visszafel\u00e9 kompatibilit\u00e1st biztos\u00edt. A k\u00f6vetkez\u0151 kiad\u00e1sok sor\u00e1n a fejleszt\u0151k \u00f3vatosabban k\u00edv\u00e1nj\u00e1k b\u0151v\u00edteni az \u00faj funkci\u00f3kat \u00e9s figyelembe k\u00edv\u00e1nj\u00e1k venni a verzi\u00f3k k\u00f6z\u00f6tti kompatibilit\u00e1s fenntart\u00e1s\u00e1t, valamint az SQL \u00e9s C API stabiliz\u00e1l\u00e1s\u00e1t. Ha a j\u00f6v\u0151ben SQL szemantikai v\u00e1ltoz\u00e1sokra lesz sz\u00fcks\u00e9g, a fejleszt\u0151k el\u0151re meg fogj\u00e1k jelenteni a k\u00f6zelg\u0151 v\u00e1ltoz\u00e1sokr\u00f3l sz\u00f3l\u00f3 figyelmeztet\u00e9st \u00e9s megold\u00e1sokat k\u00edn\u00e1lnak a megl\u00e9v\u0151 k\u00f3d m\u0171k\u00f6d\u0151k\u00e9pess\u00e9g\u00e9nek meg\u0151rz\u00e9s\u00e9re. <\/p>\n
A DuckDB kiterjesztett SQL nyelvj\u00e1r\u00e1st t\u00e1mogat, amely tov\u00e1bbi lehet\u0151s\u00e9geket biztos\u00edt rendk\u00edv\u00fcl bonyolult \u00e9s hosszan tart\u00f3 lek\u00e9rdez\u00e9sek v\u00e9grehajt\u00e1s\u00e1ra. P\u00e9ld\u00e1ul lehets\u00e9ges \u00f6sszetett t\u00edpusok (t\u00f6mb\u00f6k, strukt\u00far\u00e1k, egyes\u00edt\u00e9sek) haszn\u00e1lata, valamint tetsz\u0151leges \u00e9s egym\u00e1sba \u00e1gyazott korrel\u00e1l\u00f3 allek\u00e9rdez\u00e9sek v\u00e9grehajt\u00e1sa. T\u00e1mogatja t\u00f6bb lek\u00e9rdez\u00e9s p\u00e1rhuzamos v\u00e9grehajt\u00e1s\u00e1t, lek\u00e9rdez\u00e9sek k\u00f6zvetlen v\u00e9grehajt\u00e1s\u00e1t CSV \u00e9s Parquet form\u00e1tum\u00fa f\u00e1jlokb\u00f3l. Lehets\u00e9ges a PostgreSQL adatb\u00e1zis-kezel\u0151b\u0151l t\u00f6rt\u00e9n\u0151 import\u00e1l\u00e1s is. <\/p>\n
A projekt az SQLite-b\u00f3l sz\u00e1rmaz\u00f3 shell k\u00f3d mellett egy k\u00fcl\u00f6n k\u00f6nyvt\u00e1rba helyezett PostgreSQL parser-t, a MonetDB-b\u0151l sz\u00e1rmaz\u00f3 Date Math komponenst, saj\u00e1t megval\u00f3s\u00edt\u00e1s\u00fa ablakos funkci\u00f3kat (a Segment Tree Aggregation algoritmus alapj\u00e1n), az RE2 k\u00f6nyvt\u00e1ron alapul\u00f3 regul\u00e1ris kifejez\u00e9sek feldolgoz\u00f3j\u00e1t, egyedi lek\u00e9rdez\u00e9s-optimaliz\u00e1l\u00f3t, egy MVCC mechanizmust a p\u00e1rhuzamos v\u00e9grehajt\u00e1s ir\u00e1ny\u00edt\u00e1s\u00e1ra (Multi-Version Concurrency Control), valamint egy hyper-pipelining lek\u00e9rdez\u00e9s-v\u00e9grehajt\u00f3 algoritmusra \u00e9p\u00fcl\u0151 vektoriz\u00e1lt v\u00e9grehajt\u00f3 motort alkalmaz, amely lehet\u0151v\u00e9 teszi, hogy egy m\u0171velet sor\u00e1n nagym\u00e9ret\u0171 \u00e9rt\u00e9khalmazokat egyszerre kezeljen. \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\udd47A DuckDB els\u0151 stabil kiad\u00e1sa | ProHoster","description":"Hat \u00e9v fejleszt\u00e9s ut\u00e1n megjelent a DuckDB 1.0 adatb\u00e1zis-kezel\u0151 rendszer, amelyet az SQLite analitikai lek\u00e9rdez\u00e9sek alternat\u00edv\u00e1jak\u00e9nt pozicion\u00e1lnak.","canonical_url":"https:\/\/prohoster.info\/hu\/blog\/news\/pervyj-stabilnyj-reliz-subd-duckdb","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"hu_HU","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\/hu\/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\/hu\/wp-json\/wp\/v2\/posts\/116338","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/comments?post=116338"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/116338\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media?parent=116338"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/categories?post=116338"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/tags?post=116338"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n
Forr\u00e1s: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"