{"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\/news\/vypusk-subd-sqlite-3-40","title":{"rendered":"L\u00ebshimi i DBMS SQLite 3.40","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
\u00cbsht\u00eb publikuar versioni SQLite 3.40, nj\u00eb DBMS i leht\u00eb, i projektuar si nj\u00eb bibliotek\u00eb e lidhur. Kodi SQLite shp\u00ebrndahet si pasuri publike, pra mund t\u00eb p\u00ebrdoret pa kufizime dhe pa shp\u00ebrblim p\u00ebr \u00e7do q\u00ebllim. Mb\u00ebshtetja financiare p\u00ebr zhvilluesit e SQLite ofrohet nga nj\u00eb konsorcium i krijuar posa\u00e7\u00ebrisht, 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 kompilimin e SQLite n\u00eb kodin nd\u00ebrmjet\u00ebs WebAssembly, i cili mund t\u00eb ekzekutohet n\u00eb shfletuesin web dhe \u00ebsht\u00eb i p\u00ebrshtatsh\u00ebm p\u00ebr organizimin e pun\u00ebs me databaza nga aplikacionet web n\u00eb gjuh\u00ebn JavaScript. Zhvilluesit web ofrohen me nj\u00eb nd\u00ebrfaqe t\u00eb orientuar nga objekti p\u00ebr pun\u00ebn me t\u00eb dh\u00ebnat n\u00eb stilin sql.js ose Node.js, nj\u00eb mb\u00ebshtetje mbi API-n\u00eb e ul\u00ebt C dhe nj\u00eb API t\u00eb bazuar n\u00eb mekanizmin Web Worker, q\u00eb lejon krijimin e p\u00ebrpunuesve asinkron\u00eb q\u00eb ekzekutohen n\u00eb tahanqe 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 me ndihm\u00ebn e OPFS (Origin-Private FileSystem) ose API-s\u00eb window.localStorage.\n
Ka \u00ebsht\u00eb shtuar nj\u00eb zgjerim recovery, i cili \u00ebsht\u00eb i destinuar p\u00ebr rikuperimin e t\u00eb dh\u00ebnave nga skedar\u00ebt e d\u00ebmtuar t\u00eb DB. N\u00eb nd\u00ebrfaqen e komandave t\u00eb linj\u00ebs, p\u00ebrdoret komand\u00eb «.recover» p\u00ebr rikuperim.\n
\u00cbsht\u00eb p\u00ebrmir\u00ebsuar funksionimi i planifikuesit t\u00eb k\u00ebrkesave. Kufizimet jan\u00eb hequr kur p\u00ebrdoren indekset me tabela q\u00eb kan\u00eb m\u00eb shum\u00eb se 63 kolona (m\u00eb par\u00eb, gjat\u00eb operacioneve me kolona, numri serial i t\u00eb cilave kalonte 63, indeksoni nuk aplikohej). \u00cbsht\u00eb p\u00ebrmir\u00ebsuar indeksoni i vlerave t\u00eb p\u00ebrdorura n\u00eb shprehje. \u00cbsht\u00eb ndaluar ngarkimi nga disku i vargjeve dhe blob-eve t\u00eb m\u00ebdha gjat\u00eb p\u00ebrpunimit t\u00eb operator\u00ebve NOT NULL dhe IS NULL. \u00cbsht\u00eb eliminuar materializimi i pamjeve p\u00ebr t\u00eb cilat skanimi i plot\u00eb b\u00ebhet vet\u00ebm nj\u00eb her\u00eb.\n
N\u00eb baz\u00ebn e kodit, n\u00eb vend t\u00eb tipit «char *» p\u00ebr t\u00eb p\u00ebrfaq\u00ebsuar emrat e 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
N\u00eb implementimin e parametrin «PRAGMA integrity_check», jan\u00eb shtuar kontrolle t\u00eb tjera. P\u00ebr shembull, tabelat pa shenj\u00ebn STRICT nuk duhet t\u00eb p\u00ebrmbajn\u00eb vlera numerike n\u00eb kolonat me tipin TEXT dhe vlera string me numra n\u00eb kolonat me tipin NUMERIC. Po ashtu, \u00ebsht\u00eb shtuar kontrolli mbi renditjen e sakt\u00eb t\u00eb rreshtave n\u00eb tabelat me shenj\u00ebn «WITHOUT ROWID».\n
Shtuar opsioni i nd\u00ebrtimit SQLITE_MAX_ALLOCATION_SIZE, i cili lejon kufizimin e madh\u00ebsis\u00eb s\u00eb blloqeve gjat\u00eb ndarjes s\u00eb memories.\n
Algoritmi i nd\u00ebrtuar n\u00eb SQLite p\u00ebr gjenerimin e numrave pseudokategorik\u00eb \u00ebsht\u00eb kaluar nga p\u00ebrdorimi i enkriptimit RC4 n\u00eb Chacha20.\n
Lejohet p\u00ebrdorimi n\u00eb skema t\u00eb ndryshme t\u00eb t\u00eb dh\u00ebnave t\u00eb indekseve me emra t\u00eb nj\u00ebjt\u00eb.\n
Jan\u00eb b\u00ebr\u00eb optimizime t\u00eb performanc\u00ebs q\u00eb kan\u00eb lejuar reduktimin e ngarkes\u00ebs n\u00eb CPU me rreth 1% gjat\u00eb aktivitetit t\u00eb zakonsh\u00ebm. <\/ul>\n