SQLite iyinjini yedatha yobudlelwano engasindi, efinyeleleka ngolimi lwe-SQL. Ngokungafani namaseva wedatha yendabuko, njenge-MySQL noma i-PostgreSQL, ukubonakala kwayo akuyona into yokukhiqiza kabusha uhlelo olujwayelekile lwamakhasimende, kepha ukuhlanganisa ngqo ezinhlelweni.
Imininingwane ephelele (izitatimende, amatafula, izinkomba kanye nedatha) igcinwa kwifayela elizimele lepulatifomu. Ngenxa yokukhanya kwayo okwedlulele, phakathi kwabanye, isetshenziswa ezinhlelweni eziningi zabathengi futhi futhi ithandwa kakhulu ezinhlelweni ezishumekiwe, kufaka phakathi ama-smartphones anamuhla kakhulu.
Uhlobo 3.25. Uhlobo luhlehlela emuva kuSepthemba 2018. Ku-version 3.25, i-SQLite inikeze ukusekelwa kwemisebenzi ye-Windows, okunye ukuthuthuka kumyalo we-ALTER TABLE ne-optimizer yombuzo, kanye nezinye izici eziningana ezintsha.
Ngokwalolu hlobo, I-SQLite ingeze ukusekelwa kokuqamba kabusha amakholomu etafuleni kusetshenziswa itafula ALTER TABLE Qamba kabusha igama lekholamu ku-newname.
Igama lekholomu lishintshwa zombili encazelweni yetafula uqobo njengakuzo zonke izinkomba, izingqinamba, nokubukwa okukhomba kukholamu.
Uma ukuqamba kabusha ikholomu kubangela ukungaqondakali kwe-semantic ku-trigger noma ekubukeni, Qamba kabusha IKHOLAMU yehluleka ngephutha futhi akukho zinguquko ezisetshenziswayo.
Uhlobo olusha lwe-SQLite, inguqulo 3.28 futhi iletha izici eziningi ezintsha nokuthuthuka. Izici ezintsha eziphawuleka kakhulukufaka phakathi ukuthuthuka kuzici zeWindows, ukuthuthuka kusixhumi esibonakalayo se-TCL.
Ukwengezwa kwama-API amasha, ukuphatha okunamandla kwamafayili wedatha okonakele, nokunye ukuthuthuka okuhlukahlukene. Ukuthuthuka kwezici zeWindows ikakhulukazi kunezengezo ezintsha ezigabeni ezintsha nakwimidiya emisha.
Ukuhluka okusha ku-EXCLUDE
Siphawula ukungezwa kwesigatshana esisha sokuzikhethela esithi "KHIPHA" esinezinhlobonhlobo ezine:
- NGAPHANDLE KWABANYE: Leli inani elizenzakalelayo. Kulokhu, awukho umugqa okhishiwe kufreyimu yomsebenzi wewindows njengoba kuchazwe yimikhawulo yawo yokuqala nokuphela.
- KHIPHA UMUGQA WAMANJE: Kulokhu, umugqa wamanje awufakiwe ebhokisini lomsebenzi. Amabili kumugqa wamanje ahlala etafuleni lohlobo lwe-GROUP no-RANGE lwetafula;
- KHIPHA IQEMBU: Kulokhu, umugqa wamanje nayo yonke eminye imigqa eyi-line yamanje ayifakiwe ebhokisini. Lapho isigatshana se-EXCLUDE sicutshungulwa, yonke imigqa ene-ORDER efanayo ngamanani noma yonke imigqa esehlukanisweni ngokungabi khona kwe-ORDER BY clause ibhekwa ngisho, noma ngabe uhlobo lohlaka luyi-ROWS.
- Khipha izibopho: Esimweni sokugcina, ulayini wamanje uyingxenye yohlaka, kepha ozakwabo abakhishiwe.
Izici ezithuthukisiwe
Futhi ezingeni lemisebenzi yewindi, ukwesekwa kungezelwa ukushintsha amawindi, ukuxhaswa kwamakhadi we-GROUPS kungeziwe.
Kuyangezwa ukuma kwemingcele « KUDLULISELWA »Futhi» UKULANDELA «ezinhlakeni ze-RANGE, engeza isikhombimsebenzisi esisha se-sqlite3_stmt_isexplain ukuthola ukuthi isitatimende esilungisiwe siyincazelo noma cha futhi sithuthukisa i-VACUUM INTO ukusebenzela imininingwane yolwazi yokufunda kuphela
Ngasohlangothini lwesixhumi se-TCL, inketho -returntype ingezwe kundlela yokusebenza nokwengezwa kwendlela entsha ye-bind_fallback.
I-Las ukuthuthuka okwenziwe ku-CLI kuningi. Kuleli zinga, siphawula ukungezwa kwe-sqlite3_value_frombind () API ukuthola ukuthi impikiswano yomsebenzi we-SQL ivela kupharamitha eboshiwe.
Ukungezwa kokusekelwa kwamapharamitha aboshiwe nomyalo weparamitha, ukulungisa umsebenzi we-writefile () ukuze kuthi lapho kwakhiwa izinkomba ezintsha endleleni yefayela elisha kubanikeze izimvume ze-umask esikhundleni sezimvume ezifanayo nefayela.
Wayengeza neFossildelta.c ukudala, ukusebenzisa nokukhubaza ifomethi ye-delta yefayela le-Fossil DVCS elisetshenziswa isandiso se-RBU nezinye izithuthukisi.
Kwi-SQLite 3.28, siphinde saqaphela nemizamo eyenziwe yokwenza imibuzo isheshe.
Si Ufuna ukwazi kabanzi nge-SQLite futhi futhi ulande le nguqulo entsha ongayivakashela isixhumanisi esilandelayo.