Ukukhishwa kwe-SQLite 3.45, i-DBMS engasindi eklanywe njengomtapo wolwazi we-plug-in, kushicilelwe. 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-Bentley, i-Bloomberg, i-Expensify kanye ne-Navigation Data Standard.
Izinguquko eziyinhloko:
- Yonke imisebenzi ye-SQL yokusebenza ngefomethi ye-JSON ibhalwe kabusha futhi yadluliselwa kufomethi entsha yangaphakathi ye-JSONB yokuhlukanisa isihlahla, ehlelwa ngohlelo futhi engagcinwa kusizindalwazi ukuze kugwenywe ukuncozululwa okuphindaphindiwe lapho kusetshenziswa amanani e-JSON. Izinguqulo ezintsha zemisebenzi ekhiqizayo ye-JSON manje sezikhiqiza ifomethi kanambambili ye-JSONB esikhundleni sefomethi yombhalo. I-agumenti yesibili yokuzikhethela yengezwe kumsebenzi othi json_valid(), lapho ungacacisa imaski encane enquma izici ze-JSON evumelekile (isibonelo, uma ucacisa 0x04, i-JSONB blob izobonwa njengevumelekile, uma ucacise 0x01, bhala okuthi JSON ngefomethi ye-RFC-8259, futhi uma ucacisa u-0x05, zombili izinketho ).
- Inketho ye-tokendata yengezwe kuthebula elibonakalayo le-FTS5 elisetshenziselwa ukusesha umbhalo ogcwele, okuvumela ukusetshenziswa kwamathokheni ngokwezifiso.
- Ngokuzenzakalelayo, ukulungiselelwa kwe-SQLITE_DIRECT_OVERFLOW_READ kunikwe amandla, lapho amakhasi achichimayo amakhulu kunosayizi wekhasi lesihlahla se-b ojwayelekile afundwa efayeleni ngokuqondile, kudlule inqolobane. Ukuze uyikhubaze ngesikhathi sokwakha, ungasebenzisa inketho ethi "-DSQLITE_DIRECT_OVERFLOW_READ=0".
- Umhleli wemibuzo uthuthukise ukusebenza kahle kokuthuthukisa izithiyo ezishintshayo futhi wathuthukisa amandla okuziba izinkomba ezitholakala zinekhwalithi ephansi uma kwenziwa umsebenzi HLAZIYA.
- Isixhumi esibonakalayo somugqa womyalo sithuthukise ukuboniswa kokuqukethwe okufakwe ikhodi kwe-UTF-8 epulatifomu. WindowsUkutholwa okuzenzakalelayo kokusetshenziswa kwe-CLI lapho kudlala izikripthi ze-.dump kanye nezinguquko ezifanele kuzilungiselelo, njenge-.dbconfig defensive off kanye ne-.dbconfig dqs_dll on, sekuqalisiwe.
- Isici se-SQLITE_RESULT_SUBTYPE sengezwe emisebenzini ye-SQL echazwe ohlangothini lohlelo lokusebenza, evumela ukushaya i-sqlite3_result_subtype() kusuka kumsebenzi ukuze kuhlolwe izinhlobonhlobo ze-agumenti.
Ukwengeza, singaphawula ukuthuthuka kokwakhiwa kokuhlolwa kwe-SQLite yemodi entsha yokugawulwa kwemisebenzi - WAL2 (“PRAGMA journal_mode = wal2”), esebenzisa amafayela amabili we-wal (“database-wal” kanye “database-wal2”) esikhundleni selilodwa. . Lapho ubhala idatha kusizindalwazi, idatha entsha yengezwa kufayela lokuqala le-wal. Uma ifayela le-wal lokuqala lifinyelela usayizi omkhulu ngokwanele, lishintshela ekubhaleni ifayela lesibili. Ngemva kokushintshela kufayela lesibili le-wal, elokuqala liyatholakala ukuze kwenziwe izinguquko (iphoyinti lokuhlola) nokubhala ngaphezulu. Ngakho-ke, lapho ifayela le-wal lesibili lifinyelela usayizi omkhulu, lishintshela kweyokuqala, njll., okuxazulula inkinga yokukhula okungalawulwa kwefayela le-wal ezimweni lapho ukuthengiselana kungenziwanga isikhathi eside noma izinqubo zokufunda isikhathi eside. kwenziwe.
Source: opennet.ru
