Ho lokolloa ha SQLite 3.40, DBMS e bobebe e entsoeng e le laebrari ea plug-in, e hatisitsoe. Khoutu ea SQLite e ajoa sebakeng sa sechaba, ke hore. e ka sebelisoa ntle le lithibelo le ntle ho tefo bakeng sa morero ofe kapa ofe. Tšehetso ea lichelete bakeng sa bahlahisi ba SQLite e fanoa ke consortium e entsoeng ka ho khetheha, e kenyelletsang lik'hamphani tse kang Adobe, Oracle, Mozilla, Bentley le Bloomberg.
Liphetoho tse kholo:
- E kentse tšebetsong bokhoni ba liteko ba ho bokella SQLite ho khoutu ea WebAssembly ea mahareng e ka sebetsang ho sebatli sa marang-rang mme e loketse ho hlophisa mosebetsi le database ho tsoa lits'ebetsong tsa webo ka puo ea JavaScript. Basebelisi ba sebaka sa Marang-rang ba fuoa sebopeho sa boemo bo holimo se shebaneng le ntho bakeng sa ho sebetsa ka data ka mokhoa oa sql.js kapa Node.js, e koahelang C API ea boemo bo tlase, le API e ipapisitseng le mochini oa Web Worker o o lumellang. ho theha li-asynchronous handlers tse tsamaeang ka likhoele tse arohaneng. Lintlha tseo lits'ebetso tsa marang-rang li li bolokang ho WASM version ea SQLite li ka bolokoa ka lehlakoreng la bareki ho sebelisoa OPFS (Origin-Private FileSystem) kapa fensetere.localStorage API.
- Katoloso ea ho hlaphoheloa e kentsoe, e etselitsoeng ho khutlisa data ho tsoa lifaeleng tse senyehileng ho tsoa ho database. Sehokelo sa mola oa taelo se sebelisa taelo ea ".recover" ho khutlisa.
- Ts'ebetso e ntlafalitsoeng ea moralo oa lipotso. Lithibelo li ile tsa tlosoa ha ho sebelisoa li-index tse nang le litafole tse nang le likholomo tse fetang 63 (pele, indexing e ne e sa sebelisoe bakeng sa ts'ebetso e nang le litšiea tseo palo ea tsona ea ordinal e fetang 63). Lenane le ntlafetseng la litekanyetso tse sebelisoang lipolelong. E emisitse ho kenya likhoele tse kholo le li-blobs ho tsoa ho disk ha e ntse e sebetsa NOT NULL le IS NULL operators. Ho sa kenyelelitsoe tlhahiso ea maikutlo eo ho hlahlojoang ka botlalo ho etsoang hang feela.
- Ho codebase, ho e-na le ho sebelisa mofuta oa "char *", ho sebelisoa mofuta o fapaneng oa sqlite3_filename ho emela mabitso a lifaele.
- E kentse sqlite3_value_encoding() ts'ebetso ea kahare.
- E kentse mokhoa oa SQLITE_DBCONFIG_DEFENSIVE, o thibelang ho fetola mofuta oa schema sa polokelo.
- Licheke tse ling li kentsoe ts'ebetsong ea "PRAGMA integrity_check" paramethara. Mohlala, litafole tse se nang tšobotsi ea STRICT ha lia tlameha ho ba le lipalo tsa lipalo ho TEXT likholomo le likhoele tsa boleng tse nang le linomoro ho likholomo tsa NUMERIC. Hape ho kenyelelitsoe ho hlahloba ho nepahala ha tatellano ea mela e litafoleng ka letšoao "WITHOUT ROWID".
- Polelo ea "VACUUM INTO" e hlompha litlhophiso tsa "PRAGMA synchronous".
- E kentse khetho ea SQLITE_MAX_ALLOCATION_SIZE ea ho haha ho fokotsa boholo ba li-block ha o fana ka memori.
- Algorithm ea ho hlahisa linomoro tsa pseudo-random tse hahiloeng ho SQLite e tlositsoe ho tloha ho RC4 stream cipher ho Chacha20.
- E lumelloa ho sebelisa li-index tse nang le lebitso le le leng ho li-schemas tse fapaneng tsa data.
- Lintlafatso tsa ts'ebetso li entsoe ho fokotsa mojaro ho CPU ka hoo e ka bang 1% nakong ea ts'ebetso e tloaelehileng.
Source: opennet.ru