{"id":108405,"date":"2023-05-06T12:48:27","date_gmt":"2023-05-06T10:48:27","guid":{"rendered":"https:\/\/prohoster.info\/?p=108405"},"modified":"2023-05-09T11:00:33","modified_gmt":"2023-05-09T09:00:33","slug":"vypusk-subd-alasql-4-0-naczelennoj-na-ispolzovanie-v-brauzerah-i-node-js","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/vypusk-subd-alasql-4-0-naczelennoj-na-ispolzovanie-v-brauzerah-i-node-js","title":{"rendered":"\u0412\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 AlaSQL 4.0, \u043d\u0430\u0446\u0435\u043b\u0435\u043d\u043d\u043e\u0439 \u043d\u0430 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 \u0432 \u0431\u0440\u0430\u0443\u0437\u0435\u0440\u0430\u0445 \u0438 Node.js","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

L\u00ebshimi i versionit 4.0 t\u00eb SGBD AlaSQL \u00ebsht\u00eb tani i disponuesh\u00ebm, i destinuar p\u00ebr p\u00ebrdorim n\u00eb aplikacione web n\u00eb shfletues, n\u00eb aplikacione mobile t\u00eb bazuara n\u00eb teknologjit\u00eb web, ose n\u00eb trajtues serveri t\u00eb bazuar n\u00eb platform\u00ebn Node.js. SGBD \u00ebsht\u00eb e dizajnuar si nj\u00eb bibliotek\u00eb JavaScript dhe lejon p\u00ebrdorimin e gjuh\u00ebs SQL. Mb\u00ebshtetet ruajtja e t\u00eb dh\u00ebnave n\u00eb tabela relacional\u00eb tradicionale ose n\u00eb form\u00ebn e strukturave t\u00eb brendshme JSON, pa k\u00ebrkuar nj\u00eb p\u00ebrcaktim t\u00eb ngurt\u00eb t\u00eb skem\u00ebs s\u00eb ruajtjes. P\u00ebr manipulimin e t\u00eb dh\u00ebnave nga linja e komand\u00ebs, ofrohet utilitari alasql. Kodi i projektit \u00ebsht\u00eb shkruar n\u00eb JavaScript dhe shp\u00ebrndahet n\u00ebn licenc\u00ebn MIT. <\/p>\n

AlaSQL mb\u00ebshtet shumic\u00ebn e gjuh\u00ebs SQL-99, si dhe ofron shtesa p\u00ebr trajtimin n\u00eb stil NoSQL (pa p\u00ebrcaktim t\u00eb skem\u00ebs s\u00eb ruajtjes) dhe manipulimin me grafet. N\u00eb k\u00ebrkesat SQL, mund t\u00eb kryhen operacione bashkimi (JOIN), grupimi (GROUP), bashkimi (UNION), t\u00eb p\u00ebrdoren n\u00ebnk\u00ebrkesat dhe shprehjet e tipit ANY, ALL dhe IN, dhe t\u00eb aplikohen funksionet ROLLUP(), CUBE() dhe GROUPING SETS(). Ka mb\u00ebshtetje t\u00eb kufizuar p\u00ebr transaksionet. Mb\u00ebshtetet p\u00ebrcaktimi i funksioneve t\u00eb personalizuara, t\u00eb cilat mund t\u00eb p\u00ebrdoren n\u00eb k\u00ebrkesat SQL. P\u00ebr thirrjen e shpejt\u00eb t\u00eb funksioneve, shprehjet SQL mund t\u00eb kompilohen (ngjash\u00ebm me operatorin SQL PREPARE). <\/p>\n

SGBD AlaSQL \u00ebsht\u00eb projektuar p\u00ebr t\u00eb p\u00ebrdorur paradigm\u00ebn ETL (Nxjerr, Transformo, Ngarko) dhe manipulimin e t\u00eb dh\u00ebnave n\u00eb form\u00ebn e importit\/p\u00ebrpunimit\/eksportit. P\u00ebr ruajtjen, eksportimin dhe importimin, mund t\u00eb p\u00ebrdoren formate localStorage, IndexedDB, CSV, TAB, TXT, JSON, SQLite dhe Excel (.xls dhe .xlsx), duke n\u00ebnkuptuar se \u00ebsht\u00eb e mundur t\u00eb kryhen p\u00ebrmbledhje t\u00eb drejtp\u00ebrdrejta nga t\u00eb dh\u00ebnat e ruajtura n\u00eb k\u00ebto formate t\u00eb sh\u00ebnuara, ose t\u00eb importohen dhe eksportohen t\u00eb dh\u00ebna. Gjithashtu, \u00ebsht\u00eb e mundur t\u00eb kryhet operacioni SELECT mbi \u00e7do t\u00eb dh\u00ebn\u00eb n\u00eb objektet JavaScript. <\/p>\n

Biblioteka fillimisht \u00ebsht\u00eb projektuar p\u00ebr p\u00ebrpunimin e shpejt\u00eb t\u00eb t\u00eb dh\u00ebnave n\u00eb kujtes\u00ebn operacionale p\u00ebr aplikacionet e analiz\u00ebs s\u00eb biznesit dhe mb\u00ebshtet optimizime si ruajtja n\u00eb memorie e k\u00ebrkesave n\u00eb form\u00ebn e funksioneve t\u00eb komiluara, indeksimi i parashikuesh\u00ebm t\u00eb bashkimeve t\u00eb tabelave dhe filtrimi i shprehjeve WHERE para operacioneve t\u00eb bashkimit. Krahasuar me projekte t\u00eb tjera t\u00eb ngjashme, AlaSQL ka qen\u00eb tre her\u00eb m\u00eb e shpejt\u00eb se SQL.js n\u00eb zgjedhjet me operacione SUM, JOIN dhe GROUP BY, dy her\u00eb m\u00eb e shpejt\u00eb se Linq n\u00eb p\u00ebrdorimin e GROUP BY dhe af\u00ebrsisht n\u00eb t\u00eb nj\u00ebjtin nivel si API WebSQL (nj\u00eb shtres\u00eb mbi SQLite, q\u00eb do t\u00eb hiqet s\u00eb shpejti nga Chrome) gjat\u00eb zgjedhjes me operacione SUM, JOIN dhe GROUP BY.
\n
Burimi: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

\u0414\u043e\u0441\u0442\u0443\u043f\u0435\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 AlaSQL 4.0, \u043f\u0440\u0435\u0434\u043d\u0430\u0437\u043d\u0430\u0447\u0435\u043d\u043d\u043e\u0439 \u0434\u043b\u044f \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f \u0432 web-\u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f\u0445 \u0432 \u0431\u0440\u0430\u0443\u0437\u0435\u0440\u0435, \u0432 \u043c\u043e\u0431\u0438\u043b\u044c\u043d\u044b\u0445 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f\u0445 \u043d\u0430 \u0431\u0430\u0437\u0435 web-\u0442\u0435\u0445\u043d\u043e\u043b\u043e\u0433\u0438\u0439 \u0438\u043b\u0438 \u0432 \u0441\u0435\u0440\u0432\u0435\u0440\u043d\u044b\u0445 \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u0430\u0445 \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u044b Node.js. \u0421\u0423\u0411\u0414 \u043e\u0444\u043e\u0440\u043c\u043b\u0435\u043d\u0430 \u0432 \u0432\u0438\u0434\u0435 JavaScript-\u0431\u0438\u0431\u043b\u0438\u043e\u0442\u0435\u043a\u0438 \u0438 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u044f\u0437\u044b\u043a SQL. \u041f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u0442\u0441\u044f \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u0442\u0440\u0430\u0434\u0438\u0446\u0438\u043e\u043d\u043d\u044b\u0445 \u0440\u0435\u043b\u044f\u0446\u0438\u043e\u043d\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u0445 \u0438\u043b\u0438 \u0432 \u0444\u043e\u0440\u043c\u0435 \u0432\u043b\u043e\u0436\u0435\u043d\u043d\u044b\u0445 JSON-\u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440, \u043d\u0435 \u0442\u0440\u0435\u0431\u0443\u044e\u0449\u0438\u0445 \u0436\u0451\u0441\u0442\u043a\u043e\u0433\u043e \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u0438\u044f \u0441\u0445\u0435\u043c\u044b \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f. \u0414\u043b\u044f […]<\/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-108405","post","type-post","status-publish","format-standard","hentry","category-novosti-interneta"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\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\n","aioseo_head_json":{"title":"\ud83e\udd47L\u00ebshimi i SGBD AlaSQL 4.0, i orientuar drejt p\u00ebrdorimit n\u00eb shfletues dhe Node.js | ProHoster","description":"L\u00ebshimi i versionit 4.0 t\u00eb SGBD AlaSQL \u00ebsht\u00eb tani i disponuesh\u00ebm, i destinuar p\u00ebr p\u00ebrdorim n\u00eb aplikacione web n\u00eb shfletues, n\u00eb aplikacione mobile t\u00eb bazuara n\u00eb teknologjit\u00eb web, ose n\u00eb trajtues serveri t\u00eb bazuar n\u00eb platform\u00ebn Node.js. SGBD \u00ebsht\u00eb e dizajnuar si nj\u00eb bibliotek\u00eb JavaScript dhe lejon p\u00ebrdorimin e gjuh\u00ebs SQL. Mb\u00ebshtetet ruajtja e t\u00eb dh\u00ebnave n\u00eb tabela relacional\u00eb tradicionale ose n\u00eb form\u00ebn e strukturave t\u00eb brendshme JSON, pa k\u00ebrkuar nj\u00eb p\u00ebrcaktim t\u00eb ngurt\u00eb t\u00eb skem\u00ebs s\u00eb ruajtjes.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/vypusk-subd-alasql-4-0-naczelennoj-na-ispolzovanie-v-brauzerah-i-node-js","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sq_AL","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\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 AlaSQL 4.0, \u043d\u0430\u0446\u0435\u043b\u0435\u043d\u043d\u043e\u0439 \u043d\u0430 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 \u0432 \u0431\u0440\u0430\u0443\u0437\u0435\u0440\u0430\u0445 \u0438 Node.js | ProHoster","og:description":"\u0414\u043e\u0441\u0442\u0443\u043f\u0435\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 AlaSQL 4.0, \u043f\u0440\u0435\u0434\u043d\u0430\u0437\u043d\u0430\u0447\u0435\u043d\u043d\u043e\u0439 \u0434\u043b\u044f \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f \u0432 web-\u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f\u0445 \u0432 \u0431\u0440\u0430\u0443\u0437\u0435\u0440\u0435, \u0432 \u043c\u043e\u0431\u0438\u043b\u044c\u043d\u044b\u0445 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f\u0445 \u043d\u0430 \u0431\u0430\u0437\u0435 web-\u0442\u0435\u0445\u043d\u043e\u043b\u043e\u0433\u0438\u0439 \u0438\u043b\u0438 \u0432 \u0441\u0435\u0440\u0432\u0435\u0440\u043d\u044b\u0445 \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u0430\u0445 \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u044b Node.js. \u0421\u0423\u0411\u0414 \u043e\u0444\u043e\u0440\u043c\u043b\u0435\u043d\u0430 \u0432 \u0432\u0438\u0434\u0435 JavaScript-\u0431\u0438\u0431\u043b\u0438\u043e\u0442\u0435\u043a\u0438 \u0438 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u044f\u0437\u044b\u043a SQL. \u041f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u0442\u0441\u044f \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u0442\u0440\u0430\u0434\u0438\u0446\u0438\u043e\u043d\u043d\u044b\u0445 \u0440\u0435\u043b\u044f\u0446\u0438\u043e\u043d\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u0445 \u0438\u043b\u0438 \u0432 \u0444\u043e\u0440\u043c\u0435 \u0432\u043b\u043e\u0436\u0435\u043d\u043d\u044b\u0445 JSON-\u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440, \u043d\u0435 \u0442\u0440\u0435\u0431\u0443\u044e\u0449\u0438\u0445 \u0436\u0451\u0441\u0442\u043a\u043e\u0433\u043e \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u0438\u044f \u0441\u0445\u0435\u043c\u044b \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f. \u0414\u043b\u044f","og:url":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/vypusk-subd-alasql-4-0-naczelennoj-na-ispolzovanie-v-brauzerah-i-node-js","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":"2023-05-06T10:48:27+00:00","article:modified_time":"2023-05-09T09:00:33+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\/sq\/wp-json\/wp\/v2\/posts\/108405","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=108405"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/108405\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=108405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=108405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=108405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}