{"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\/sq\/blog\/novosti-interneta\/pervyj-stabilnyj-reliz-subd-duckdb","title":{"rendered":"L\u00ebshimi i par\u00eb stabil i DBMS DuckDB","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Pas gjasht\u00eb vitesh zhvillimi u prezantua versioni i DBMS DuckDB 1.0, i pozicionuar si nj\u00eb alternativ\u00eb p\u00ebr SQLite p\u00ebr k\u00ebrkesa analitike. DuckDB kombinon karakteristikat e SQLite, si kompakt\u00ebsia, mund\u00ebsia e lidhjes n\u00eb form\u00ebn e nj\u00eb bibloteke t\u00eb integruar, ruajtja e DB n\u00eb nj\u00eb skedar t\u00eb vet\u00ebm dhe nj\u00eb nd\u00ebrfaqe CLI t\u00eb leht\u00eb p\u00ebr p\u00ebrdorim, me mjete dhe optimizime p\u00ebr kryerjen e k\u00ebrkesave analitike q\u00eb mbulojn\u00eb nj\u00eb pjes\u00eb t\u00eb konsiderueshme t\u00eb t\u00eb dh\u00ebnave t\u00eb ruajtura, p\u00ebr shembull, duke realizuar agregimin e t\u00ebr\u00eb p\u00ebrmbajtjes s\u00eb tabelave ose bashkimin e disa tabelave t\u00eb m\u00ebdha. Kodi i projektit \u00ebsht\u00eb shkruar n\u00eb gjuh\u00ebn C++ dhe shp\u00ebrndahet n\u00ebn licenc\u00ebn MIT. <\/p>\n
Versioni 1.0 \u00ebsht\u00eb shpallur si l\u00ebshimi i par\u00eb stabil i projektit, n\u00eb p\u00ebrgatitjen e t\u00eb cilit u fokusua kryesisht stabiliteti, jo funksionaliteti. N\u00eb k\u00ebt\u00eb version \u00ebsht\u00eb gjithashtu konfirmuar formati i ruajtjes s\u00eb t\u00eb dh\u00ebnave, p\u00ebr t\u00eb cilin nga l\u00ebshimi i kaluar \u00ebsht\u00eb siguruar p\u00ebrputhshm\u00ebria pasuese. N\u00eb l\u00ebshimet e ardhshme, zhvilluesit kan\u00eb nd\u00ebrmend t\u00eb jen\u00eb m\u00eb t\u00eb kujdessh\u00ebm n\u00eb shtimin e mund\u00ebsive t\u00eb reja dhe t\u00eb kujdesen p\u00ebr ruajtjen e p\u00ebrputhshm\u00ebris\u00eb mes l\u00ebshimeve, si dhe t\u00eb stabilizojn\u00eb dialektin SQL dhe API-n\u00eb C. N\u00ebse n\u00eb t\u00eb ardhmen do t\u00eb k\u00ebrkohet ndryshimi i semantik\u00ebs SQL, zhvilluesit do t\u00eb publikojn\u00eb paraprakisht nj\u00eb njoftim p\u00ebr ndryshimet n\u00eb pritje dhe do t\u00eb ofrojn\u00eb m\u00ebnyra alternative p\u00ebr t\u00eb siguruar funksionalitetin e kodit ekzistues. <\/p>\n
DuckDB mb\u00ebshtet nj\u00eb dialekt t\u00eb zgjeruar t\u00eb gjuh\u00ebs SQL, duke p\u00ebrfshir\u00eb mund\u00ebsi t\u00eb shtes\u00eb p\u00ebr p\u00ebrpunimin e pyetjeve t\u00eb komplikuara dhe me zgjatje t\u00eb gjat\u00eb. P\u00ebr shembull, \u00ebsht\u00eb e mundur p\u00ebrdorimi i tipeve komplekse (array, struktura, bashkime), si dhe ekzekutimi i n\u00ebnpyetjeve t\u00eb korrelacionuara t\u00eb rast\u00ebsishme dhe t\u00eb paluajtshme. Mb\u00ebshtetet ekzekutimi i shum\u00eb pyetjeve nj\u00ebkoh\u00ebsisht, ekzekutimi i pyetjeve drejtp\u00ebrdrejt nga skedar\u00eb n\u00eb formatin CSV dhe Parquet. Disponohet mb\u00ebshtetje p\u00ebr importin nga DBMS PostgreSQL. <\/p>\n
P\u00ebrve\u00e7 kodit t\u00eb shell-it nga SQLite, projekti p\u00ebrdor parser-in e hequr n\u00eb nj\u00eb bibliotek\u00eb t\u00eb ve\u00e7ant\u00eb nga PostgreSQL, komponentin Date Math nga MonetDB, implementimin e tij t\u00eb funksioneve mendore (t\u00eb bazuar n\u00eb algoritmin Segment Tree Aggregation), p\u00ebrpunuesin e shprehjeve t\u00eb rregullta t\u00eb bazuar n\u00eb bibliotek\u00ebn RE2, optimizuesin e pyetjeve, mekanizmin MVCC p\u00ebr menaxhimin e ekzekutimit t\u00eb shum\u00ebfisht\u00eb t\u00eb detyrave (Kontrolli i Konkurrenceve me Versions t\u00eb Shumta), si dhe motorin vektorizues t\u00eb ekzekutimit t\u00eb pyetjeve t\u00eb bazuar n\u00eb algoritmin Hyper-Pipelining Query Execution, i cili lejon t\u00eb p\u00ebrpunoni grupe t\u00eb m\u00ebdha vlerash n\u00eb nj\u00eb operacion. \n Burimi: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"