{"id":105408,"date":"2022-10-29T21:36:38","date_gmt":"2022-10-29T19:36:38","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/v-sqlite-dobavlena-podderzhka-wasm-dlya-ispolzovaniya-subd-v-web-brauzere"},"modified":"2022-10-29T21:36:38","modified_gmt":"2022-10-29T19:36:38","slug":"v-sqlite-dobavlena-podderzhka-wasm-dlya-ispolzovaniya-subd-v-web-brauzere","status":"publish","type":"post","link":"https:\/\/prohoster.info\/cs\/blog\/news\/v-sqlite-dobavlena-podderzhka-wasm-dlya-ispolzovaniya-subd-v-web-brauzere","title":{"rendered":"Byla p\u0159id\u00e1na podpora WASM do SQLite pro pou\u017eit\u00ed datab\u00e1ze v webov\u00e9m prohl\u00ed\u017ee\u010di.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

V\u00fdvoj\u00e1\u0159i SQLite pracuj\u00ed na projektu, kter\u00fd umo\u017en\u00ed kompilaci knihovny do meziproduktu WebAssembly, schopn\u00e9ho b\u011b\u017eet v webov\u00e9m prohl\u00ed\u017ee\u010di a vhodn\u00e9ho pro pr\u00e1ci s datab\u00e1zemi z webov\u00fdch aplikac\u00ed v jazyce JavaScript. K\u00f3d pro podporu WebAssembly byl p\u0159id\u00e1n do hlavn\u00edho repozit\u00e1\u0159e projektu. Na rozd\u00edl od API WebSQL, kter\u00e9 vyu\u017e\u00edv\u00e1 SQLite, je WASM SQLite zcela izolov\u00e1n od prohl\u00ed\u017ee\u010de a nem\u00e1 na n\u011bj vliv (Google se rozhodl ukon\u010dit podporu WebSQL v Chrome po n\u011bkolika zranitelnostech v SQLite, kter\u00e9 bylo mo\u017en\u00e9 zneu\u017e\u00edt prost\u0159ednictv\u00edm WebSQL k \u00fatoku na prohl\u00ed\u017ee\u010d). <\/p>\n

C\u00edlem projektu je poskytnout funk\u010dn\u00ed JavaScriptov\u00e9 rozhran\u00ed, kter\u00e9 je ekvivalentn\u00ed API SQLite. Webov\u00ed v\u00fdvoj\u00e1\u0159i z\u00edskaj\u00ed vysoce \u00farov\u0148ov\u00fd objektov\u011b orientovan\u00fd interface pro pr\u00e1ci s daty ve stylu sql.js nebo Node.js, p\u016fjde o ob\u00e1lku nad n\u00edzko\u00farov\u0148ov\u00fdm C API a API zalo\u017een\u00e9 na mechanismu Web Worker, umo\u017e\u0148uj\u00edc\u00ed vytv\u00e1\u0159et asynchronn\u00ed zpracovatele prov\u00e1d\u011bn\u00e9 v samostatn\u00fdch vl\u00e1knech. Pro skryt\u00ed podrobnost\u00ed o organizaci pr\u00e1ce s vl\u00e1kny nad API zalo\u017een\u00fdm na Web Worker se tak\u00e9 vyv\u00edj\u00ed verze programov\u00e9ho rozhran\u00ed zalo\u017een\u00e9ho na mechanizmu Promise. <\/p>\n

Data, kter\u00e1 webov\u00e9 aplikace ukl\u00e1daj\u00ed do WASM verze SQLite, mohou b\u00fdt lokalizov\u00e1na v r\u00e1mci aktu\u00e1ln\u00ed relace (prohraj\u00ed se po obnoven\u00ed str\u00e1nek) nebo ukl\u00e1d\u00e1na na stran\u011b klienta (uchov\u00e1vaj\u00ed se mezi relacemi). Pro trval\u00e9 uchov\u00e1v\u00e1n\u00ed byly p\u0159ipraveny backendy pro ukl\u00e1d\u00e1n\u00ed dat do lok\u00e1ln\u00edho souborov\u00e9ho syst\u00e9mu pomoc\u00ed OPFS (Origin-Private FileSystem, roz\u0161\u00ed\u0159en\u00ed k API File System Access, dostupn\u00e9 zat\u00edm jen v prohl\u00ed\u017ee\u010d\u00edch zalo\u017een\u00fdch na WebKit a Chromium) a v m\u00edstn\u00edch ulo\u017ei\u0161t\u00edch prohl\u00ed\u017ee\u010de zalo\u017een\u00fdch na API window.localStorage a window.sessionStorage. V p\u0159\u00edpad\u011b pou\u017eit\u00ed localStorage\/sessionStorage jsou data ukl\u00e1d\u00e1na do p\u0159\u00edslu\u0161n\u00fdch ulo\u017ei\u0161\u0165 ve form\u00e1tu kl\u00ed\u010d\/hodnota, zat\u00edmco p\u0159i pou\u017eit\u00ed OPFS jsou k dispozici dv\u011b varianty: simulace virtu\u00e1ln\u00edho FS pomoc\u00ed WASMFS a samostatn\u00e1 implementace sqlite3_vfs, nab\u00edzej\u00edc\u00ed vrstvu SQLite VFS zalo\u017eenou na OPFS. <\/p>\n

Pro sestaven\u00ed SQLite do WASM je pou\u017eit kompil\u00e1tor Emscripten (sta\u010d\u00ed sestavit roz\u0161\u00ed\u0159en\u00ed ext\/wasm: '.\/configure --enable-all; make sqlite3.c; cd ext\/wasm; make'). Na v\u00fdstupu se vytv\u00e1\u0159ej\u00ed soubory sqlite3.js a sqlite3.wasm, kter\u00e9 lze zahrnout do va\u0161eho JavaScriptov\u00e9ho projektu (p\u0159\u00edklad HTML a JavaScript).
\n
Zdroj: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

\u0420\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u0438 SQLite \u0440\u0430\u0437\u0432\u0438\u0432\u0430\u044e\u0442 \u043f\u0440\u043e\u0435\u043a\u0442 \u043f\u043e \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u0438 \u043a\u043e\u043c\u043f\u0438\u043b\u044f\u0446\u0438\u0438 \u0431\u0438\u0431\u043b\u0438\u043e\u0442\u0435\u043a\u0438 \u0432 \u043f\u0440\u043e\u043c\u0435\u0436\u0443\u0442\u043e\u0447\u043d\u044b\u0439 \u043a\u043e\u0434 WebAssembly, \u0441\u043f\u043e\u0441\u043e\u0431\u043d\u044b\u0439 \u0437\u0430\u043f\u0443\u0441\u043a\u0430\u0442\u044c\u0441\u044f \u0432 web-\u0431\u0440\u0430\u0443\u0437\u0435\u0440\u0435 \u0438 \u043f\u0440\u0438\u0433\u043e\u0434\u043d\u044b\u0439 \u0434\u043b\u044f \u043e\u0440\u0433\u0430\u043d\u0438\u0437\u0430\u0446\u0438\u0438 \u0440\u0430\u0431\u043e\u0442\u044b \u0441 \u0411\u0414 \u0438\u0437 web-\u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0439 \u043d\u0430 \u044f\u0437\u044b\u043a\u0435 JavaScript. \u041a\u043e\u0434 \u0434\u043b\u044f \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0438 WebAssembly \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d \u0432 \u043e\u0441\u043d\u043e\u0432\u043d\u043e\u0439 \u0440\u0435\u043f\u043e\u0437\u0438\u0442\u043e\u0440\u0438\u0439 \u043f\u0440\u043e\u0435\u043a\u0442\u0430. \u0412 \u043e\u0442\u043b\u0438\u0447\u0438\u0435 \u043e\u0442 API WebSQL, \u0432 \u043e\u0441\u043d\u043e\u0432\u0435 \u043a\u043e\u0442\u043e\u0440\u043e\u0433\u043e \u043b\u0435\u0436\u0438\u0442 SQLite, WASM SQLite \u043f\u043e\u043b\u043d\u043e\u0441\u0442\u044c\u044e \u0438\u0437\u043e\u043b\u0438\u0440\u043e\u0432\u0430\u043d \u043e\u0442 \u0431\u0440\u0430\u0443\u0437\u0435\u0440\u0430 \u0438 […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-105408","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47Byla p\u0159id\u00e1na podpora WASM v SQLite pro pou\u017eit\u00ed DBMS v webov\u00e9m prohl\u00ed\u017ee\u010di | ProHoster","description":"V\u00fdvoj\u00e1\u0159i SQLite pracuj\u00ed na implementaci mo\u017enosti kompilace knihovny do mezik\u00f3du WebAssembly, kter\u00fd je schopen b\u011b\u017eet v webov\u00e9m prohl\u00ed\u017ee\u010di a je vhodn\u00fd pro pr\u00e1ci s datab\u00e1zemi z webov\u00fdch aplikac\u00ed.","canonical_url":"https:\/\/prohoster.info\/cs\/blog\/news\/v-sqlite-dobavlena-podderzhka-wasm-dlya-ispolzovaniya-subd-v-web-brauzere","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"cs_CZ","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0412 SQLite \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0430 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0430 WASM \u0434\u043b\u044f \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f \u0421\u0423\u0411\u0414 \u0432 web-\u0431\u0440\u0430\u0443\u0437\u0435\u0440\u0435 | ProHoster","og:description":"\u0420\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u0438 SQLite \u0440\u0430\u0437\u0432\u0438\u0432\u0430\u044e\u0442 \u043f\u0440\u043e\u0435\u043a\u0442 \u043f\u043e \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u0438 \u043a\u043e\u043c\u043f\u0438\u043b\u044f\u0446\u0438\u0438 \u0431\u0438\u0431\u043b\u0438\u043e\u0442\u0435\u043a\u0438 \u0432 \u043f\u0440\u043e\u043c\u0435\u0436\u0443\u0442\u043e\u0447\u043d\u044b\u0439 \u043a\u043e\u0434 WebAssembly, \u0441\u043f\u043e\u0441\u043e\u0431\u043d\u044b\u0439 \u0437\u0430\u043f\u0443\u0441\u043a\u0430\u0442\u044c\u0441\u044f \u0432 web-\u0431\u0440\u0430\u0443\u0437\u0435\u0440\u0435 \u0438 \u043f\u0440\u0438\u0433\u043e\u0434\u043d\u044b\u0439 \u0434\u043b\u044f \u043e\u0440\u0433\u0430\u043d\u0438\u0437\u0430\u0446\u0438\u0438 \u0440\u0430\u0431\u043e\u0442\u044b \u0441 \u0411\u0414 \u0438\u0437 web-\u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0439 \u043d\u0430.","og:url":"https:\/\/prohoster.info\/cs\/blog\/news\/v-sqlite-dobavlena-podderzhka-wasm-dlya-ispolzovaniya-subd-v-web-brauzere","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2022-10-29T19:36:38+00:00","article:modified_time":"2022-10-29T19:36:38+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":[],"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/105408","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/comments?post=105408"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/105408\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media?parent=105408"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/categories?post=105408"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/tags?post=105408"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}