Zhvilluesit e SQLite jan\u00eb duke zhvilluar nj\u00eb projekt p\u00ebr t\u00eb realizuar mund\u00ebsin\u00eb e kompilimit t\u00eb bibliotek\u00ebs n\u00eb kodin nd\u00ebrmjet\u00ebs WebAssembly, i cili \u00ebsht\u00eb i aft\u00eb t\u00eb ekzekutohet n\u00eb shfletuesin e web-it dhe \u00ebsht\u00eb i p\u00ebrshtatsh\u00ebm p\u00ebr organizimin e pun\u00ebs me bazat e t\u00eb dh\u00ebnave nga aplikacionet web n\u00eb gjuh\u00ebn JavaScript. Kodi p\u00ebr mb\u00ebshtetje t\u00eb WebAssembly \u00ebsht\u00eb shtuar n\u00eb repository-n kryesore t\u00eb projektit. Ndryshe nga API WebSQL, i cili mb\u00ebshtetet n\u00eb SQLite, WASM SQLite \u00ebsht\u00eb plot\u00ebsisht i izoluar nga shfletuesi dhe nuk ndikon n\u00eb sigurin\u00eb e tij (Google vendosi t\u00eb ndaloj\u00eb mb\u00ebshtetje p\u00ebr WebSQL n\u00eb Chrome pas disa dob\u00ebsive n\u00eb SQLite, t\u00eb cilat mund t\u00eb shfryt\u00ebzoheshin p\u00ebrmes WebSQL p\u00ebr t\u00eb sulmuar shfletuesin). <\/p>\n
Q\u00ebllimi i projektit \u00ebsht\u00eb ofrimi i nj\u00eb lidhjeje JavaScript funksionale, e cila \u00ebsht\u00eb identike n\u00eb funksionalitet me API SQLite. Web-zhvilluesit do t\u00eb ken\u00eb n\u00eb dispozicion nj\u00eb interface t\u00eb orientuar nga objekti me nivele t\u00eb larta p\u00ebr pun\u00ebn me t\u00eb dh\u00ebnat n\u00eb stilin e sql.js ose Node.js, nj\u00eb lidhje mbi C API me nivele t\u00eb ul\u00ebta dhe API bazuar n\u00eb mekanizmin Web Worker, i cili lejon krijimin e p\u00ebrpunuesve asinkron\u00eb q\u00eb ekzekutohen n\u00eb p\u00ebrpunues t\u00eb ve\u00e7ant\u00eb. P\u00ebr t\u00eb fshehur nd\u00ebrlikimet e organizimit t\u00eb pun\u00ebs me p\u00ebrpunuesit mbi API-n\u00eb e bazuar n\u00eb Web Worker, gjithashtu po zhvillohet nj\u00eb variant i nd\u00ebrfaqes s\u00eb programimit mbi mekanizmin Promise. <\/p>\n
T\u00eb dh\u00ebnat q\u00eb aplikacionet web ruajn\u00eb n\u00eb versionin WASM t\u00eb SQLite mund t\u00eb lokalizohen brenda sesionit aktual (do t\u00eb humbasin pas rinovimit t\u00eb faqeve) ose t\u00eb ruhen n\u00eb an\u00ebn e klientit (ruhen mes sesioneve). P\u00ebr ruajtje t\u00eb p\u00ebrhershme jan\u00eb p\u00ebrgatitur backend-e p\u00ebr vendosjen e t\u00eb dh\u00ebnave n\u00eb sistemin lokal t\u00eb skedar\u00ebve me ndihm\u00ebn e OPFS (Origin-Private FileSystem, nj\u00eb shtes\u00eb p\u00ebr API-n\u00eb e Aksessit n\u00eb Sistemin e Skedar\u00ebve, e cila aktualisht \u00ebsht\u00eb e disponueshme vet\u00ebm n\u00eb shfletuesit e bazuar n\u00eb WebKit dhe Chromium) dhe n\u00eb ruajtjet lokale t\u00eb shfletuesve mbi baz\u00ebn e API-s\u00eb window.localStorage dhe window.sessionStorage. N\u00eb rastin e p\u00ebrdorimit t\u00eb localStorage\/sessionStorage, t\u00eb dh\u00ebnat pasqyrohen n\u00eb ruajtjet p\u00ebrkat\u00ebse n\u00eb formatin \u00e7el\u00ebs\/vler\u00eb, dhe kur p\u00ebrdoret OPFS, parashikohen dy variante: simulimi i nj\u00eb sistemi t\u00eb skedar\u00ebve virtual me ndihm\u00ebn e WASMFS dhe nj\u00eb realizim t\u00eb ve\u00e7ant\u00eb sqlite3_vfs, q\u00eb ofron nj\u00eb kat p\u00ebrmbi VFS SQLite mbi OPFS. <\/p>\n
P\u00ebr nd\u00ebrtimin e SQLite n\u00eb form\u00ebn WASM p\u00ebrdoret kompilatori Emscripten (mjafton t\u00eb nd\u00ebrtosh zgjerimin ext\/wasm: '.\/configure --enable-all; make sqlite3.c; cd ext\/wasm; make'). Nga kjo proces dalin skedar\u00ebt sqlite3.js dhe sqlite3.wasm, t\u00eb cil\u00ebt mund t\u00eb p\u00ebrfshihen n\u00eb projektin tuaj JavaScript (shembuj HTML dhe JavaScript). \n Burimi: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"