{"id":112886,"date":"2024-01-13T11:28:03","date_gmt":"2024-01-13T09:28:03","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-firebird-5-0"},"modified":"2024-01-13T11:28:03","modified_gmt":"2024-01-13T09:28:03","slug":"vypusk-subd-firebird-5-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/vypusk-subd-firebird-5-0","title":{"rendered":"L\u00ebshimi i DBMS Firebird 5.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Pas dy vjet e gjysm\u00eb zhvillimi, \u00ebsht\u00eb publikuar l\u00ebshimi i sistemit t\u00eb menaxhimit t\u00eb t\u00eb dh\u00ebnave t\u00eb marr\u00ebveshjes Firebird 5.0. Firebird vazhdon zhvillimin e kodit t\u00eb sistemit t\u00eb menaxhimit t\u00eb t\u00eb dh\u00ebnave InterBase 6.0, i hapur n\u00eb vitin 2000 nga Borland. Firebird shp\u00ebrndahet n\u00ebn licenc\u00ebn e lir\u00eb MPL dhe mb\u00ebshtet standardet ANSI SQL, duke p\u00ebrfshir\u00eb mund\u00ebsi si triggerat, procedurat e ruajtura dhe replikimin. Nd\u00ebrtesat binar\u00eb jan\u00eb p\u00ebrgatitur p\u00ebr Linux, Windows, macOS dhe Android. <\/p>\n
Novitet kryesore: <\/p>\n
\n
\u00cbsht\u00eb realizuar mund\u00ebsia p\u00ebr t\u00eb kryer operacione n\u00eb modin shum\u00eb-fushor. Paralelizimi n\u00eb disa fije \u00ebsht\u00eb i aplikuesh\u00ebm gjat\u00eb krijimit t\u00eb indekseve, grumbullimit t\u00eb mbetjeve (operacione automatike dhe manuale t\u00eb sweep), krijimit t\u00eb kopjeve rezerv\u00eb dhe rikthimit prej tyre. gfix -sweep -parallel 4 dbname gbak -b -par 4 -user username -pass password dbname backupname\n
\u00cbsht\u00eb shtuar mb\u00ebshtetje p\u00ebr indekset e pjesshme, q\u00eb p\u00ebrfshijn\u00eb vet\u00ebm regjistrat p\u00ebrkat\u00ebs, t\u00eb cil\u00ebt i p\u00ebrkasin kushteve t\u00eb sh\u00ebnuara gjat\u00eb krijimit t\u00eb indekseve. CREATE INDEX IT1_COL ON T1 (COL) WHERE COL < 100;\n
N\u00eb shprehjet SELECT WITH LOCK, UPDATE dhe DELETE \u00ebsht\u00eb realizuar sintaksa \u00abSKIP LOCKED\u00bb, e cila lejon p\u00ebrjashtimin e regjistrimeve p\u00ebr t\u00eb cilat n\u00eb momentin e d\u00ebrgimit t\u00eb k\u00ebrkes\u00ebs \u00ebsht\u00eb vendosur nj\u00eb bllokim (p\u00ebr shembull, p\u00ebr t\u00eb mos pritur lirimin e bllokimit gjat\u00eb kryq\u00ebzimit me nj\u00eb transaksion tjet\u00ebr).\n
\u00cbsht\u00eb shtuar mund\u00ebsia e p\u00ebrdit\u00ebsimit t\u00eb DB-s\u00eb n\u00eb nj\u00eb version mesatar aktual t\u00eb struktur\u00ebs s\u00eb ruajtjes (ODS \u2014 On-Disk-Structure) n\u00eb fluks (inline update) pa krijimin dhe rikthimin nga nj\u00eb kopje rezerv\u00eb. P\u00ebr shembull, tani \u00ebsht\u00eb e mundur q\u00eb n\u00eb fluks t\u00eb konvertohet DB n\u00eb formatin Firebird 4.0 (ODS 13.0) n\u00eb formatin Firebird 5.0 (ODS 13.1).\n
\u00cbsht\u00eb shtuar nd\u00ebrfaqja p\u00ebr profilizimin e SQL dhe PSQL, e cila lejon vler\u00ebsimin e koh\u00ebs s\u00eb ekzekutimit t\u00eb \u00e7do k\u00ebrkese, grumbullimin e statistikave mbi numrin e k\u00ebrkesave dhe identifikimin e problemeve me performanc\u00ebn.\n
N\u00eb shprehjen MERGE \u00ebsht\u00eb shtuar mb\u00ebshtetje p\u00ebr bllokun kusht \u00abWHEN NOT MATCHED BY SOURCE\u00bb, i cili aktivizohet kur regjistrimi burimor nuk p\u00ebrputhet me asnj\u00eb regjistrim n\u00eb grupin e cakut. MERGE INTO customers c USING new_customers nc ON (c.id = nc.id) \tWHEN MATCHED THEN \t\tUPDATE SET name = nc.name \tWHEN NOT MATCHED BY SOURCE THEN \t\tDELETE\n
Siguruar mund\u00ebsia e kthimit t\u00eb disa regjistrimeve me shprehjen RETURNING, n\u00ebse shprehja DML e caktuar mbulon disa regjistrime (m\u00eb par\u00eb n\u00eb ato raste shfaqej gabimi \u00abmultiple rows in singleton select\u00bb).\n
Jan\u00eb shtuar funksione t\u00eb reja t\u00eb nd\u00ebrtuara: UNICODE_CHAR p\u00ebr kthimin e simbolit unicode q\u00eb p\u00ebrputhet me kodin e dh\u00ebn\u00eb, dhe UNICODE_VAL p\u00ebr kthimin e kodit p\u00ebr simbolin e dh\u00ebn\u00eb. N\u00eb funksionet EXTRACT, FIRST_DAY dhe LAST_DAY \u00ebsht\u00eb shtuar parametri QUARTER p\u00ebr p\u00ebrcaktimin e numrit t\u00eb tremujorit.\n
\u00cbsht\u00eb shtuar paketa e sistemit RDB$BLOB_UTIL me nj\u00eb grumbull funksionesh p\u00ebr BLOB-et p\u00ebr modulin PSQL.\n
\u00cbsht\u00eb p\u00ebrmir\u00ebsuar algoritmi i kompresimit t\u00eb regjistrave, i cili tani aplikon nj\u00eb num\u00ebrues me gjat\u00ebsi t\u00eb ndryshueshme p\u00ebr nj\u00eb paketim m\u00eb efikas t\u00eb sekuencave t\u00eb p\u00ebrs\u00ebritura t\u00eb t\u00eb dh\u00ebnave. Optimizimi ka lejuar nj\u00eb rritje t\u00eb dukshme t\u00eb shkall\u00ebs s\u00eb kompresimit t\u00eb fushave t\u00eb gjat\u00eb VARCHAR q\u00eb nuk jan\u00eb plot\u00ebsisht t\u00eb mbushura me t\u00eb dh\u00ebna n\u00eb kodimin UTF-8.\n
\u00cbsht\u00eb shtuar mund\u00ebsia e pun\u00ebs me kursore t\u00eb dyanshme (scrollable) gjat\u00eb qasjes rrjete n\u00eb DB.\n
\u00cbsht\u00eb optimizuar performanca e kopjimit t\u00eb blob\u00ebve.\n
Shtuar mb\u00ebshtetje e plot\u00eb p\u00ebr sintaks\u00ebn e p\u00ebrcaktimit t\u00eb rreshtave, si\u00e7 \u00ebsht\u00eb p\u00ebrshkruar n\u00eb standardin SQL. P\u00ebr shembull, rreshtat tani mund t\u00eb ndahen me komente ose hap\u00ebsira: select \u2018ab\u2019 \/* comment *\/ \u2018cd\u2019 from RDB$DATABASE; select \u2018ab\u2019 \u2018cd\u2019 from RDB$DATABASE; <\/ul>\n