{"id":103443,"date":"2022-02-27T15:36:52","date_gmt":"2022-02-27T13:36:52","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-sqlite-3-38-i-nabora-utilit-sqlite-utils-3-24"},"modified":"2022-02-27T15:36:52","modified_gmt":"2022-02-27T13:36:52","slug":"vypusk-subd-sqlite-3-38-i-nabora-utilit-sqlite-utils-3-24","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/news\/vypusk-subd-sqlite-3-38-i-nabora-utilit-sqlite-utils-3-24","title":{"rendered":"L\u00ebshimi i SGBD SQLite 3.38 dhe paket\u00ebs s\u00eb mjeteve sqlite-utils 3.24","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
\u00cbsht\u00eb publikuar versioni SQLite 3.38, nj\u00eb SGBD i leht\u00eb, i dizajnuar si nj\u00eb bibliotek\u00eb e integruar. Kodi i SQLite shp\u00ebrndahet si pron\u00eb e p\u00ebrbashk\u00ebt (public domain), dmth. mund t\u00eb p\u00ebrdoret pa kufizime dhe falas p\u00ebr \u00e7do q\u00ebllim. Mb\u00ebshtetje financiare p\u00ebr zhvilluesit e SQLite ofron nj\u00eb konsorcium t\u00eb ve\u00e7ant\u00eb, 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 operator\u00ebt -> dhe ->>, q\u00eb thjeshtojn\u00eb nxjerrjen e t\u00eb dh\u00ebnave n\u00eb formatin JSON. Sintaksa e operator\u00ebve t\u00eb rinj \u00ebsht\u00eb e p\u00ebrputhshme me MySQL dhe PostgreSQL.\n
Funksioni SQL printf() \u00ebsht\u00eb riem\u00ebruar si format() p\u00ebr t\u00eb p\u00ebrmir\u00ebsuar p\u00ebrputhshm\u00ebrin\u00eb me SGBD t\u00eb tjera (mb\u00ebshtetje p\u00ebr emrin e vjet\u00ebr \u00ebsht\u00eb ruajtur).\n
N\u00eb implementimin e tabelave virtuale jan\u00eb shtuar nd\u00ebrfaqe t\u00eb reja programore: sqlite3_vtab_distinct(), sqlite3_vtab_rhs_value() dhe sqlite3_vtab_in(), si dhe lloje t\u00eb reja operator\u00ebsh SQLITE_INDEX_CONSTRAINT_LIMIT dhe SQLITE_INDEX_CONSTRAINT_OFFSET.\n
N\u00eb planifikuesin e k\u00ebrkesave \u00ebsht\u00eb aktivizuar nj\u00eb struktur\u00eb probabiliste bloom filter p\u00ebr t\u00eb p\u00ebrshpejtuar ekzekutimin e k\u00ebrkesave t\u00eb m\u00ebdha analitike, e cila p\u00ebrdoret p\u00ebr t\u00eb p\u00ebrcaktuar pranin\u00eb e nj\u00eb elementi n\u00eb nj\u00eb grup. P\u00ebr optimizimin e p\u00ebrpunimit t\u00eb blloqeve UNION dhe UNION ALL, q\u00eb mbulojn\u00eb shprehjet SELECT me seksione ORDER BY, \u00ebsht\u00eb p\u00ebrdorur nj\u00eb pem\u00eb t\u00eb balancuar t\u00eb bashkimit. <\/ul>\n
Gjithashtu, mund t\u00eb theksohet publikimi i versionit t\u00eb paket\u00ebs sqlite-utils 3.24, q\u00eb p\u00ebrfshin mjete dhe bibliotek\u00ebn p\u00ebr manipulimin e skedhave me databazat SQLite. Operacionet e mb\u00ebshtetura p\u00ebrfshijn\u00eb ngarkimin e t\u00eb dh\u00ebnave JSON, CSV ose TSV direkt n\u00eb skedarin e databaz\u00ebs me krijimin automatik t\u00eb skem\u00ebs s\u00eb nevojshme t\u00eb ruajtjes, ekzekutimin e k\u00ebrkesave SQL mbi skedaret CSV, TSV dhe JSON, realizimin e k\u00ebrkimeve me fjal\u00eb t\u00eb plota n\u00eb databaz\u00eb, transformimin e t\u00eb dh\u00ebnave dhe skemave t\u00eb ruajtjes n\u00eb situata kur ALTER TABLE nuk \u00ebsht\u00eb i aplikuesh\u00ebm (p\u00ebr shembull, p\u00ebr t\u00eb ndryshuar llojin e kolonave), dhe nxjerrjen e kolonave n\u00eb tabela t\u00eb ve\u00e7anta. \n Burimi: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"