{"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\/news\/reliz-subd-duckdb-1-4-0-s-podderzhkoj-shifrovaniya-bd","title":{"rendered":"L\u00ebshimi i DBMS DuckDB 1.4.0 me mb\u00ebshtetje p\u00ebr enkriptimin e DB-s\u00eb.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
\u00cbsht\u00eb publikuar versioni 1.4.0 i SGBD DuckDB, i orientuar p\u00ebr ekzekutimin e pyetjeve analitike dhe q\u00eb nga ana konceptuale i ngjan SQLite. DuckDB kombinon ve\u00e7ori t\u00eb SQLite, si kompakt\u00ebsia, lidhja n\u00eb form\u00ebn e nj\u00eb biblioteke t\u00eb integruar, ruajtja e DB n\u00eb nj\u00eb skedar t\u00eb vet\u00ebm dhe nd\u00ebrfaqja CLI, me mund\u00ebsi dhe optimizime p\u00ebr ekzekutimin e pyetjeve analitike q\u00eb p\u00ebrfshijn\u00eb nj\u00eb pjes\u00eb t\u00eb konsiderueshme t\u00eb t\u00eb dh\u00ebnave t\u00eb ruajtura, p\u00ebr shembull agregimin e gjith\u00eb p\u00ebrmbajtjes s\u00eb tabelave ose bashkimin e disa tabelave t\u00eb m\u00ebdha. Kodi i projektit \u00ebsht\u00eb shkruar n\u00eb C++ dhe shp\u00ebrndahet n\u00ebn licenc\u00ebn MIT. <\/p>\n
DuckDB ofron nj\u00eb dialekt t\u00eb zgjeruar t\u00eb SQL, q\u00eb p\u00ebrfshin mund\u00ebsi shtes\u00eb p\u00ebr p\u00ebrpunimin e pyetjeve shum\u00eb komplekse dhe me koh\u00eb t\u00eb gjat\u00eb ekzekutimi. Mb\u00ebshtoret p\u00ebrdorimi i tipeve komplekse (vargje, struktura, bashkime), si edhe ekzekutimi i n\u00ebnpyetjeve arbitrare dhe t\u00eb nd\u00ebrlidhura t\u00eb futura brenda nj\u00ebra-tjetr\u00ebs. Mb\u00ebshtoret ekzekutimi i nj\u00ebkohsh\u00ebm i disa pyetjeve, ekzekutimi i pyetjeve drejtp\u00ebrdrejt nga skedar\u00eb n\u00eb formatet CSV dhe Parquet. \u00cbsht\u00eb gjithashtu e disponueshme mb\u00ebshtetja p\u00ebr import nga SGBD PostgreSQL. <\/p>\n
Projekti p\u00ebrdor nj\u00eb mb\u00ebshtjell\u00ebs nga SQLite, parserin nga PostgreSQL, komponentin Date Math nga MonetDB, realizimin e tij t\u00eb funksioneve dritare (t\u00eb bazuar n\u00eb algoritmin Segment Tree Aggregation), nj\u00eb procesor p\u00ebr shprehje t\u00eb rregullta t\u00eb bazuar n\u00eb bibliotek\u00ebn RE2, optimizuesin e tij t\u00eb k\u00ebrkesave, mekanizmin MVCC p\u00ebr menaxhimin e ekzekutimit t\u00eb p\u00ebrbashk\u00ebt t\u00eb detyrave (Multi-Version Concurrency Control), si dhe nj\u00eb motor t\u00eb vectorizuar p\u00ebr ekzekutimin e k\u00ebrkesave t\u00eb bazuar n\u00eb algoritmin Hyper-Pipelining Query Execution, i cili lejon p\u00ebrpunimin n\u00eb nj\u00eb operacion t\u00eb grupeve t\u00eb m\u00ebdha t\u00eb vlerave nj\u00ebher\u00ebsh. <\/p>\n
N\u00eb versionin e ri: <\/p>\n
\n
\u00cbsht\u00eb shtuar mb\u00ebshtetje p\u00ebr ruajtjen e skedar\u00ebve t\u00eb DB n\u00eb form\u00eb t\u00eb enkriptuar. P\u00ebr enkriptimin p\u00ebrdoret algoritmi AES-256 n\u00eb modin GCM. Enkriptohet jo vet\u00ebm skedari kryesor me t\u00eb dh\u00ebna, por edhe WAL-logot dhe skedar\u00ebt e p\u00ebrkohsh\u00ebm. \u00c7el\u00ebsat p\u00ebr enkriptimin e DB caktohen me komand\u00ebn ATTACH p\u00ebrmes parametrin ENCRYPTION_KEY. ATTACH 'encrypted.db' AS enc_db (ENCRYPTION_KEY 'quack_quack');\n
\u00cbsht\u00eb shtuar 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', q\u00eb nuk k\u00ebrkon nj\u00eb \u00e7el\u00ebs primar dhe punon me kushte t\u00eb rastit p\u00ebr bashkim. Komanda 'MERGE INTO' lejon krijimin e shprehjeve SQL kushtore, duke bashkuar n\u00eb nj\u00eb shprehje operacionet INSERT, UPDATE dhe DELETE. P\u00ebr shembull, me ndihm\u00ebn e MERGE mund t\u00eb organizohet bashkimi i dy tabelave, duke futur t\u00eb dh\u00ebnat q\u00eb mungojn\u00eb dhe duke p\u00ebrdit\u00ebsuar ato ekzistuese. 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
Si shtes\u00eb p\u00ebr pun\u00ebn me tabelat n\u00eb formatin Apache Iceberg, \u00ebsht\u00eb shtuar mb\u00ebshtetja p\u00ebr operacionet e shkrimit (m\u00eb par\u00eb mb\u00ebshtetej vet\u00ebm leximi), gj\u00eb q\u00eb mund\u00ebson transferimin e t\u00eb dh\u00ebnave nga Iceberg n\u00eb DuckDB dhe anasjelltas.\n
N\u00eb klientin e linj\u00ebs s\u00eb komand\u00ebs \u00ebsht\u00eb shtuar nj\u00eb tregues i progresit t\u00eb ekzekutimit t\u00eb operacionit me parashikim t\u00eb koh\u00ebs s\u00eb mbetur deri n\u00eb p\u00ebrfundim.\n
\u00cbsht\u00eb shtuar funksioni dritare 'FILL', q\u00eb mund t\u00eb p\u00ebrdoret p\u00ebr interpolimin e vlerave t\u00eb humbura n\u00eb dritaret e 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 implementuar shtesa Teradata Connector p\u00ebr lidhje me bazat e t\u00eb dh\u00ebnave Teradata. Shtesa mund\u00ebson manipulimin e tabelave, ekzekutimin e pyetjeve dhe nisjen e komandave SQL drejtp\u00ebrdrejt n\u00eb Teradata, duke p\u00ebrdorur DuckDB.\n
\u00cbsht\u00eb shtuar mb\u00ebshtetje p\u00ebr fiksen e gjendjes (checkpoint) t\u00eb tabelave q\u00eb ruhen n\u00eb memorie, \u00e7ka ka lejuar implementimin e mb\u00ebshtetjes p\u00ebr kompresimin. P\u00ebr m\u00eb tep\u00ebr, gjat\u00eb fiksen s\u00eb gjendjes realizohet pastrimi i rreshtave t\u00eb shlyera 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: Zbatimi i renditjes \u00ebsht\u00eb kaluar n\u00eb p\u00ebrdorimin e algoritmit t\u00eb bashkimit shum\u00ebrug\u00ebsh (k-way merge sort), i cili zvog\u00eblon l\u00ebvizjen e t\u00eb dh\u00ebnave. Shprehjet tabelare t\u00eb p\u00ebrbashk\u00ebta (Common Table Expression, CTE) tani materializohen si parazgjedhje. <\/ul>\n