Ntọhapụ nke SQLite 3.40, DBMS dị fechaa emebere dị ka ọba akwụkwọ nkwụnye, ka ebipụtala. A na-ekesa koodu SQLite na ngalaba ọha, ya bụ. enwere ike iji ya na-enweghị mgbochi yana n'efu maka ebumnuche ọ bụla. Nkwado ego maka ndị mmepe SQLite bụ ụlọ ọrụ emebere nke ọma, nke gụnyere ụlọ ọrụ dịka Adobe, Oracle, Mozilla, Bentley na Bloomberg.
Isi mgbanwe:
- Emejuputala ihe nnwale iji chịkọta SQLite n'ime koodu etiti WebAssembly, nwere ike ịgba ọsọ na ihe nchọgharị weebụ yana dabara maka ịhazi ọrụ na nchekwa data sitere na ngwa weebụ na Javascript. A na-enye ndị na-emepụta ihe ntanetị nwere ihe dị elu na-adabere na ihe dị elu maka ịrụ ọrụ na data n'ụdị sql.js ma ọ bụ Node.js, nke na-ejikọta C API dị ala na API dabere na usoro onye ọrụ Weebụ, nke na-enye ohere. ị ga-emepụta ndị na-ahụ maka asynchronous nke egburu n'ime eriri dị iche iche. Enwere ike ịchekwa data ngwa weebụ na ụdị WASM nke SQLite n'akụkụ ndị ahịa site na iji OPFS (Origin-Private FileSystem) ma ọ bụ windo.localStorage API.
- Agbakwụnye mgbake, emebere iji weghachi data sitere na faịlụ ndị mebiri emebi na nchekwa data. Na interface ahịrị ahịrị iwu, a na-eji iwu ".naghachi" maka mgbake.
- Ọrụ nhazi ajụjụ emelitere. Ewepụla mmachi mgbe ị na-eji ndeksi nwere tebụl nwere ihe karịrị kọlụm 63 (na mbụ, etinyeghị indexing mgbe arụrụ ọrụ nwere kọlụm nke ọnụọgụ ya karịrị 63). Ngosipụta ụkpụrụ emelitere nke ejiri na okwu. Kwụsị ibunye nnukwu eriri na blobs site na diski mgbe ị na-ahazi ndị ọrụ NOT NULL na IS NULL. Ewepụrụ ihe ngosi nke echiche nke a na-eme nyocha zuru ezu naanị otu ugboro.
- Na codebase, kama ụdị “char *”, ụdị sqlite3_filename dị iche ka a na-eji nọchite anya aha faịlụ.
- Ọrụ ime agbakwunyere sqlite3_value_encoding().
- Agbakwunyere SQLITE_DBCONFIG_DEFENSIVE mode, nke machibidoro ịgbanwe ụdị nchekwa data schema.
- Agbakwunyela nlele ndị ọzọ na mmejuputa nke paramita "PRAGMA integrity_check". Dịka ọmụmaatụ, tebụl na-enweghị njirimara STRICT agaghị enwe ụkpụrụ ọnụọgụ na kọlụm ụdị TEXT na ụkpụrụ eriri nwere ọnụọgụ dị na kọlụm ụdị NUMERIC. Agbakwunyekwara bụ nlele maka usoro ahịrị ziri ezi na tebụl nwere njirimara "Enweghị ROWID".
- Okwu "VACUUM INTO" na-eburu n'uche ntọala "PRAGMA synchronous".
- Nhọrọ mgbakọ agbakwunyere SQLITE_MAX_ALLOCATION_SIZE, nke na-enye gị ohere ịmachi nha nke ngọngọ mgbe ị na-ekenye ebe nchekwa.
- Ọgbọ algọridim ọgbọ pseudo-random nke SQLite etinyegoro n'iji cipher iyi iyi RC4 gaa na Chacha20.
- A na-ahapụ ya ka o jiri index nwere otu aha na atụmatụ data dị iche iche.
- Emeela njikarịcha arụmọrụ iji belata ibu CPU ihe dịka 1% n'oge mmemme a na-ahụkarị.
isi: opennet.ru
