{"id":116050,"date":"2024-05-24T08:59:21","date_gmt":"2024-05-24T06:59:21","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-sqlite-3-46"},"modified":"2024-05-24T08:59:21","modified_gmt":"2024-05-24T06:59:21","slug":"vypusk-subd-sqlite-3-46","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/news\/vypusk-subd-sqlite-3-46","title":{"rendered":"L\u00ebshimi i DBMS SQLite 3.46","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
\u00cbsht\u00eb publikuar versioni SQLite 3.46, nj\u00eb DBMS e leht\u00eb, e strukturuar si nj\u00eb bibliotek\u00eb e integruar. Kodi SQLite shp\u00ebrndahet si pron\u00ebsi publike, q\u00eb do t\u00eb thot\u00eb se 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 konsorcium i krijuar posa\u00e7\u00ebrisht. <\/p>\n
\u00cbsht\u00eb shtuar funksioni SQL json_pretty() p\u00ebr gjenerimin e nj\u00eb daljeje m\u00eb t\u00eb lexueshme n\u00eb formatin JSON, e cila \u00ebsht\u00eb formatizuar duke p\u00ebrdorur t\u00ebrheqje me hap\u00ebsira.\n
Jan\u00eb zgjeruar mund\u00ebsit\u00eb e operacionit «PRAGMA optimize», i cili realizon optimizimin e DB-s\u00eb dhe t\u00eb gjitha skemave t\u00eb t\u00eb dh\u00ebnave p\u00ebr t\u00eb arritur performanc\u00ebn m\u00eb t\u00eb mir\u00eb t\u00eb k\u00ebrkesave. \u00cbsht\u00eb implementuar nj\u00eb limit automatik p\u00ebr koh\u00ebzgjatjen e analiz\u00ebs s\u00eb DB-s\u00eb, duke p\u00ebrjashtuar koh\u00ebzgjatjen shum\u00eb t\u00eb madhe t\u00eb p\u00ebrpunimit p\u00ebr DB t\u00eb m\u00ebdha. \u00cbsht\u00eb shtuar nj\u00eb mask\u00eb bitore e re «PRAGMA optimize(0x10000)» p\u00ebr kontrollin e ve\u00e7ant\u00eb t\u00eb p\u00ebrdit\u00ebsimeve n\u00eb t\u00eb gjitha tabelat. \u00cbsht\u00eb siguruar nj\u00eb analiz\u00eb automatikisht e p\u00ebrs\u00ebritur e tabelave q\u00eb nuk kan\u00eb sh\u00ebnime t\u00eb sqlite_stat1.\n
N\u00eb funksionet SQL p\u00ebr pun\u00ebn me data dhe or\u00eb jan\u00eb shtuar modifikator\u00ebt e rinj ceiling dhe floor p\u00ebr menaxhimin e p\u00ebrpunimit t\u00eb datave ambigue, t\u00eb cilat ndodhin gjat\u00eb operacioneve t\u00eb zhvendosjes s\u00eb datave p\u00ebr nj\u00eb num\u00ebr t\u00eb caktuar muajsh ose vitesh. \u00cbsht\u00eb siguruar injorimi i modifikator\u00ebve utc dhe localtime, n\u00ebse SQLite ka informacion q\u00eb koha \u00ebsht\u00eb tashm\u00eb n\u00eb paraqitjen UTC ose localtime.\n
Jan\u00eb realizuar optimizime n\u00eb planifikuesin e k\u00ebrkesave. P\u00ebr shprehjet INSERT, t\u00eb cilat p\u00ebrmbajn\u00eb mij\u00ebra vlera n\u00eb seksionin VALUES, optimizimi «VALUES-as-coroutine» \u00ebsht\u00eb aktivizuar automatikisht, duke lejuar nj\u00eb rritje t\u00eb af\u00ebrt me dyfish t\u00eb shpejt\u00ebsis\u00eb s\u00eb analiz\u00ebs s\u00eb k\u00ebtyre shprehjeve dhe duke reduktuar dyfish konsumimin e memories. P\u00ebr k\u00ebrkesat e tipit «SELECT count(DISTINCT col) FROM …» \u00ebsht\u00eb e lejuar p\u00ebrdorimi i indekseve, edhe n\u00ebse madh\u00ebsia e regjistrimeve n\u00eb indeks nuk \u00ebsht\u00eb m\u00eb e vog\u00ebl se regjistrimet n\u00eb tabel\u00eb. \u00cbsht\u00eb p\u00ebrmir\u00ebsuar logjika e p\u00ebrcaktimit t\u00eb situatave kur n\u00eb argumentet e funksioneve SQL jepen konstanta. \u00cbsht\u00eb siguruar aplikimi i optimizimit push-down p\u00ebr shprehjet WHERE, t\u00eb cilat p\u00ebrmbajn\u00eb n\u00ebnk\u00ebrkesa t\u00eb pa lidhura.\n
\u00cbsht\u00eb ndryshuar logjika e trajtimit t\u00eb mbip\u00ebrmbajtjes s\u00eb stack-ut \u2014 kur zbulohet mungesa e memories p\u00ebr stack-un, parser tani p\u00ebrpiqet t\u00eb alokoj\u00eb memory shtes\u00eb nga heap, n\u00eb vend q\u00eb t\u00eb nxjerr\u00eb nj\u00eb gabim «parser stack overflow».\n
N\u00eb JSON lejohet t\u00eb jepen karaktere kontrolli n\u00eb literalet string t\u00eb JSON5. \u00cbsht\u00eb ndryshuar logjika e funksionimit t\u00eb operator\u00ebve «->» dhe «->>», kur n\u00eb an\u00ebn e djatht\u00eb operand\u00ebt string p\u00ebrmbajn\u00eb vet\u00ebm numra (n\u00eb p\u00ebrputhje me PostgreSQL, k\u00ebta operanda tani trajtohen si string).\n
N\u00eb vler\u00ebn DEFAULT n\u00eb kolonat e tabelave lejohet specifikimi i literal\u00ebve t\u00eb m\u00ebdhenj gjeksadecimale. <\/ul>\n