{"id":105659,"date":"2022-11-21T15:36:52","date_gmt":"2022-11-21T13:36:52","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-sqlite-3-40"},"modified":"2022-11-21T15:36:52","modified_gmt":"2022-11-21T13:36:52","slug":"vypusk-subd-sqlite-3-40","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/vypusk-subd-sqlite-3-40","title":{"rendered":"L\u00ebshimi i DB SQLite 3.40","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
\u00cbshte publikuar l\u00ebshimi i SQLite 3.40, nj\u00eb DBMS e leht\u00eb, e dizajnuar si nj\u00eb bibliotek\u00eb e lidhur. Kodi SQLite shp\u00ebrndahet si pron\u00eb publike (public domain), 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 konsorci t\u00eb krijuar ve\u00e7mas, q\u00eb p\u00ebrfshin kompani si Adobe, Oracle, Mozilla, Bentley dhe Bloomberg. <\/p>\n
Ndryshimet kryesore: <\/p>\n
\n
\u00cbsht\u00eb realizuar nj\u00eb mund\u00ebsi eksperimentale p\u00ebr kompilim e SQLite n\u00eb kod t\u00eb nd\u00ebrmjet\u00ebm WebAssembly, i aft\u00eb p\u00ebr t'u ekzekutuar n\u00eb shfletuesin web dhe i p\u00ebrshtatsh\u00ebm p\u00ebr organizimin e pun\u00ebs me DB nga aplikacione web t\u00eb shkruara n\u00eb gjuh\u00ebn JavaScript. Zhvilluesit e web-it ofrohen nj\u00eb nd\u00ebrfaqe objektiv-orientuar e nivelit t\u00eb lart\u00eb p\u00ebr pun\u00ebn me t\u00eb dh\u00ebnat n\u00eb stilin e sql.js ose Node.js, nj\u00eb mb\u00ebshtetje mbi API-n\u00eb e ul\u00ebt C dhe API-n\u00eb mbi mekanizmin Web Worker, q\u00eb lejon krijimin e trajtuesve asinchron t\u00eb ekzekutuar n\u00eb procese t\u00eb ve\u00e7anta. T\u00eb dh\u00ebnat q\u00eb aplikacionet web ruajn\u00eb n\u00eb versionin WASM t\u00eb SQLite mund t\u00eb ruhen n\u00eb an\u00ebn e klientit duke p\u00ebrdorur OPFS (Origin-Private FileSystem) ose API-n\u00eb window.localStorage.\n
\u00cbsht\u00eb shtuar nj\u00eb shtes\u00eb rikuperimi, e destinuar p\u00ebr rikuperimin e t\u00eb dh\u00ebnave nga skedar\u00eb t\u00eb d\u00ebmtuar me DB. N\u00eb nd\u00ebrfaqen e komand\u00ebs, p\u00ebr rikuperimin p\u00ebrdoret komand\u00eb «.recover».\n
\u00cbsht\u00eb p\u00ebrmir\u00ebsuar funksionimi i planifikuesit t\u00eb k\u00ebrkesave. Jan\u00eb hequr kufizimet gjat\u00eb p\u00ebrdorimit t\u00eb indekseve me tabela q\u00eb kan\u00eb m\u00eb shum\u00eb se 63 kolona (m\u00eb par\u00eb gjat\u00eb operacioneve me kolona, numri rendor i t\u00eb cilave kalonte 63, indekset nuk aplikohej). \u00cbsht\u00eb p\u00ebrmir\u00ebsuar indeksimi i vlerave q\u00eb p\u00ebrdoren n\u00eb shprehje. \u00cbsht\u00eb ndaluar ngarkimi nga disku i rreshtave t\u00eb m\u00ebdha dhe blob-eve gjat\u00eb procesimit t\u00eb operator\u00ebve NOT NULL dhe IS NULL. \u00cbsht\u00eb p\u00ebrjashtuar materializimi i pamjeve p\u00ebr t\u00eb cilat skanimi i plot\u00eb kryhet vet\u00ebm nj\u00eb her\u00eb.\n
N\u00eb baz\u00ebn e kodit, n\u00eb vend t\u00eb llojit «char *» p\u00ebr paraqitjen e emrave t\u00eb skedar\u00ebve, \u00ebsht\u00eb p\u00ebrdorur nj\u00eb tip i ve\u00e7ant\u00eb sqlite3_filename.\n
\u00cbsht\u00eb shtuar funksioni i brendsh\u00ebm sqlite3_value_encoding().\n
\u00cbsht\u00eb shtuar m\u00ebnyra SQLITE_DBCONFIG_DEFENSIVE, e cila ndalon ndryshimin e versionit t\u00eb skem\u00ebs s\u00eb ruajtjes s\u00eb t\u00eb dh\u00ebnave.\n
N\u00eb realizimin e parametrin «PRAGMA integrity_check» jan\u00eb shtuar kontrolle t\u00eb tjera. P\u00ebr shembull, n\u00eb tabelat pa shenj\u00ebn STRICT nuk duhet t\u00eb ket\u00eb vlera numerike n\u00eb kolona me tipin TEXT dhe vlera string me numra n\u00eb kolona me tipin NUMERIC. Gjithashtu \u00ebsht\u00eb shtuar kontrolli i rendit t\u00eb sakt\u00eb t\u00eb rreshtave n\u00eb tabelat me shenj\u00ebn «WITHOUT ROWID».\n
\u00cbsht\u00eb shtuar opsioni i nd\u00ebrtimit SQLITE_MAX_ALLOCATION_SIZE, q\u00eb lejon kufizimin e madh\u00ebsis\u00eb s\u00eb blloqeve gjat\u00eb shp\u00ebrndarjes s\u00eb memories.\n
Algoritmi i brendsh\u00ebm i SQLite p\u00ebr gjenerimin e numrave t\u00eb rastit \u00ebsht\u00eb transferuar nga p\u00ebrdorimi i enkriptimit n\u00eb rrjedh\u00eb RC4 n\u00eb Chacha20.\n
\u00cbsht\u00eb lejuar p\u00ebrdorimi i indekseve me emra t\u00eb nj\u00ebjt\u00eb n\u00eb skema t\u00eb ndryshme t\u00eb t\u00eb dh\u00ebnave.\n
Jan\u00eb b\u00ebr\u00eb optimizime t\u00eb performanc\u00ebs, q\u00eb kan\u00eb lejuar uljen e ngarkes\u00ebs n\u00eb CPU me rreth 1% gjat\u00eb aktivitetit t\u00eb zakonsh\u00ebm. <\/ul>\n