{"id":106908,"date":"2023-02-22T18:48:23","date_gmt":"2023-02-22T16:48:23","guid":{"rendered":"https:\/\/prohoster.info\/?p=106908"},"modified":"2023-02-23T12:34:51","modified_gmt":"2023-02-23T10:34:51","slug":"vypusk-subd-sqlite-3-41","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/news\/vypusk-subd-sqlite-3-41","title":{"rendered":"Publikimi i DBMS SQLite 3.41","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
L\u00ebshimi i SQLite 3.41 \u00ebsht\u00eb publikuar, nj\u00eb DBMS i leht\u00eb, i dizajnuar si nj\u00eb bibliotek\u00eb e lidhshme. Kodi i SQLite shp\u00ebrndahet si pron\u00eb publike, dmth mund t\u00eb p\u00ebrdoret pa kufizime dhe falas p\u00ebr \u00e7do q\u00ebllim. Mb\u00ebshtetje financiare p\u00ebr zhvilluesit e SQLite sigurohet 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
Jan\u00eb b\u00ebr\u00eb optimizime n\u00eb planifikuesin e k\u00ebrkesave, q\u00eb prekin k\u00ebrkesat e agreguara me shprehjen GROUP BY, p\u00ebrdorimin e indekseve, p\u00ebrdorimin e korutinave n\u00eb vend t\u00eb materializimit t\u00eb n\u00ebnk\u00ebrkesave dhe pamjeve, funksionet json_tree() dhe json_each().\n
\u00cbsht\u00eb shtuar nj\u00eb zgjerim me funksionet base64 dhe base85, t\u00eb cilat tani jan\u00eb gjithashtu n\u00eb dispozicion n\u00eb nd\u00ebrfaqen e linj\u00ebs s\u00eb komandave (CLI).\n
N\u00eb CLI \u00ebsht\u00eb shtuar komanda \u2018.scanstats est\u2019 p\u00ebr vler\u00ebsimin e efikasitetit t\u00eb planifikuesit t\u00eb k\u00ebrkesave.\n
N\u00eb CLI \u00ebsht\u00eb siguruar ndryshimi i thirrjes s\u00eb hyrjes p\u00ebr t\u00eb treguar se pozita e hyrjes \u00ebsht\u00eb brenda literaleve t\u00eb vargjeve, komenteve, identifikuesve ose definicioneve t\u00eb stimuli.\n
Duke caktuar opsionin e linj\u00ebs s\u00eb komand\u00ebs \u2018--safe\u2019 \u00ebsht\u00eb zgjeruar lista e funksioneve SQL t\u00eb rrezikshme q\u00eb \u00e7 aktivizohen.\n
P\u00ebr default \u00ebsht\u00eb \u00e7aktivizuar moda, q\u00eb lejon mb\u00ebshtjelljen e literaleve t\u00eb vargjeve me thonj\u00ebza t\u00eb dyfishta.\n
N\u00eb komand\u00ebn PRAGMA integrity_check \u00ebsht\u00eb siguruar p\u00ebrcaktimi i p\u00ebrputhshm\u00ebris\u00eb s\u00eb literaleve t\u00eb teksteve n\u00eb tabel\u00eb kur p\u00ebrdoren renditje t\u00eb ndryshme t\u00eb bajt\u00ebve n\u00eb indeks.\n
N\u00eb parser \u00ebsht\u00eb realizuar injorimi i parantezave t\u00eb tep\u00ebrta rreth n\u00ebnk\u00ebrkesave, t\u00eb vendosura n\u00eb an\u00ebn e djathta t\u00eb operatorit IN, q\u00eb p\u00ebrputhet me sjelljen e PostgreSQL (m\u00eb par\u00eb SQLite e p\u00ebrpunonte nj\u00eb n\u00ebnk\u00ebrkes\u00eb t\u00eb till\u00eb si nj\u00eb shprehje q\u00eb i n\u00ebnshtrohej kufizimit \u2018LIMIT 1\u2019). <\/ul>\n