Ukukhishwa kwe-DBMS SQLite 3.30

eshicilelwe ukukhululwa I-SQLite 3.30.0, i-DBMS engasindi edizayinelwe njengomtapo wolwazi ofakiwe. Ikhodi ye-SQLite isatshalaliswa njengesizinda somphakathi, i.e. ingasetshenziswa ngaphandle kwemikhawulo futhi mahhala nganoma iyiphi injongo. Usekelo lwezezimali lwabathuthukisi be-SQLite luhlinzekwa yinhlangano edalwe ngokukhethekile, ehlanganisa izinkampani ezifana ne-Adobe, i-Oracle, i-Mozilla, i-Bentley ne-Bloomberg.

main shintsha:

• Kwengezwe ikhono lokusebenzisa isisho esithi "FILTER» ngemisebenzi ehlanganisiwe, okwenza kube nokwenzeka ukukhawula ukumbozwa kwedatha ecutshungulwa umsebenzi we-aggregate kumarekhodi kuphela anelisa umbandela othile;
• Ibhulokhi ethi "ORDER BY" inikeza ukusekelwa "I-NULLS KUQALA"Futhi"I-NULLS EGCINA» ukunquma indawo yezakhi ezinevelu engu-NULL lapho ihlungwa;
• Umyalo ".lulama»ukubuyisela okuqukethwe kwamafayela alimele kusizindalwazi;
• Ekwandiseni I-RBU ukwesekwa kwengeziwe izinkulumo zokukhomba;
• I-PRAGMA index_info kanye ne-PRAGMA index_xinfo kunwetshiwe ukuze kunikeze ulwazi mayelana nesakhiwo sesitoreji samathebula adalwe ngemodi ethi "NGAPHANDLE I-ROWID";
• I-API eyengeziwe ama-sqlite3_drop_modules(), okukuvumela ukuthi uvimbele ukulayishwa okuzenzakalelayo kwamatafula abonakalayo kusuka kuhlelo lokusebenza;
• Umhlaziyi we-schema sesizindalwazi ushintshiwe ukuze ubonise iphutha lapho uhlobo, igama, kanye namakholomu e-tbl_name kuthebula le-sqlite_master konakele lapho kuxhunywe ku-writable_schema mode;
• I-PRAGMA function_list, PRAGMA module_list kanye ne-PRAGMA pragma_list imiyalo inikwe amandla ngokuzenzakalelayo. Ukuze uguqule ukuziphatha kokwakha okuzenzakalelayo, kufanele ucacise "-DSQLITE_OMIT_INTROSPECTION_PRAGMAS";
• Ngemisebenzi ye-SQL echazwe ngohlelo lokusebenza, kuhlongozwa ifulegi le-SQLITE_DIRECTONLY, elikuvumela ukuthi uvimbele ukusetshenziswa kwale misebenzi ngaphakathi kwezibangeli nokubuka.

Source: opennet.ru