{"id":168285,"date":"2026-04-10T11:12:04","date_gmt":"2026-04-10T09:12:04","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-sqlite-3-53"},"modified":"2026-04-10T11:12:04","modified_gmt":"2026-04-10T09:12:04","slug":"vypusk-subd-sqlite-3-53","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/vypusk-subd-sqlite-3-53","title":{"rendered":"L\u00ebshimi i SGBD SQLite 3.53","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
\u00cbsht\u00eb publikuar l\u00ebshimi i SQLite 3.53, nj\u00eb DBMS e leht\u00eb, e cila \u00ebsht\u00eb e nd\u00ebrtuar si nj\u00eb bibliotek\u00eb e integruar. L\u00ebshimi 3.52 u anulua. Kodi SQLite shp\u00ebrndahet si pron\u00eb publike, dometh\u00ebn\u00eb mund t\u00eb p\u00ebrdoret pa kufizime dhe falas p\u00ebr \u00e7do q\u00ebllim. Mb\u00ebshtetja financiare p\u00ebr zhvilluesit e SQLite sigurohet nga nj\u00eb konsorcium i krijuar posa\u00e7\u00ebrisht. <\/p>\n
Ndryshimet kryesore: <\/p>\n
\n
Korrigjohet nj\u00eb gabim q\u00eb \u00e7onte n\u00eb d\u00ebmtimin e DB-s\u00eb. Problemi ka qen\u00eb prezent q\u00eb nga versioni SQLite 3.7.0 (viti 2010), duke prekur DB-n\u00eb n\u00eb modalitetin WAL (Write-Ahead Logging) dhe duket p\u00ebr shkak t\u00eb nj\u00eb gjendjeje garuese kur hapeshin dy ose m\u00eb shum\u00eb lidhje me DB-n\u00eb q\u00eb p\u00ebrpiqeshin t\u00eb shkruanin ose ratifikonin transaksionet n\u00eb nj\u00eb instanc\u00eb t\u00eb vetme t\u00eb DB-s\u00eb. Ajo q\u00eb \u00e7on n\u00eb d\u00ebshtim ndodhin jasht\u00ebzakonisht rrall\u00eb dhe \u00ebsht\u00eb arritur t\u00eb riprodhohet vet\u00ebm n\u00eb nj\u00eb skenar testi t\u00eb krijuar posa\u00e7\u00ebrisht.\n
Shtuar komanda «REINDEX EXPRESSIONS» p\u00ebr rind\u00ebrtimin e indekseve mbi shprehje, n\u00eb t\u00eb cilat si element indeksi p\u00ebrdoret nj\u00eb funksion mbi nj\u00eb kolon\u00eb ose operacione mbi kolona. Komanda mund t\u00eb p\u00ebrdoret p\u00ebr t\u00eb rikuperuar indekset e zakonshme.\n
Brenda trigger\u00ebve t\u00eb p\u00ebrkohsh\u00ebm, t\u00eb krijuar nga komanda «CREATE TEMP TRIGGER» dhe t\u00eb aplikuar n\u00eb tabela n\u00eb baza t\u00eb tjera t\u00eb t\u00eb dh\u00ebnave, \u00ebsht\u00eb lejuar modifikimi i tabelave ose k\u00ebrkesat p\u00ebr t\u00eb dh\u00ebna nga tabelat.\n
N\u00eb komand\u00ebn «VACUUM INTO» duke specifikuar skedarin q\u00ebllim p\u00ebrmes URL-s\u00eb \u00ebsht\u00eb realizuar p\u00ebrdorimi i parametrin «reserve=N» p\u00ebr t\u00eb p\u00ebrcaktuar numrin e kopjeve rezerv\u00eb t\u00eb krijuara t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave.\n
Jan\u00eb realizuar funksione t\u00eb reja SQL json_array_insert() dhe jsonb_array_insert() p\u00ebr t\u00eb futur element\u00eb n\u00eb tabelat JSON.\n
\u00cbsht\u00eb shtuar dhe aktivizuar n\u00eb utilitarin e komand\u00ebs biblioteka QRF (Query Result Formatter) p\u00ebr formatimin e rezultateve t\u00eb ekzekutimit t\u00eb k\u00ebrkesave SQL n\u00eb nj\u00eb form\u00eb t\u00eb leht\u00eb p\u00ebr t'u lexuar.\n
Ndryshimet n\u00eb utilitarin e komand\u00ebs:\n
\n
Komanda «.mode» \u00ebsht\u00eb zgjeruar duksh\u00ebm.\n
\u00cbsht\u00eb p\u00ebrmir\u00ebsuar formimi i daljes, p\u00ebr shembull, \u00ebsht\u00eb p\u00ebrfshir\u00eb si parazgjedhje vizatimi i kufijve, dhe vlerat numerike tani jan\u00eb t\u00eb rregulluara n\u00eb t\u00eb djathta n\u00eb daljen e tabuluar.\n
Siguruar injorimin e simboleve «;» pas komandave.\n
P\u00ebrmbajtja e skedar\u00ebve t\u00eb specifikuar n\u00eb komand\u00ebn e linj\u00ebs me extension *.sql dhe *.txt tani lexohen dhe interpretohen si sete t\u00eb shprehjeve SQL dhe komandave dot.\n
N\u00eb komand\u00ebn «.progress» \u00ebsht\u00eb shtuar opsioni «—timeout S» p\u00ebr t\u00eb detyruar nd\u00ebrprerjen e shprehjes SQL pas skadimit t\u00eb koh\u00ebs.\n
N\u00eb komand\u00ebn «.indexes» \u00ebsht\u00eb ndryshuar sjellja e shablloneve, t\u00eb cilat tani aplikohen n\u00eb emrat e indekseve dhe jo n\u00eb emrat e tabelave t\u00eb indekseve. <\/ul>\n
Jan\u00eb b\u00ebr\u00eb optimizime n\u00eb planifikuesin e k\u00ebrkimeve, duke p\u00ebrshpejtuar pun\u00ebn me bashkimin e tabelave dhe operacionet EXCEPT, INTERSECT dhe UNION.\n
\u00cbsht\u00eb rritur performanca e funksioneve p\u00ebrkthimi t\u00eb numrave me presje t\u00eb l\u00ebvizshme n\u00eb p\u00ebrfaq\u00ebsim tekstual.\n
N\u00eb implementimin q\u00eb kompilohet n\u00eb kodin nd\u00ebrlidh\u00ebs WebAssembly \u00ebsht\u00eb shtuar VFS «opfs-wl», e cila \u00ebsht\u00eb identike me VFS «opfs», por p\u00ebrdor API Web Locks p\u00ebr t\u00eb punuar me bllokadat.\n