Ukukhutshwa kwe-DBMS SQLite 3.30

ipapashiwe ukukhulula I-SQLite 3.30.0, i-DBMS ekhaphukhaphu eyenzelwe njengelayibrari yeplagi. Ikhowudi yeSQLite isasazwa njengendawo yoluntu, okt. inokusetyenziswa ngaphandle kwezithintelo kwaye simahla kuyo nayiphi na injongo. Inkxaso yemali kubaphuhlisi beSQLite inikezelwa yi-consortium eyenziwe ngokukodwa, equka iinkampani ezifana ne-Adobe, i-Oracle, i-Mozilla, i-Bentley kunye ne-Bloomberg.

Siseko utshintsho:

• Yongeza ukukwazi ukusebenzisa intetho "Hluza» ngemisebenzi edityanisiweyo, eyenza kube nokwenzeka ukucutha ukugqunywa kwedatha elungiswa ngumsebenzi odityanisiweyo kwiirekhodi kuphela ezanelisa imeko ethile;
• Ibhloko ethi "ORDER BY" ibonelela ngenkxaso kwi "I-NULLS KUQALA"Kwaye"I-NULLS GQIBELA» ukumisela indawo ekhoyo yezinto ezinexabiso eli-NULL xa uhlela;
• Umyalelo ".ukuphila» ukubuyisela imixholo yeefayile ezonakalisiweyo kuluhlu lwedatha;
• Ekwandiseni UBI inkxaso yongeziwe izalathiso zamagama;
• I-PRAGMA index_info kunye ne-PRAGMA index_xinfo zandisiwe ukunika ulwazi malunga nogcino logcino lweetheyibhile ezidalwe "NGAPHANDLE KWE-ROWID" imo;
• I-API eyongeziweyo sqlite3_drop_modules(), ekuvumela ukuba uthintele ukulayishwa okuzenzekelayo kweetafile ezinenyani kwisicelo;
• I-database schema parser iye yatshintshwa ukuze ibonise impazamo xa uhlobo, igama, kunye ne-tbl_name columns kwi-sqlite_master table yonakele xa iqhagamshelwe ingekho kwimowudi ye-writable_schema;
• I-PRAGMA function_list, PRAGMA module_list kunye nePRAGMA pragma_list imiyalelo yenziwe ngokungagqibekanga. Ukutshintsha indlela yokuziphatha engagqibekanga yokwakha, kufuneka ucacise ngokucacileyo "-DSQLITE_OMIT_INTROSPECTION_PRAGMAS";
• Kusetyenziso oluchaziweyo lwemisebenzi yeSQL, iflegi yeSQLITE_DIRECTONLY iyacetywa, ekuvumela ukuba uthintele ukusetyenziswa kwale misebenzi ngaphakathi kwezichukumisi kunye neembono.

umthombo: opennet.ru