Qhov kev tso tawm ntawm SQLite 3.40, lub teeb DBMS tsim los ua lub tsev qiv ntawv plug-in, tau luam tawm. SQLite code yog muab faib rau hauv pej xeem sau, i.e. tuaj yeem siv yam tsis muaj kev txwv thiab pub dawb rau txhua lub hom phiaj. Kev them nyiaj yug rau SQLite developers yog muab los ntawm ib tug tshwj xeeb tsim consortium, uas muaj xws li cov tuam txhab xws li Adobe, Oracle, Mozilla, Bentley thiab Bloomberg.
Cov kev hloov loj:
- Ib qho kev sim ua haujlwm tau siv los sau SQLite rau hauv WebAssembly intermediate code, muaj peev xwm khiav hauv lub web browser thiab tsim nyog rau kev teeb tsa ua haujlwm nrog cov ntaub ntawv los ntawm cov ntawv thov web hauv JavaScript. Cov neeg tsim tawm lub vev xaib tau muab nrog cov khoom lag luam siab-taw qhia kev sib txuas rau kev ua haujlwm nrog cov ntaub ntawv hauv cov qauv ntawm sql.js lossis Node.js, kev khi rau qib qis C API thiab API raws li Web Worker mechanism, uas tso cai rau koj los tsim asynchronous handlers tua nyob rau hauv nyias threads. Cov ntaub ntawv uas cov ntawv thov web khaws cia hauv WASM version ntawm SQLite tuaj yeem khaws cia rau ntawm tus neeg siv khoom siv OPFS ( Keeb Kwm-Private FileSystem) lossis windows.localStorage API.
- Ntxiv rov qab extension, tsim los rov qab tau cov ntaub ntawv los ntawm puas cov ntaub ntawv los ntawm lub database. Hauv kab hais kom ua interface, cov lus txib ".recover" yog siv rau rov qab.
- Txhim kho cov lus nug npaj kev ua haujlwm. Cov kev txwv tau raug tshem tawm thaum siv cov indexes nrog cov ntxhuav nrog ntau dua 63 kab (yav dhau los, kev ntsuas tsis tau siv thaum ua haujlwm nrog cov kab uas nws tus lej ntau dua 63). Txhim kho indexing ntawm qhov tseem ceeb siv nyob rau hauv kab lus. Nres thauj cov hlua loj thiab blobs los ntawm disk thaum ua cov TSIS NULL thiab YOG NULL tus tswv. Lub materialization ntawm views uas ib tug tag nrho scan yog ua ib zaug xwb tsis suav.
- Hauv codebase, tsis yog hom "char *", cais hom sqlite3_filename yog siv los sawv cev cov npe cov ntaub ntawv.
- Ntxiv kev ua haujlwm sab hauv sqlite3_value_encoding().
- Ntxiv SQLITE_DBCONFIG_DEFENSIVE hom, uas txwv tsis pub hloov cov ntaub ntawv khaws cia schema version.
- Cov kev kuaj xyuas ntxiv tau muab ntxiv rau qhov kev siv ntawm "PRAGMA integrity_check" parameter. Piv txwv li, cov ntxhuav uas tsis muaj tus cwj pwm STRICT yuav tsum tsis muaj cov lej muaj nuj nqis hauv txhua kab ntawm hom TEXT thiab txoj hlua tus nqi nrog cov lej hauv kab ntawm hom NUMERIC. Tsis tas li ntawd ntxiv yog ib daim tshev rau qhov kev txiav txim kom raug ntawm kab hauv cov ntxhuav nrog "tsis muaj ROWID" tus cwj pwm.
- Qhov "VACUUM INTO" qhia coj mus rau hauv tus account "PRAGMA synchronous" chaw.
- Ntxiv kev xaiv sib dhos SQLITE_MAX_ALLOCATION_SIZE, uas tso cai rau koj txwv qhov loj ntawm cov blocks thaum faib cov cim xeeb.
- SQLite's built-in pseudo-random naj npawb tsim algorithm tau tsiv los ntawm kev siv RC4 kwj cipher rau Chacha20.
- Nws raug tso cai siv indexes nrog tib lub npe hauv cov ntaub ntawv sib txawv.
- Kev ua tau zoo ntawm kev ua tau zoo tau ua kom txo qis CPU load kwv yees li 1% thaum lub sijhawm ua haujlwm.
Tau qhov twg los: opennet.ru