SQLite Yinjini yolwazi olunobunzima obunobunzima, efikeleleka kulwimi lwe-SQL. Ngokungafaniyo neeseva zesiseko sedatha, ezinje nge-MySQL okanye i-PostgreSQL, ukubaluleka kwayo ayikokuvelisa kwakhona iskimu somncedisi womthengi oqhelekileyo, kodwa ukudibanisa ngqo kwiinkqubo.
Isiseko sedatha esipheleleyo (izibhengezo, iitafile, izalathiso kunye nedatha) igcinwe kwiqonga elizimeleyo lefayile. Enkosi ngokukhanya kwayo okugqithileyo, phakathi kwabanye, isetyenziswa kwiinkqubo zabathengi ezininzi kwaye ikwayaziwa kakhulu kwiinkqubo ezingena ngaphakathi, kubandakanya ezona smartphones zangoku.
Uhlobo lwenguqulo 3.25.ibuyela emva ngoSeptemba 2018. Kuhlelo 3.25, iSQLite ibonelele ngenkxaso yemisebenzi yeWindows, uphuculo oluthile kumyalelo we ALTER TABLE kunye nesicelo sokulungisa, kunye nezinye izinto ezininzi ezintsha.
Ngokwale nguqulo, I-SQLite yongeze inkxaso yokutshintsha kwakhona iikholamu kwitafile usebenzisa Itheyibhile ALTER ITABILE HLAZIYA KHOLAMN igama lakudala UKUYA kwigama elitsha.
Igama lekholomu litshintshiwe zombini kwinkcazo yetafile ngokwayo njengakuzo zonke izalathisi, izivuseleli kunye neemboniselo ezibhekiselele kumhlathi.
Ukuba ukuqamba kwakhona ikholamu kubangela ubumbano lwesemantic kwisiqalo okanye kwimboniselo, RENAME COLUMN ayiphumelelanga ngemposiso kwaye akukho lutshintsho lusetyenziswayo.
Inguqulelo entsha yeSQLite, Inguqulelo 3.28 nayo izisa izinto ezininzi ezintsha kunye nophuculo. Ezona mpawu zintsha ziqaphelekayos zibandakanya ukuphuculwa kweempawu zeWindows, ukuphuculwa kojongano lweTCL.
Ukongezwa kwee-APIs ezintsha, ukuphathwa okunamandla ngakumbi kweefayile zedatha eyonakeleyo, kunye nolunye uphuculo olwahlukeneyo. Uphuculo lweempawu zeWindows ikakhulu izongezo ezitsha kumagatya amatsha kunye nemidiya entsha.
Ukwahluka okutsha UKUKUNGAHLANGANISI
Siqaphela ukongezwa kwegatya elitsha elikhethwayo elithi "EXCLUDE" elinezinto ezine:
- UNGABANDULI ABANYE: Eli lixabiso elimiselweyo. Kulo mzekelo, akukho mgca ukhutshiweyo kwisakhelo somsebenzi wefestile njengoko kuchazwe kukuqala kunye nesiphelo semida.
- UNGABANDISI UMQO O WAKU: Kule meko, umgca wangoku awubandakanywanga kwibhokisi yomsebenzi. Izibini kumqolo wangoku zihlala kwibhokisi ye GROUPS kunye no RANGE iintlobo zebhokisi;
- UNGABANDISI IQELA: Kule meko, umgca wangoku kunye nayo yonke eminye imigca engamabini omgca wangoku ayibandakanywanga kwibhokisi. Xa igatya KUNGAHLANGANISI liphunyeziwe, yonke imiqolo ene-ORDER efanayo NGAmaxabiso okanye yonke imiqolo kwisahlulelo ngokungabikho ko-ORDER BY gatya ithathwa njengezibini, nokuba uhlobo lwesakhelo YIROWS.
- UNGABANDISI AMAQHINGA: Kwimeko yokugqibela, umgca wangoku uyingxenye yesakhelo, kodwa abalingani bayo ababandakanywanga.
Iimpawu eziphuculweyo
Kwakhona kwinqanaba lemisebenzi yefestile, Inkxaso eyongeziweyo kwikhonkco lefestile, inkxaso yongezwa kumakhadi GROUPS.
Yongezwa inkxaso kwimida « I-PRECEDING»Kwaye» OKULANDELAYO "kuluhlu lwesakhelo, ukongeza i-sqlite3_stmt_isexplain entsha ujongano ukujonga ukuba ingaba ingxelo elungisiweyo YINKCAZO okanye hayi kunye nokuphucula iVACUUM INTO ukuze isebenze kumaziko olwazi okufunda kuphela.
Kwi-interface ye-TCL ecaleni, yongeza i--returntype inketho kwindlela yokusebenza kunye nokongezwa kwendlela entsha ye-bind_fallback.
Las uphuculo olwaziswa kwi-CLI zininzi. Kweli nqanaba, siqaphela udibaniso lwe sqlite3_value_frombind() API ukujonga ukuba ingxabano yomsebenzi weSQL ivela kwiparameter ebotshiwe.
Ukongeza inkxaso yeeparameters ezibotshiweyo kunye nomyalelo weparameter, ukulungisa i-writefile () umsebenzi ukuze xa usenza abalawuli abatsha ecaleni kwendlela yefayile entsha ibanika iimvume ze umask endaweni yeemvume ezifanayo njengefayile.
Iphinde yongezwe iFossildelta.c ukwenza, ukusebenzisa kunye nokungamiseli ifomathi ye-delta yeFossil DVCS yefayile esetyenziswa lulwandiso lwe-RBU kunye nolunye uphuculo.
KwiSQLite 3.28, sikwaqaphela iinzame ezenziweyo ukwenza imibuzo ngokukhawuleza.
Si Ukuba ufuna ukwazi ngakumbi malunga neSQLite kunye nendlela yokukhuphela le nguqulo entsha, ungandwendwela eli khonkco lilandelayo.