Ukukhutshwa kwe-DBMS SQLite 3.30.0

Ukukhutshwa kwe-DBMS SQLite 3.30.0 kwenzeka. I-SQLite yi-compact embedded DBMS. Ikhowudi yemvelaphi yethala leencwadi idluliselwe kuyo indawo yoluntu.

Yintoni entsha kuguqulelo 3.30.0:

  • wongeze amandla okusebenzisa ibinzana elithi "ISIHLUNGI" ngemisebenzi edityanisiweyo, eyenze ukuba kube nokwenzeka ukunciphisa ukhuselo lwedatha eqhutywe ngumsebenzi kwiirekhodi kuphela ezisekelwe kwimeko ethile;
  • kwibhloko ethi “ORDER BY”, inkxaso inikezelwa kwiiflegi ze-“NULLS FIRST” kunye ne-“NULLS LAST” ukuze kumiselwe indawo yee-elementi ezinexabiso elingu-NULL xa kulungiswa;
  • wongeze umyalelo othi ".recover" wokubuyisela imixholo yeefayile ezonakalisiweyo ukusuka kwisiseko sedatha;
  • I-PRAGMA index_info kunye ne-PRAGMA index_xinfo zandisiwe ukunika ulwazi malunga nogcino logcino lweetheyibhile ezidalwe "NGAPHANDLE KWE-ROWID" imo;
  • I-API sqlite3_drop_modules() yongezwe ukuvumela ulayisho oluzenzekelayo lweetafile ezinenyani ukuba zingasebenzi;
  • imiyalelo PRAGMA function_list, PRAGMA module_list kunye PRAGMA pragma_list ziyasebenza ngokungagqibekanga;
  • iflegi yeSQLITE_DIRECTONLY yazisiwe, ekuvumela ukuba uthintele usebenziso lwemisebenzi yeSQL ngaphakathi kwezichukumisi kunye neembono;
  • Ukhetho lwelifa SQLITE_ENABLE_STAT3 alusafumaneki.

umthombo: linux.org.ru

Yongeza izimvo