Ukupapashwa kwe-SQLite 3.35 kupapashiwe kwaye kolu hlobo lutsha lomphathi wedatha ukongezwa komsebenzi wemathematics, kunye nenkxaso ye ALTER TABLE DROP COLUMN expression yokulahla iikholamu kwitafile, ukusebenza okuphuculweyo, nokunye okuninzi.
Kulabo abangaqhelekanga ngephakheji ye-SQLite yi-DBMS engasindiYenzelwe njengethala leencwadi. Ikhowudi ye-SQLite isasazwa njengommandla woluntu, Oko kukuthi, inokusetyenziswa ngaphandle kwezithintelo kwaye ngaphandle kwentlawulo ngayo nayiphi na injongo.
Iimpawu ezintsha eziphambili ze-SQLite 3.35
Njengoko kukhankanyiwe ekuqaleni, kule nguqulo intsha imisebenzi eyakhelweyo kwimathematics yongezwa (log2 (), cos (), tg (), exp (), ln (), pow (), njl.) enokusetyenziswa kwi-SQL. Ukwenza imisebenzi eyakhelwe-ngaphakathi, indibano enokhetho "-DSQLITE_ENABLE_MATH_FUNCTIONS" iyafuneka.
I binzana "NGAPHAMBI KWETHUBA YOKUTSHAYA IKHOLAM" ngoku ixhasa ukulahla iikholamu kwitafile kwaye ucime idatha ebigcinwe ngaphambili kule kholamu.
Ukuphunyezwa komsebenzi we-UPSERT (Yongeza okanye uguqule), ekuvumela ukuba usebenzise amabinzana anje ngo "FAKA KWIMBAMBANO UNGENZI NANTSI / HLAZIYA" ukungahoyi impazamo okanye wenze uhlaziyo endaweni yokufaka ukuba akunakwenzeka ukongeza idatha nge "FAKA" (umzekelo, ukuba irekhodi, UKUHLAZIYA kunokwenziwa endaweni yokufaka).
Kwinguqulelo entsha, kuvunyelwe ukukhankanya iibhloko ezininzi «KWIMPAWU«, Eza kuthi ziqhubekeke ngokulandelelana. Kwibhlokhi yokugqibela "KWI-CONFLICT", kuvunyelwe ukungakhankanyi ipharamitha yenkcazo yongquzulwano ukusebenzisa "YENZA UKUHLAZIYA".
Imisebenzi CIMA, FAKA kwaye UPHANTSE inkxaso ngenkxaso yokubuyisa, enokusetyenziswa ukubonisa umxholo werekhodi ecinyiweyo, efakiweyo, okanye eguqulweyo. Umzekelo, "faka kwi ... ID ebuyayo" izakubuyisa isazisi somqolo esongeziweyo, kwaye "hlaziya ... usete ixabiso = ixabiso * 1.10 ukubuyisa ixabiso" liya kubuyisa ixabiso lamaxabiso ahlaziyiweyo.
Kwiimbonakalo zetheyibhile ngokubanzi (iNgcaciso yeTheyibhile yesiqhelo, i-CTE), evumela ukusetyenziswa kweeseti zeziphumo ezinikwe igama okwethutyana, zisebenzisa i-WITH kubuzwe umqhubi, ivume ukhetho lweendlela «IZIPHAKAMISO» KUNYE "NOZIBALULEKILEYO".
- "IMATRIKI" kuthetha ukufihla umbuzo ochaziweyo kwimbonakalo kwitheyibhile yomzimba ngokwahlukileyo kunye nokufunyanwa kwakhona kwedatha kule tafile.
- Kwaye ngo "AKUNAKHO OKUQHELEKILEYO", imibuzo ephindaphindiweyo iya kwenziwa rhoqo xa umbono ufikeleleka. Ekuqaleni, i-SQLite isilele "AKUKHO MATERIALIZED" kodwa ngoku itshintshelwe kwi "MATERIALIZED" yee-CTEs ezisetyenziswe ngaphezu kwesinye.
Olunye utshintsho evelele kule nguqulo intsha:
- Ukuncitshiswa kwememori xa usenza imisebenzi yeVACUUM yolwazi olubandakanya amaxabiso amakhulu kakhulu ngeTEXT okanye kwiBLOB.
- Umsebenzi sele wenziwe ukwandisa ukusebenza kwesilungisi kunye neshedyuli yemibuzo.
- Ukulungiselela kuye kongezwa xa kusetyenziswa imin kunye nemisebenzi ye-max ngegama elithi "IN".
- Ukuphunyezwa kwengxelo ye-EXISTS kukhawulezisiwe.
- Ukwandiswa kwemibuzo engezantsi kwe-UNION ZONKE amabinzana asetyenziswa kwiJOIN ayenziwa.
- Isalathiso esisetyenziselwe HAYI NUL expression.
- Ukuguqulwa kuka "x AKUPHELELEYO" kunye no "x AKUKHO NULL" ku BUXOKI okanye INYANISO ibonelelwe kwiikholamu ezine- "NOT NULL" iflegi.
- Ukutshekelwa kwesitshixo sangaphandle ku-UPDATE kutsityiwe ukuba umsebenzi awutshintshi iikholamu ezinxulumene nesitshixo sangaphandle.
- Ukuhambisa iinxalenye zegatya LAPHO ukuya kwimibuzo engezantsi enemisebenzi yeefestile kuvunyelwe ukuba la malungu anqunyelwe ekusebenzeni ngokungaguquguqukiyo kunye neekopi ze- "ISIQINISEKISO NGESIQENDU" Amagatya asetyenziswa kwimisebenzi yewindow.
Utshintsho kulungelelwaniso lomgca wokuyalela:
- Yongezwe ".filectrl data_version" command.
- Imiyalelo ".once" kunye ".putput" yongeze inkxaso yokudlulisa imveliso kumlawuli obiziweyo usebenzisa imibhobho engenagama ("|").
- Umyalelo ". Wezibalo" wongeze i "stmt" kunye ne "vmstep" iingxoxo ukubonisa ubalo kumatshini wokubala oomatshini kunye neenkcazo.
Gqibela ukuba unomdla wokwazi okungakumbi ngayo malunga nale nguqulo intsha ye-SQLite, ungajonga iinkcukacha ngokuya kule khonkco ilandelayo.