{"id":143994,"date":"2025-09-22T17:11:59","date_gmt":"2025-09-22T15:11:59","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/reliz-subd-duckdb-1-4-0-s-podderzhkoj-shifrovaniya-bd"},"modified":"2025-09-22T17:11:59","modified_gmt":"2025-09-22T15:11:59","slug":"reliz-subd-duckdb-1-4-0-s-podderzhkoj-shifrovaniya-bd","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/reliz-subd-duckdb-1-4-0-s-podderzhkoj-shifrovaniya-bd","title":{"rendered":"L\u00ebshimi i SGBD DuckDB 1.4.0 me mb\u00ebshtetje p\u00ebr enkriptimin e DB","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
\u00cbsht\u00eb publikuar versioni SGBD DuckDB 1.4.0, i orientuar p\u00ebr ekzekutimin e k\u00ebrkesave analitike dhe konceptualisht i ngjash\u00ebm me SQLite. DuckDB kombinon pronat e SQLite, si kompakt\u00ebsia, lidhja si nj\u00eb bibliotek\u00eb e integruar, ruajtja e DB n\u00eb nj\u00eb skedar dhe nd\u00ebrfaqen CLI, me mund\u00ebsit\u00eb dhe optimizimet p\u00ebr ekzekutimin e k\u00ebrkesave analitike q\u00eb mbulojn\u00eb nj\u00eb pjes\u00eb t\u00eb madhe t\u00eb t\u00eb dh\u00ebnave t\u00eb ruajtura, p\u00ebr shembull, duke kryer agregimin e gjith\u00eb p\u00ebrmbajtjes s\u00eb tavollave ose bashkimin e disa tavollave 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
DuckDB ofron nj\u00eb dialekt t\u00eb zgjeruar t\u00eb gjuh\u00ebs SQL, i cili p\u00ebrfshin mund\u00ebsi shtes\u00eb p\u00ebr p\u00ebrpunimin e k\u00ebrkesave shum\u00eb komplekse dhe afatgjata. \u00cbsht\u00eb e mundur t\u00eb p\u00ebrdoren tipe t\u00eb komplikuara (array, struktura, bashkime), si dhe t\u00eb ekzekutohen n\u00ebnk\u00ebrkesa t\u00eb rast\u00ebsishme dhe t\u00eb ngulitura. Mb\u00ebshtetet ekzekutimi paralel i k\u00ebrkesave t\u00eb shumta, ekzekutimi i k\u00ebrkesave drejtp\u00ebrdrejt nga skedar\u00ebt n\u00eb formatet CSV dhe Parquet. Mb\u00ebshtetja e importit nga DBMS PostgreSQL \u00ebsht\u00eb gjithashtu e disponueshme. <\/p>\n
Projekti p\u00ebrdor nj\u00eb shell nga SQLite, parser nga PostgreSQL, komponentin Date Math nga MonetDB, implementimin e tij t\u00eb funksioneve dritare (baze n\u00eb algoritmin e Segment Tree Aggregation), nj\u00eb p\u00ebrpunues regex-i t\u00eb bazuar n\u00eb bibliotek\u00ebn RE2, optimizator\u00eb t\u00eb ve\u00e7ant\u00eb pyetjesh, mekanizmin MVCC p\u00ebr menaxhimin e konkurenc\u00ebs (Kontrolli i Konkurrenc\u00ebs me Versione t\u00eb Shumta), si dhe nj\u00eb motor t\u00eb vectorizuar p\u00ebr ekzekutimin e pyetjeve t\u00eb bazuar n\u00eb algoritmin Hyper-Pipelining Query Execution, q\u00eb lejon p\u00ebrpunimin e grupeve t\u00eb m\u00ebdha t\u00eb vlerave n\u00eb nj\u00eb operacion t\u00eb vet\u00ebm. <\/p>\n
N\u00eb k\u00ebt\u00eb version t\u00eb ri: <\/p>\n
\n
Shto \u00ebsht\u00eb shtuar mb\u00ebshtetje p\u00ebr ruajtjen e skedar\u00ebve t\u00eb DB n\u00eb nj\u00eb form\u00eb t\u00eb enkriptuar. P\u00ebr enkriptimin p\u00ebrdoret algoritmi AES-256 n\u00eb modin GCM. Jo vet\u00ebm skedari kryesor me t\u00eb dh\u00ebna, por edhe WAL-loget dhe skedar\u00ebt p\u00ebrkoh\u00ebsisht do t\u00eb enkriptohen. \u00c7el\u00ebsat p\u00ebr enkriptimin e DB caktohen me komand\u00ebn ATTACH p\u00ebrmes parametrave ENCRYPTION_KEY. ATTACH 'encrypted.db' AS enc_db (ENCRYPTION_KEY 'quack_quack');\n
Shtohet mb\u00ebshtetje p\u00ebr komand\u00ebn 'MERGE INTO', e cila mund t\u00eb p\u00ebrdoret si nj\u00eb alternativ\u00eb p\u00ebr shprehjen 'INSERT \u2026 ON CONFLICT', e cila nuk k\u00ebrkon \u00e7el\u00ebsin kryesor dhe funksionon me kushte t\u00eb rast\u00ebsishme t\u00eb bashkimit. Komanda 'MERGE INTO' lejon krijimin e shprehjeve SQL t\u00eb kusht\u00ebzuara q\u00eb bashkojn\u00eb n\u00eb nj\u00eb shprehje operacionet INSERT, UPDATE dhe DELETE. P\u00ebr shembull, me an\u00eb t\u00eb MERGE mund t\u00eb organizoni bashkimin e dy tabelave, duke futur regjistrat q\u00eb mungojn\u00eb dhe duke p\u00ebrdit\u00ebsuar ata ekzistues. WITH deletes(item_id, delete_threshold) AS (VALUES (10, 3000)) MERGE INTO Stock USING deletes USING (item_id) WHEN MATCHED AND balance < delete_threshold THEN DELETE RETURNING merge_action, *; \n\n
P\u00ebrve\u00e7 k\u00ebsaj, p\u00ebr t\u00eb punuar me tabelat n\u00eb formatin Apache Iceberg, \u00ebsht\u00eb shtuar mb\u00ebshtetje p\u00ebr operacionet e shkrimit (m\u00eb par\u00eb suportohej vet\u00ebm leximi), e cila lejon transferimin e t\u00eb dh\u00ebnave nga Iceberg n\u00eb DuckDB dhe anasjelltas.\n
N\u00eb klientin e komand\u00ebs s\u00eb linj\u00ebs \u00ebsht\u00eb shtuar nj\u00eb tregues progresi p\u00ebr p\u00ebrfundimin e operacionit me parashikimin e koh\u00ebs s\u00eb mbetur deri n\u00eb p\u00ebrfundim.\n
Shtohet funksioni i dritares 'FILL', i cili mund t\u00eb p\u00ebrdoret p\u00ebr interpolimin e vlerave t\u00eb munguar n\u00eb dritare t\u00eb renditura. FROM (VALUES (1, 1), (2, NULL), (3, 42)) t(c1, c2) SELECT fill(c2) OVER (ORDER BY c1) f; 1 21 42\n
\u00cbsht\u00eb realizuar shtesa Teradata Connector p\u00ebr lidhjen me bazat e t\u00eb dh\u00ebnave Teradata. Kjo shtes\u00eb lejon manipilimin e tabelave, ekzekutimin e pyetjeve dhe nisjen e komandave SQL direkt n\u00eb Teradata, duke p\u00ebrdorur DuckDB.\n
Shtohet mb\u00ebshtetje p\u00ebr fiksen e gjendjes (checkpoint) t\u00eb tabelave q\u00eb ruhen n\u00eb memorie, \u00e7ka mund\u00ebson realizimin e mb\u00ebshtetjes p\u00ebr kompresimin. P\u00ebr m\u00eb tep\u00ebr, gjat\u00eb fiksen e gjendjes b\u00ebhet pastrimi i rreshtave t\u00eb fshir\u00eb dhe lirimi i hap\u00ebsir\u00ebs pas operacioneve t\u00eb fshirjes. ATTACH ':memory:' AS memory_compressed (COMPRESS);\n
Jan\u00eb propozuar disa optimizime t\u00eb performanc\u00ebs: Implementimi i renditjes \u00ebsht\u00eb transferuar n\u00eb p\u00ebrdorimin e algoritmit t\u00eb bashkimit t\u00eb shum\u00ebfisht\u00eb (k-way merge sort), duke reduktuar l\u00ebvizjen e t\u00eb dh\u00ebnave. Shprehjet e tabelave t\u00eb p\u00ebrgjithshme (Common Table Expression, CTE) tani materializohen si t\u00eb parazgjedhura. <\/ul>\n