Ukukhishwa kwe-DBMS SQLite 3.29

eshicilelwe ukukhululwa I-SQLite 3.29.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 izinketho ze-SQLITE_DBCONFIG_DQS_DML kanye ne-SQLITE_DBCONFIG_DQS_DDL ku-sqlite3_db_config() ukuze kulawulwe ukuthi ukuphathwa kwekhwothi okukodwa nokukabili kuvuliwe. I-SQlite ekuqaleni ibisekela noma yiziphi izimpawu zengcaphuno zeyunithi yezinhlamvu nezihlonzi, kodwa izinga le-SQL lidinga ngokusobala ukusetshenziswa kwezimpawu zokucaphuna zochungechunge lwezinhlamvu ezingokoqobo kanye nezimpawu zokucaphuna ezikabili ezihlonzi (njengamagama ekholomu). Ukuziphatha kwe-SQLite kuyaqhubeka nokusekelwa ngokuzenzakalelayo, futhi inketho yokwakha ethi "-DSQLITE_DQS=0" inikezwa ukuze kuvunyelwe ukuthobela izinga;
• Ukuthuthukisa kungeziwe kusihleli semibuzo ukuze kusheshiswe ukusebenza kwe-AND kanye ne-OR opharetha lapho enye yama-operand ingashintshi, kanye nomsebenzi othi LIKE lapho ikholomu ecaciswe kwesokunxele iyinombolo;
• Kwengezwe ithebula elibonakalayo elisha elithi "sqlite_dbdata" ukuze kutholwe okuqukethwe ezingeni ledatha yekholomu yomthombo, noma ngabe isizindalwazi sonakele;
• Ku-interface ye-CLI kwengezwe umyalo othi “.recover”, ozama ukubuyisela idatha kusizindalwazi esilimele ngangokunokwenzeka. Kuphinde kwengezwe umyalo othi ".filectrl" wokuqalisa ukuhlola kanye nomyalo othi ".dbconfig" wokubuka noma ukushintsha izinketho ze-sqlite3_db_config().

Source: opennet.ru