A nova vers\u00e3o do SGBD AlaSQL 4.0 est\u00e1 dispon\u00edvel, destinada ao uso em aplicativos web em navegadores, em aplicativos m\u00f3veis baseados em tecnologias web ou em processadores de servidor baseados na plataforma Node.js. O SGBD \u00e9 apresentado como uma biblioteca JavaScript e permite o uso da linguagem SQL. Suporta o armazenamento de dados em tabelas relacionais tradicionais ou na forma de estruturas JSON aninhadas, que n\u00e3o exigem uma defini\u00e7\u00e3o r\u00edgida do esquema de armazenamento. Para manipula\u00e7\u00e3o de dados a partir da linha de comando, est\u00e1 dispon\u00edvel a ferramenta alasql. O c\u00f3digo do projeto \u00e9 escrito em JavaScript e \u00e9 distribu\u00eddo sob a licen\u00e7a MIT. <\/p>\n
No AlaSQL, a maior parte da linguagem SQL-99 \u00e9 suportada, al\u00e9m de fornecer extens\u00f5es para manipula\u00e7\u00e3o no estilo NoSQL (sem defini\u00e7\u00e3o de esquema de armazenamento) e manipula\u00e7\u00e3o de grafos. \u00c9 poss\u00edvel realizar opera\u00e7\u00f5es de mesclagem (JOIN), agrupamento (GROUP), uni\u00e3o (UNION) em consultas SQL, usar subconsultas e express\u00f5es do tipo ANY, ALL e IN, al\u00e9m de aplicar fun\u00e7\u00f5es como ROLLUP(), CUBE() e GROUPING SETS(). Existe suporte limitado a transa\u00e7\u00f5es. \u00c9 poss\u00edvel definir fun\u00e7\u00f5es personalizadas que podem ser utilizadas em consultas SQL. Para chamada r\u00e1pida, fun\u00e7\u00f5es e express\u00f5es SQL podem ser compiladas (semelhante ao operador SQL PREPARE). <\/p>\n
O SGBD AlaSQL foi projetado para usar a paradigmas ETL (Extract, Transform, Load) e manipula\u00e7\u00e3o de dados na forma de importa\u00e7\u00e3o\/processamento\/exporta\u00e7\u00e3o. Para armazenamento, exporta\u00e7\u00e3o e importa\u00e7\u00e3o, podem ser utilizados formatos como localStorage, IndexedDB, CSV, TAB, TXT, JSON, SQLite e Excel (.xls e .xlsx), sendo que \u00e9 assumido que \u00e9 poss\u00edvel realizar consultas diretamente nos dados armazenados nos formatos mencionados, ou importar e exportar dados. Tamb\u00e9m \u00e9 poss\u00edvel executar opera\u00e7\u00f5es SELECT sobre quaisquer dados em objetos JavaScript. <\/p>\n
A biblioteca foi projetada para um processamento r\u00e1pido de dados na mem\u00f3ria para aplicativos de an\u00e1lise de neg\u00f3cios e suporta otimiza\u00e7\u00f5es como cache de consultas na forma de fun\u00e7\u00f5es compiladas, indexa\u00e7\u00e3o preditiva de jun\u00e7\u00f5es de tabelas e filtragem de express\u00f5es WHERE antes das opera\u00e7\u00f5es de jun\u00e7\u00e3o. Em compara\u00e7\u00e3o com outros projetos semelhantes, a AlaSQL se mostrou tr\u00eas vezes mais r\u00e1pida que o SQL.js em opera\u00e7\u00f5es de sele\u00e7\u00e3o com SUM, JOIN e GROUP BY, duas vezes mais r\u00e1pida que o Linq ao usar GROUP BY, e aproximadamente no mesmo n\u00edvel do API WebSQL (uma camada sobre o SQLite que ser\u00e1 removida em breve do Chrome) nas opera\u00e7\u00f5es de sele\u00e7\u00e3o com SUM, JOIN e 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\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\udd47 Lan\u00e7amento do SGBD AlaSQL 4.0, voltado para uso em navegadores e Node.js | ProHoster","description":"Est\u00e1 dispon\u00edvel o lan\u00e7amento do SGBD AlaSQL 4.0, destinado a ser utilizado em aplicativos web no navegador, em aplicativos m\u00f3veis baseados em tecnologia web ou em manipuladores de servidor baseados na plataforma Node.js.","canonical_url":"https:\/\/prohoster.info\/pt\/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":"pt_PT","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\/pt\/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\/pt\/wp-json\/wp\/v2\/posts\/108405","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/comments?post=108405"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/posts\/108405\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/media?parent=108405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/categories?post=108405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/tags?post=108405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n
Fonte: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"