Kutulutsidwa kwa SQLite 3.40, DBMS yopepuka yopangidwa ngati laibulale ya pulagi, kwasindikizidwa. Khodi ya SQLite imagawidwa pagulu la anthu, 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.
Zosintha zazikulu:
- Inakhazikitsa luso loyesa kupanga SQLite kukhala code yapakatikati ya WebAssembly yomwe imatha kugwira ntchito pasakatuli ndipo ndiyoyenera kukonza ntchito ndi nkhokwe kuchokera pamawebusayiti muchilankhulo cha JavaScript. Opanga mawebusayiti amapatsidwa mawonekedwe apamwamba kwambiri okhudzana ndi chinthu kuti athe kugwira ntchito ndi data mumayendedwe a sql.js kapena Node.js, kukulunga pa C API yotsika kwambiri, ndi API yotengera makina a Web Worker omwe amakulolani. kupanga ma asynchronous handlers omwe amayenda pa ulusi wosiyana. Deta yomwe mapulogalamu a pa intaneti amasunga mu mtundu wa WASM wa SQLite akhoza kusungidwa kumbali ya kasitomala pogwiritsa ntchito OPFS (Origin-Private FileSystem) kapena window.localStorage API.
- Chiwongoladzanja chobwezeretsa chawonjezeredwa, chopangidwa kuti chibwezeretse deta kuchokera ku mafayilo owonongeka kuchokera ku database. Lamulo la mzere wa lamulo limagwiritsa ntchito lamulo la ".recover" kuti libwezeretse.
- Kuchita bwino kwa query planner. Zoletsa zidachotsedwa pogwiritsira ntchito ma index omwe ali ndi matebulo okhala ndi mizati yopitilira 63 (m'mbuyomu, kulondolera sikunagwiritsidwe ntchito ndi mizati yomwe nambala ya ordinal idapitilira 63). Kuwongolera bwino kwazomwe zimagwiritsidwa ntchito m'mawu. Anasiya kukweza zingwe zazikulu ndi ma blobs kuchokera ku disk pamene akukonza NOT NULL ndi IS NULL opareta. Kusaphatikizidwa kwa mawonedwe komwe kusanthula kwathunthu kumachitika kamodzi kokha.
- Mu codebase, m'malo mogwiritsa ntchito mtundu wa "char *", mtundu wosiyana wa sqlite3_filename umagwiritsidwa ntchito kuyimira mayina a fayilo.
- Anawonjezera sqlite3_value_encoding() ntchito yamkati.
- Onjezani SQLITE_DBCONFIG_DEFENSIVE mode, yomwe imaletsa kusintha mtundu wa schema yosungira.
- Macheke owonjezera awonjezedwa pakukhazikitsa "PRAGMA integrity_check" parameter. Mwachitsanzo, matebulo opanda mawonekedwe a STRICT sayenera kukhala ndi manambala mumigawo ya TEXT ndi zingwe zokhala ndi manambala mumigawo NUMERIC. Zowonjezedwanso fufuzani kulondola kwa dongosolo la mizere m'matebulo ndi chizindikiro "POpanda ROWID".
- Mawu akuti "VACUUM INTO" amalemekeza zokonda za "PRAGMA synchronous".
- Onjezani njira yomanga ya SQLITE_MAX_ALLOCATION_SIZE kuti muchepetse kukula kwa midadada pogawa zokumbukira.
- Njira yopangira manambala achinyengo opangidwa mu SQLite yachotsedwa pakugwiritsa ntchito RC4 stream cipher kupita ku Chacha20.
- Zimaloledwa kugwiritsa ntchito ma index omwe ali ndi dzina lomwelo pamadongosolo osiyanasiyana a data.
- Kukhathamiritsa kwa magwiridwe antchito apangidwa kuti achepetse katundu pa CPU ndi pafupifupi 1% pazochitika wamba.
Source: opennet.ru