Kutulutsidwa kwa DBMS SQLite 3.33

Lofalitsidwa kumasula SQLite 3.33.0, DBMS yopepuka yopangidwa ngati plug-in library. Khodi ya SQLite imagawidwa ngati malo a anthu onse, i.e. itha kugwiritsidwa ntchito popanda zoletsa komanso kwaulere pazifukwa zilizonse. Thandizo lazachuma kwa opanga ma SQLite limaperekedwa ndi bungwe lopangidwa mwapadera, lomwe limaphatikizapo makampani monga Adobe, Oracle, Mozilla, Bentley ndi Bloomberg.

waukulu kusintha:

• Mawu okhazikitsidwa ZOCHITIKA KUCHOKERA KU kukonzanso zomwe zili mutebulo kutengera kusankha kuchokera patebulo lina. Mawuwa amagwiritsa ntchito syntax yogwirizana ndi PostgreSQL.
• Kukula kwakukulu kwa database kwakwezedwa mpaka 281 TB.
• В PRAGMA integrity_check Kutha kuyang'ana patebulo lokhalokha ndi ma index omwe amagwirizana nawo adaperekedwa (poyamba nkhokwe yonse idayang'aniridwa nthawi zonse).
• Zowonjezera zowonjezera decimal ndi magwiridwe antchito a masamu a decimal osakhazikika.
• Mu kukulitsa alireza Zosintha zapangidwa kuti zithandizire manambala a binary64.
• Ku mawonekedwe a mzere wolamula (CLI) anawonjezera njira zatsopano zopangira "bokosi", "json", "markdown" ndi "tebulo". Mu "column" zotulutsa, mizati imakulitsidwa yokha kutengera zomwe zili pamzere wautali kwambiri. Mu "quote" linanena bungwe mode, mtengo wa olekanitsa wokhazikitsidwa ndi ".separator" lamulo amaganiziridwa.
• Zowonjezereka ndi ieee754 zowonjezera zimamangidwa mu CLI.
• Kuwongolera kwapangidwa kwa query planner. Kuchita bwino kwa mafunso a "SANKHANI min(x) KUCHOKERA KUTI M'KATI (?,?,?)" mafunso pamene index t(x,y) ilipo. Kuzindikira kokhazikika kwa kuthekera kogwiritsa ntchito dongosolo lamafunso lathunthu pamifunso yokhala ndi mawu oti "INDEXED BY".
• mode The wal (Lembani-Kulemba Patsogolo) Ngati ntchito yolemba ikulephera, zomwe zimayambitsa kuphwanya deta mu fayilo ya shm, zochitika zotsatizanazi zingathe kubwezeretsa kukhulupirika kwa fayilo ya shm ngati pali zochitika zowerengera zogwira ntchito, m'malo moponya SQLITE_PROTOCOL cholakwika.

Source: opennet.ru