Isikhishwe i-SQLite 3.35 futhi kulokhu kukhishwa okusha kwalo mphathi wedatha izengezo zomsebenzi wezibalo zigqanyisiwe, kanye nokwesekwa kwesisho se-ALTER TABLE DROP COLUMN sokulahla amakholomu etafuleni, ukusebenza okuthuthukisiwe, nokuningi.
Kulabo abangajwayele iphakethe le-SQLite yi-DBMS engasindi, yakhelwe njengomtapo wezincwadi we-plugin. Ikhodi ye-SQLite isatshalaliswa njengezizinda zomphakathi, okungukuthi, ingasetshenziswa ngaphandle kwemingcele futhi mahhala nganoma iyiphi injongo.
Izici ezintsha eziyinhloko ze-SQLite 3.35
Njengoba kushiwo ekuqaleni, kule nguqulo entsha imisebenzi eyakhelwe ngaphakathi yezibalo ingeziwe (log2 (), cos (), tg (), exp (), ln (), pow (), njll.) engasetshenziswa ku-SQL. Ukuze unike amandla imisebenzi eyakhelwe ngaphakathi, umhlangano onenketho ye "-DSQLITE_ENABLE_MATH_FUNCTIONS" uyadingeka.
Isisho "ALTER TABLE DROP COLUMN" manje isekela ukulahla amakholomu etafuleni bese ususa idatha ebigcinwe phambilini kule kholamu.
Ukuqaliswa komsebenzi we-UPSERT (engeza noma uguqule), okukuvumela ukuthi usebenzise izinkulumo ezinjenge- "INSERT ON CONFLICT DO NOTHING / UPDATE" ukushaya indiva iphutha noma ukwenza isibuyekezo esikhundleni sokufaka uma kungenzeki ukufaka idatha nge- "INSERT" (ngokwesibonelo, uma irekhodi, UPDATE kungenziwa esikhundleni se-INSERT).
Enguqulweni entsha, kuvunyelwe ukucacisa amabhulokhi ambalwa «NGOKUXABANA«, Okuzocutshungulwa ngokulandelana. Kubhulokhi lokugcina le- "ON CONFLICT", kuvunyelwe ukungacacisi ipharamitha yencazelo yengxabano ukusebenzisa i- "DO UPDATE".
Imisebenzi DELETE, INSERT kanye ne-UPDATE zisekela isisho sokubuyisa, engasetshenziswa ukubonisa okuqukethwe kwerekhodi elisusiwe, elifakiwe, noma eliguquliwe. Isibonelo, okuthi "faka ku-ID ebuyayo" kuzobuyisa isikhombi somugqa esingeziwe, futhi "buyekeza ... setha intengo = intengo * 1.10 inani elibuyayo" lizobuyisa inani lentengo ebuyekeziwe.
Okwezisho zetafula ezijwayelekile (i-Common Table Expression, i-CTE), evumela ukusetshenziswa kwamasethi emiphumela aqanjwe okwesikhashana, kusetshenziswa i-WITH kubuze opharetha, kugunyaze ukukhethwa kwezinhlobo «IZIMPAHLA» kanye ne- «HHAYI ZIBALULEKILE».
- "IMATERIALIZED" isho ukulondoloza isikhashana umbuzo obalulwe ekubukweni kwithebula elihlukile lomzimba ngokuthola okulandelayo kwedatha kuleli thebula.
- Futhi nge- "HHAYI OKWENZEKILE", imibuzo ephindaphindiwe izokwenziwa njalo lapho umbono utholakala. Ekuqaleni, i-SQLite ihluleke yaba yi- "NOT MATERIALIZED" kepha manje isishintshelwe ku- "MATERIALIZED" yama-CTEs asetshenziswa ngaphezu kwesikhathi esisodwa.
Kwezinye izinguquko okuvelele kule nguqulo entsha:
- Ukusetshenziswa kwememori okuncishisiwe lapho kwenziwa imisebenzi ye-VACUUM yolwazi olufaka amanani amakhulu kakhulu anezinhlobo ze-TEXT noma ze-BLOB.
- Umsebenzi wenziwe ukwandisa ukusebenza kwesilungisi se-optimizer kanye nemibuzo.
- Ukulungiselela kwengezwe lapho kusetshenziswa imisebenzi ye-min ne-max ngegama elithi "IN".
- Ukusetshenziswa kwesitatimende se-EXISTS kusheshisiwe.
- Ukunwetshwa kwezinto ezibuzwayo ze-UNION ZONKE izinkulumo ezisetshenziswe ku-JOIN kuyenziwa.
- Inkomba esetshenziselwe IZINHLOBO ZONKE.
- Ukuguqulwa kwe- "x IS NULL" ne- "x IS NOT NULL" ku-FALSE noma i-TRUE kunikezwe ngamakholomu anomaka we-"NOT NULL".
- Ukuhlolwa kokhiye wangaphandle ku-UPDATE kweqiwe uma umsebenzi ungashintshi amakholomu ahlobene nokhiye wangaphandle.
- Ukuhambisa izingxenye zesigatshana esithi LAPHO kuya emibuzweni engaphansi equkethe imisebenzi yewindows kuvunyelwe uma lezi zingxenye zikhawulelwe ekusebenzeni okungaguquki namakhophi ezinkulumo zesigatshana se- "PARTITION BY" ezisetshenziswe kwimisebenzi yewindi.
Izinguquko kusixhumi esibonakalayo somugqa womyalo:
- Kungezwe umyalo ".filectrl data_version".
- Imiyalo ye- ".once" ne ".output" ingeze ukusekelwa kokudlulisa okukhiphayo kusilawuli esibizwa kusetshenziswa amapayipi angenagama ("|").
- Umyalo ". Wezibalo" ungeze ama-agumenti e- "stmt" kanye ne- "vmstep" ukubonisa izibalo kuzibali zomshini ezibonakalayo nezinkulumo.
Okokugcina uma unentshisekelo yokwazi kabanzi ngakho mayelana nale nguqulo entsha ye-SQLite, ungabheka imininingwane ngokuya kusixhumanisi esilandelayo.