{"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\/novosti-interneta\/vypusk-subd-sqlite-3-46","title":{"rendered":"L\u00ebshimi i DB SQLite 3.46","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
\u00cbsht\u00eb publikuar l\u00ebshimi i SQLite 3.46, nj\u00eb baz\u00eb t\u00eb dh\u00ebnash t\u00eb leht\u00eb, e paraqitur si nj\u00eb bibliotek\u00eb e integruar. Kodi i SQLite shp\u00ebrndahet si pron\u00eb publike, q\u00eb do t\u00eb thot\u00eb se mund t\u00eb p\u00ebrdoret pa kufizime dhe falas 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 t\u00eb gjeneruar nj\u00eb dalje m\u00eb t\u00eb lexueshme n\u00eb formatin JSON, t\u00eb formatuar duke p\u00ebrdorur rreshtimin e blloqeve me hyrje.\n
Jan\u00eb zgjeruar mund\u00ebsit\u00eb e operacionit «PRAGMA optimize», i cili optimizon baz\u00ebn e t\u00eb dh\u00ebnave dhe t\u00eb gjitha skemat e t\u00eb dh\u00ebnave p\u00ebr t\u00eb arritur performanc\u00ebn m\u00eb t\u00eb mir\u00eb t\u00eb pyetjeve. \u00cbsht\u00eb zbatuar nj\u00eb limit automatik p\u00ebr koh\u00ebzgjatjen e analiz\u00ebs s\u00eb t\u00eb dh\u00ebnave, i cili p\u00ebrjashton trajtim t\u00eb tep\u00ebrt n\u00eb baza t\u00eb m\u00ebdha t\u00eb dh\u00ebnash. \u00cbsht\u00eb shtuar nj\u00eb mask\u00eb e re bitore «PRAGMA optimize(0x10000)» p\u00ebr kontrolle t\u00eb ve\u00e7anta t\u00eb azhurnimeve n\u00eb t\u00eb gjitha tabelat. \u00cbsht\u00eb siguruar nj\u00eb analiz\u00eb automatike e p\u00ebrs\u00ebritura e tabelave ku mungojn\u00eb regjistrimet sqlite_stat1.\n
N\u00eb funksionet SQL p\u00ebr pun\u00ebn me data dhe koh\u00ebn jan\u00eb shtuar modifikator\u00eb t\u00eb rinj ceiling dhe floor p\u00ebr t\u00eb kontrolluar p\u00ebrpunimin e datave t\u00eb paqart\u00eb, q\u00eb ndodhin gjat\u00eb operacioneve p\u00ebr l\u00ebvizjen e 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 informacione q\u00eb koha \u00ebsht\u00eb tashm\u00eb n\u00eb p\u00ebrfaq\u00ebsimin UTC ose localtime.\n
Jan\u00eb b\u00ebr\u00eb optimizime n\u00eb planifikuesin e pyetjeve. P\u00ebr shprehjet INSERT q\u00eb p\u00ebrmbajn\u00eb mij\u00ebra vlera n\u00eb seksionin VALUES, \u00ebsht\u00eb aktivizuar si default optimizimi «VALUES-as-coroutine», i cili lejon q\u00eb analiza e till\u00eb t\u00eb jet\u00eb dy her\u00eb m\u00eb e shpejt\u00eb dhe t\u00eb reduktoj\u00eb konsumin e memories me dy her\u00eb. P\u00ebr pyetje t\u00eb tipit «SELECT count(DISTINCT col) FROM …» lejohet p\u00ebrdorimi i indekseve, edhe n\u00ebse madh\u00ebsia e regjistrimeve n\u00eb indeks \u00ebsht\u00eb e barabart\u00eb ose m\u00eb e madhe se ato n\u00eb tabel\u00eb. \u00cbsht\u00eb p\u00ebrmir\u00ebsuar logjika e p\u00ebrcaktimit t\u00eb situatave kur n\u00eb argumentet e funksioneve SQL sh\u00ebnohen constante. \u00cbsht\u00eb siguruar p\u00ebrdorimi i optimizimit push-down p\u00ebr shprehjet WHERE q\u00eb p\u00ebrmbajn\u00eb n\u00ebn-pyetje t\u00eb pap\u00ebrcaktuara.\n
\u00cbsht\u00eb ndryshuar logjika e p\u00ebrpunimit t\u00eb mbipopullimit t\u00eb stack-ut \u2014 kur zbulohet mungese e memories p\u00ebr stack-un, parseri tani p\u00ebrpiqet t\u00eb alokoj\u00eb m\u00eb shum\u00eb memorie nga heap, n\u00eb vend t\u00eb nxjerrjes s\u00eb nj\u00eb gabimi «parser stack overflow».\n
N\u00eb JSON \u00ebsht\u00eb lejuar specifikimi i karaktereve kontrolluese n\u00eb literal\u00ebt string JSON5. \u00cbsht\u00eb ndryshuar logjika e operator\u00ebve «->» dhe «->>» kur n\u00eb an\u00ebn e djatht\u00eb operand string p\u00ebrmban vet\u00ebm numra (n\u00eb p\u00ebrputhje me PostgreSQL, k\u00ebto operanda tani p\u00ebrpunohen si string).\n
N\u00eb vler\u00ebn DEFAULT n\u00eb kolonat e tabelave \u00ebsht\u00eb e lejuar p\u00ebrcaktimi i literal\u00ebve t\u00eb m\u00ebdhenj hexadecimal. <\/ul>\n