Horumarinta SQLite waxay horumarinayaan mashruuc si ay u hirgeliyaan awoodda lagu ururiyo maktabadda koodka WebAssembly dhexdhexaad ah kaas oo ku shaqeyn kara browserka webka oo ku habboon in la abaabulo shaqada xogta laga helo codsiyada webka ee luqadda JavaScript. Koodhka taageerada WebAssembly ayaa lagu daray kaydka mashruuca ugu weyn. Si ka duwan sida WebSQL API, kaas oo ku salaysan SQLite, WASM SQLite gabi ahaanba waa ka go'doonsan yahay browserka mana saameynayso ammaankeeda (Google wuxuu go'aansaday inuu hoos u dhigo taageerada WebSQL ee Chrome ka dib dhowr nuglaanta SQLite oo laga faa'iideysan karo WebSQL si loo weeraro browserka. ) .
Hadafka mashruucu waa in la bixiyo ku xidhid JavaScript shaqaynaysa oo la mid ah shaqada SQLite API. Soosaarayaasha shabakadaha waxaa la siiyaa interface heer sare ah oo ku jihaysan shayga si ay ugula shaqeeyaan xogta qaabka sql.js ama Node.js, ku duubida heerka hoose ee C API, iyo API ku salaysan habka Shaqeeyaha Shabakadda ee kuu ogolaanaya si loo abuuro gacan-ku-hayayaal asynchronous ah oo ku shaqeeya dunta kala duwan. Si loo qariyo qallafsanaanta habaynta shaqada ee dunta sare ee API Worker-based, kala duwanaanshiyaha barnaamijka ee ku salaysan habka Ballanqaadka ayaa sidoo kale la soo saarayaa.
Xogta ay arjiyada shabakadu ku kaydiyaan nooca WASM ee SQLite waxa lagu meelayn karaa kalfadhiga hadda socda (lumay ka dib dib-u-celinta bogga) ama dhinaca macmiilku wuu sii jiraa (ku sii socdaa inta u dhaxaysa fadhiyada). Kaydinta joogtada ah, dhabarka dambe ayaa loo diyaariyey in lagu meeleeyo xogta nidaamka faylalka maxalliga ah iyadoo la adeegsanayo OPFS (Asal-Private FileSystem, kordhinta Nidaamka Faylka API, oo ilaa hadda laga heli karo daalacashada ku salaysan WebKit iyo Chromium) iyo kaydinta browserka maxalliga ah ku salaysan daaqada.localStorage API iyo window.sessionStorage. Marka la isticmaalayo localStorage/sessionStorage, xogta waxaa lagu jaangooyay bakhaarada muhiimka ah/qiimaha ku habboon, halka marka la isticmaalayo OPFS, waxaa jira laba ikhtiyaar: jilitaanka nidaamka faylalka farsamada iyadoo la adeegsanayo WASMFS, iyo hirgelinta sqlite3_vfs gaar ah oo bixisa lakabka OPFS ee SQLite VFS .
Si loo dhiso SQLite ee matalaadda WASM, Emscripten compiler ayaa la isticmaalaa (waa ku filan tahay in la dhiso ext/wasm kordhinta: "./configure --enable-all; make sqlite3.c; cd ext/wasm; make"). Soosaarku waa faylalka sqlite3.js iyo sqlite3.wasm kuwaas oo aad ku dari karto mashruucaaga JavaScript (tusaale HTML iyo JavaScript).
Source: opennet.ru