{"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\/news\/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":"

Disponohet versioni i DBMS AlaSQL 4.0, i destinuar p\u00ebr p\u00ebrdorim n\u00eb aplikacionet web n\u00eb shfletues, n\u00eb aplikacionet mobile bazuar n\u00eb teknologji web ose n\u00eb p\u00ebrpunuesit server mbi platform\u00ebn Node.js. DBMS \u00ebsht\u00eb e prezantuar n\u00eb form\u00ebn e nj\u00eb biblioteke JavaScript dhe lejon p\u00ebrdorimin e gjuh\u00ebs SQL. Mb\u00ebshtetet ruajtja e t\u00eb dh\u00ebnave n\u00eb tabela relacional tradicionale ose n\u00eb form\u00ebn e strukturave JSON t\u00eb thella, t\u00eb cilat nuk k\u00ebrkojn\u00eb nj\u00eb p\u00ebrcaktim t\u00eb rrept\u00eb t\u00eb skem\u00ebs s\u00eb ruajtjes. P\u00ebr manipulimin e t\u00eb dh\u00ebnave nga linja e komandave ofrohet utiliteti alasql. Kodi i projektit \u00ebsht\u00eb shkruar n\u00eb JavaScript dhe shp\u00ebrndahet n\u00ebn licenc\u00ebn MIT. <\/p>\n

N\u00eb AlaSQL mb\u00ebshtetet shumica e gjuh\u00ebs SQL-99, si dhe ofrohen shtesa p\u00ebr p\u00ebrpunim n\u00eb stilin NoSQL (pa p\u00ebrcaktimin e skem\u00ebs s\u00eb ruajtjes) dhe manipulimin e graf\u00ebve. N\u00eb k\u00ebrkesat SQL mund t\u00eb kryhen operacione bashkimi (JOIN), grupimi (GROUP), bashk\u00ebngjitjeje (UNION), t\u00eb p\u00ebrdoren n\u00ebnk\u00ebrkesa dhe shprehje t\u00eb tipit ANY, ALL dhe IN, t\u00eb aplikohen funksionet ROLLUP(), CUBE() dhe GROUPING SETS(). Ka mb\u00ebshtetje t\u00eb kufizuar p\u00ebr transaksionet. Mb\u00ebshtetet definimi i funksioneve t\u00eb p\u00ebrdoruesve, t\u00eb cilat mund t\u00eb p\u00ebrdoren n\u00eb k\u00ebrkesat SQL. P\u00ebr thirrje t\u00eb shpejta funksioni dhe shprehjet SQL mund t\u00eb kompilohen (analogu i operatorit SQL PREPARE). <\/p>\n

DBMS AlaSQL \u00ebsht\u00eb e projektuar p\u00ebr t\u00eb p\u00ebrdorur paradigmat ETL (Extract, Transform, Load) dhe manipulimin e t\u00eb dh\u00ebnave n\u00eb form\u00ebn e importit \/ p\u00ebrpunimit \/ eksportit. Formate q\u00eb mund t\u00eb p\u00ebrdoren p\u00ebr ruajtje, eksport dhe import jan\u00eb localStorage, IndexedDB, CSV, TAB, TXT, JSON, SQLite dhe Excel (.xls dhe .xlsx), duke supozuar se \u00ebsht\u00eb e mundur t\u00eb ekzekutohen direkt k\u00ebrkesat nga t\u00eb dh\u00ebnat e ruajtura n\u00eb formatet e sh\u00ebnuara, ose t\u00eb importohen dhe eksportohen t\u00eb dh\u00ebnat. Gjithashtu \u00ebsht\u00eb e mundur t\u00eb ekzekutohet operacioni SELECT mbi \u00e7do t\u00eb dh\u00ebna n\u00eb objektet JavaScript. <\/p>\n

Biblioteka \u00ebsht\u00eb fillimisht e dizajnuar p\u00ebr p\u00ebrpunimin e shpejt\u00eb t\u00eb t\u00eb dh\u00ebnave n\u00eb memorie p\u00ebr aplikacionet e analiz\u00ebs s\u00eb biznesit dhe mb\u00ebshtet optimizime t\u00eb tilla si keqkodingu i k\u00ebrkesave n\u00eb form\u00ebn e funksioneve t\u00eb kompiluar, indekse t\u00eb parashikuara p\u00ebr bashkimin e tabelave dhe filtrimin e shprehjeve WHERE para operacioneve t\u00eb bashkimit. Krahasuar me projekte t\u00eb tjera t\u00eb ngjashme, AlaSQL ka rezultuar deri n\u00eb tri her\u00eb m\u00eb e shpejt\u00eb se SQL.js p\u00ebr zgjedhje 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 p\u00ebr rreth n\u00eb t\u00eb nj\u00ebjtin nivel me API-n\u00eb WebSQL (nj\u00eb mb\u00ebshtetje mbi SQLite, e cila do t\u00eb hiqet s\u00eb shpejti nga Chrome) n\u00eb zgjedhje 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-news"],"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\udd47Versioni 4.0 i SGBD AlaSQL, i destinuar p\u00ebr p\u00ebrdorim n\u00eb shfletues dhe Node.js | ProHoster","description":"\u00cbsht\u00eb n\u00eb dispozicion versioni 4.0 i SGBD AlaSQL, 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 processet serverike t\u00eb bazuara n\u00eb platform\u00ebn Node.js.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/news\/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.","og:url":"https:\/\/prohoster.info\/sq\/blog\/news\/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}]}}