A fost lansat\u0103 versiunea 4.0 a SGBD-ului AlaSQL, destinat utiliz\u0103rii \u00een aplica\u021bii web \u00een browser, aplica\u021bii mobile bazate pe tehnologii web sau \u00een procesatoare server pe baza platformei Node.js. SGBD-ul este prezentat sub form\u0103 de bibliotec\u0103 JavaScript \u0219i permite utilizarea limbajului SQL. Suport\u0103 stocarea datelor \u00een tabele rela\u021bionale tradi\u021bionale sau sub form\u0103 de structuri JSON \u00eenn\u0103scute, care nu necesit\u0103 o defini\u021bie rigid\u0103 a schemei de stocare. O utilitate numit\u0103 alasql este disponibil\u0103 pentru manipularea datelor din linia de comand\u0103. Codul proiectului este scris \u00een JavaScript \u0219i este distribuit sub licen\u021ba MIT. <\/p>\n
\u00cen AlaSQL este suportat\u0103 majoritatea limbajului SQL-99, precum \u0219i furnizate extensii pentru procesarea \u00een stil NoSQL (f\u0103r\u0103 definirea schemei de stocare) \u0219i manipularea graficelor. \u00cen interog\u0103rile SQL se pot efectua opera\u021biuni de \u00eembinare (JOIN), grupare (GROUP), unire (UNION), se pot utiliza subinterog\u0103ri \u0219i expresii de tip ANY, ALL \u0219i IN, se pot aplica func\u021bii ROLLUP(), CUBE() \u0219i GROUPING SETS(). Exist\u0103 un suport limitat pentru tranzac\u021bii. Este posibil\u0103 definirea func\u021biilor utilizator, care pot fi utilizate \u00een interog\u0103rile SQL. Pentru apeluri rapide ale func\u021biilor \u0219i expresiilor SQL, acestea pot fi compilate (asem\u0103n\u0103tor operatorului SQL PREPARE). <\/p>\n
SGBD-ul AlaSQL este proiectat pentru a utiliza paradigma ETL (Extract, Transform, Load) \u0219i manipularea datelor sub forma import\/export\/prelucrare. Formatele localStorage, IndexedDB, CSV, TAB, TXT, JSON, SQLite \u0219i Excel (.xls \u0219i .xlsx) pot fi utilizate pentru stocare, export \u0219i import, fiind implicat faptul c\u0103 se pot efectua direct interog\u0103ri asupra datelor stocate \u00een formatele men\u021bionate sau se pot importa \u0219i exporta date. De asemenea, este posibil s\u0103 se efectueze opera\u021bii SELECT asupra oric\u0103ror date din obiectele JavaScript. <\/p>\n
Biblioteca este ini\u021bial conceput\u0103 pentru procesarea rapid\u0103 a datelor \u00een memorie pentru aplica\u021bii de analiz\u0103 a afacerilor \u0219i suport\u0103 optimiz\u0103ri precum caching-ul interog\u0103rilor sub form\u0103 de func\u021bii compilate, indexarea anticipat\u0103 a fuziunilor de tabele \u0219i filtrarea expresiilor WHERE \u00eenainte de opera\u021biile de fuziune. Comparativ cu alte proiecte similare, AlaSQL s-a dovedit de trei ori mai rapid dec\u00e2t SQL.js pentru interog\u0103rile care includ opera\u021bii SUM, JOIN \u0219i GROUP BY, de dou\u0103 ori mai rapid dec\u00e2t Linq pentru utilizarea GROUP BY \u0219i aproximativ la acela\u0219i nivel cu API WebSQL (un overlay pentru SQLite, care va fi eliminat din Chrome) pentru interog\u0103rile cu opera\u021bii SUM, JOIN \u0219i GROUP BY. \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\udd47Lansarea SGBD-ului AlaSQL 4.0, destinat utiliz\u0103rii \u00een browsere \u0219i Node.js | ProHoster","description":"A fost lansat\u0103 versiunea 4.0 a SGBD-ului AlaSQL, destinat\u0103 utiliz\u0103rii \u00een aplica\u021bii web \u00een browsere, \u00een aplica\u021bii mobile bazate pe tehnologii web sau \u00een procese de server bazate pe platforma Node.js.","canonical_url":"https:\/\/prohoster.info\/ro\/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":"ro_RO","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\/ro\/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\/ro\/wp-json\/wp\/v2\/posts\/108405","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/comments?post=108405"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/108405\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/media?parent=108405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/categories?post=108405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/tags?post=108405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n
Sursa: opennet.ro<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"