Ukukhishwa kwe-SQLite 3.37, i-DBMS engasindi eklanywe njengomtapo wolwazi we-plug-in, kushicilelwe. Ikhodi ye-SQLite isatshalaliswa esizindeni 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.
Izinguquko eziyinhloko:
- Usekelo olungeziwe lokudala amathebula ngesibaluli esithi “STRICT”, esidinga inkomba yohlobo oluyisibopho lapho kumenyezelwa amakholomu futhi kusetshenziswa ukuhlola okuqinile kohlobo oluqinile lwedatha engezwe kumakholomu. Uma leli fulegi lisethiwe, i-SQLite izobonisa iphutha uma kungenakwenzeka ukusakaza idatha eshiwo ohlotsheni lwekholomu. Isibonelo, uma ikholomu idalwe ngokuthi "INTEGER", ukudlulisa inani leyunithi yezinhlamvu '123' kuzoholela ekutheni inombolo engu-123 yengezwe, kodwa ukuzama ukucacisa okuthi 'xyz' kuzohluleka.
- Emsebenzini othi “ALTER TABLE ENGEZA IKHOLOMU”, isheke lemibandela yokuba khona kwemigqa lingeziwe lapho kwengezwa amakholomu anokuhlola okusekelwe kunkulumo ethi “HLOLA” noma ngemibandela ethi “HHAYI ZINTI”.
- Kusetshenziswe inkulumo ethi “PRAGMA table_list” ukuze kuboniswe ulwazi mayelana namathebula nokubukwa.
- Isixhumi esibonakalayo somugqa womyalo sisebenzisa umyalo othi “.connection”, okuvumela ukuthi usekele ngesikhathi esisodwa ukuxhumana okuningi kusizindalwazi.
- Kwengezwe ipharamitha ethi “—safe”, ekhubaza imiyalo ye-CLI nezinkulumo ze-SQL ezikuvumela ukuthi wenze imisebenzi ngamafayela esizindalwazi ahlukile kusizindalwazi esishiwo emugqeni womyalo.
- I-CLI ithuthukise ukusebenza kokufunda izisho ze-SQL ezihlukaniswa zibe imigqa eminingi.
- Imisebenzi eyengeziwe sqlite3_autovacuum_pages(), sqlite3_changes64() kanye ne-sqlite3_total_changes64().
- Umhleli wemibuzo uqinisekisa ukuthi i-ORDER BY clauses emibuzweni emincane kanye nokubukwa kuzitshwa ngaphandle kwalapho ukususa lezo zigaba zomshwana akuguquli i-semantics yombuzo.
- Isandiso generate_series(START,END,STEP) sishintshiwe, ipharamitha yokuqala lapho (“START”) yenziwe yaba isibopho. Ukuze ubuyisele ukuziphatha okudala, ungakwazi ukwakha kabusha ngenketho ethi "-DZERO_ARGUMENT_GENERATE_SERIES".
- Ukusetshenziswa kwememori okwehlisiwe ekugcineni i-schema sedathabhesi.
Source: opennet.ru