{"id":102412,"date":"2021-11-28T09:36:50","date_gmt":"2021-11-28T07:36:50","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-sqlite-3-37"},"modified":"2021-11-28T09:36:50","modified_gmt":"2021-11-28T07:36:50","slug":"vypusk-subd-sqlite-3-37","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/vypusk-subd-sqlite-3-37","title":{"rendered":"Shp\u00ebrndarja e DBMS SQLite 3.37","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
\u00cbsht\u00eb publikuar versioni i SQLite 3.37, nj\u00eb db e leht\u00eb, e dizajnuar si nj\u00eb bibliotek\u00eb e lidhur. Kodi i SQLite shp\u00ebrndahet si pron\u00eb publike, dmth. mund t\u00eb p\u00ebrdoret pa kufizime dhe pa pages\u00eb p\u00ebr \u00e7do q\u00ebllim. Mb\u00ebshtetje financiare p\u00ebr zhvilluesit e SQLite ofrohet nga nj\u00eb konsorcium i krijuar posa\u00e7\u00ebrisht, i cili p\u00ebrfshin kompani si Adobe, Oracle, Mozilla, Bentley dhe Bloomberg. <\/p>\n
Ndryshimet kryesore: <\/p>\n
\n
\u00cbsht\u00eb shtuar mb\u00ebshtetje p\u00ebr krijimin e tabelave me shenj\u00ebn \u00abSTRICT\u00bb, duke k\u00ebrkuar p\u00ebrcaktimin e detyruesh\u00ebm t\u00eb tipit kur shpallen kolonat dhe duke zbatuar kontroll t\u00eb rrept\u00eb t\u00eb p\u00ebrputhshm\u00ebris\u00eb s\u00eb tipeve t\u00eb t\u00eb dh\u00ebnave t\u00eb futura n\u00eb kolonat. Kur ky flak\u00eb \u00ebsht\u00eb vendosur, SQLite do t\u00eb nxjerr\u00eb nj\u00eb gabim n\u00eb rast t\u00eb pamund\u00ebsis\u00eb p\u00ebr t\u00eb konvertuar t\u00eb dh\u00ebnat e specifikuara n\u00eb tipin e kolon\u00ebs. P\u00ebr shembull, n\u00ebse kolona \u00ebsht\u00eb krijuar si \u00abINTEGER\u00bb, transferimi i nj\u00eb vlere string \u00ab123\u00bb do t\u00eb rezultoj\u00eb n\u00eb shtimin e numrit 123, por p\u00ebrpjekja p\u00ebr t\u00eb vendosur \u00abxyz\u00bb do t\u00eb p\u00ebrfundoj\u00eb me nj\u00eb gabim.\n
N\u00eb operacionin \u00abALTER TABLE ADD COLUMN\u00bb \u00ebsht\u00eb shtuar kontrolli i kushteve t\u00eb ekzistenc\u00ebs s\u00eb rreshtave kur shtohen kolona me kontrollin e bazuar n\u00eb shprehjen \u00abCHECK\u00bb ose me kushte \u00abNOT NULL\u00bb.\n
\u00cbsht\u00eb realizuar shprehja \u00abPRAGMA table_list\u00bb p\u00ebr t\u00eb nxjerr\u00eb informacion mbi tabelat dhe pamjet.\n
N\u00eb linj\u00ebn e komand\u00ebs \u00ebsht\u00eb implementuar komanda \u00ab.connection\u00bb, e cila lejon mbajtjen e disa lidhjeve me DB nj\u00ebkoh\u00ebsisht.\n
\u00cbsht\u00eb shtuar parametri \u00ab--safe\u00bb, i cili \u00e7on n\u00eb \u00e7aktivizimin e komandave CLI dhe shprehjeve SQL q\u00eb lejojn\u00eb operacione me skedar\u00ebt e DB q\u00eb ndryshojn\u00eb nga ajo e specifikuar n\u00eb komanden e linj\u00ebs.\n
N\u00eb CLI \u00ebsht\u00eb optimizuar performanca e leximit t\u00eb shprehjeve SQL, t\u00eb cilat jan\u00eb t\u00eb ndara n\u00eb disa rreshta.\n
Jan\u00eb shtuar funksionet sqlite3_autovacuum_pages(), sqlite3_changes64() dhe sqlite3_total_changes64().\n
N\u00eb planifikuesin e k\u00ebrkesave \u00ebsht\u00eb siguruar injorimi i shprehjeve \u00abORDER BY\u00bb n\u00eb n\u00ebnk\u00ebrkesat dhe pamjet, n\u00ebse heqja e k\u00ebtyre shprehjeve nuk ndryshon semantik\u00ebn e k\u00ebrkes\u00ebs.\n
\u00cbsht\u00eb ndryshuar zgjerimi generate_series(START,END,STEP), ku parametri i par\u00eb (\u00abSTART\u00bb) \u00ebsht\u00eb transferuar n\u00eb radh\u00ebn e detyrueshme. P\u00ebr t\u00eb rikthyer sjelljen e vjet\u00ebr, mund t\u00eb rind\u00ebrtohet me opsionin \u00ab-DZERO_ARGUMENT_GENERATE_SERIES\u00bb.\n
\u00cbsht\u00eb reduktuar konsumimi i memories p\u00ebr ruajtjen e skem\u00ebs s\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave. <\/ul>\n