Kuburitswa kweSQLite 3.40, isingaremi DBMS yakagadzirwa senge plug-in raibhurari, yakaburitswa. Iyo SQLite kodhi inogoverwa munharaunda yeruzhinji, i.e. inogona kushandiswa pasina zvirambidzo uye pasina muripo kune chero chinangwa. Rutsigiro rwemari rwevagadziri veSQLite rwunopihwa nemubatanidzwa wakanyatsogadzirwa, unosanganisira makambani akadai seAdobe, Oracle, Mozilla, Bentley neBloomberg.
Shanduko huru:
- Yakaita hunyanzvi hwekuyedza kuunganidza SQLite mune yepakati WebAssembly kodhi inogona kumhanya muwebhu browser uye inokodzera kuronga basa nedatabase kubva pawebhu application mumutauro weJavaScript. Vagadziri veWebhu vanopihwa yakakwira-level-yakatarisana nechinhu chekushanda nedata muchimiro chesql.js kana Node.js, ichiputira pamusoro yakaderera-level C API, uye API yakavakirwa paWebhu Worker mechanism inobvumidza iwe. kugadzira asynchronous handlers anomhanya pashinda dzakasiyana. Iyo data inochengetwa newebhu application muWASM vhezheni yeSQLite inogona kuchengetwa kudivi remutengi uchishandisa OPFS (Origin-Private FileSystem) kana iyo window.localStorage API.
- Iyo yekudzoreredza yekuwedzera yakawedzerwa, yakagadzirirwa kudzoreredza data kubva kune yakakuvadzwa mafaera kubva kudhatabhesi. Mutsara wekuraira unoshandisa ".recover" murairo kudzorera.
- Kuvandudza query planner performance. Zvirambidzo zvakabviswa kana uchishandisa indexes ane matafura ane anopfuura 63 columns (kare, indexing haina kushandiswa pakushanda nemakoramu ayo ordinal nhamba yaipfuura 63). Yakavandudzwa indexing yezvakakosha zvinoshandiswa mukutaura. Yakamira kurodha tambo dzakakura uye blobs kubva kudhisiki painogadzirisa NOT NULL uye IS NULL vanoshanda. Kusasanganisirwa maitiro ekuona iyo yakazara scan inoitwa kamwe chete.
- Mune iyo codebase, pane kushandisa iyo "char *" mhando, yakaparadzana sqlite3_filename mhando inoshandiswa kumiririra mazita emafaira.
- Yakawedzera sqlite3_value_encoding() basa remukati.
- Yakawedzera iyo SQLITE_DBCONFIG_DEFENSIVE modhi, iyo inorambidza kushandura schema vhezheni yekuchengetera.
- Mamwe macheki akawedzerwa pakuitwa kwe "PRAGMA integrity_check" parameter. Semuyenzaniso, matafura asina STRICT hunhu haafanire kuve nenhamba dzenhamba mu TEXT makoramu uye tambo tsika dzine manhamba muNUMERIC makoramu. Yakawedzerwawo tarisa iko kurongeka kwemitsara mumatafura ane hunhu "WITHOUT ROWID".
- Izwi rekuti "VACUUM INTO" rinoremekedza "PRAGMA synchronous" marongero.
- Yakawedzera sarudzo yekuvaka SQLITE_MAX_ALLOCATION_SIZE kudzikamisa saizi yebhuroka paunenge uchigovera ndangariro.
- Iyo algorithm yekugadzira pseudo-random nhamba dzakavakwa muSQLite yakabviswa kubva pakushandisa RC4 rwizi cipher kuenda kuChacha20.
- Inotenderwa kushandisa indexes ine zita rimwechete mune akasiyana data schemas.
- Performance optimizations yakaitwa kuti ideredze mutoro paCPU neinenge 1% panguva yakajairika chiitiko.
Source: opennet.ru