O loʻo avanoa le tuʻuina atu o le AlaSQL 4.0 DBMS, faʻamoemoe mo le faʻaogaina i luga ole laiga i luga ole laiga, ile telefoni feaveaʻi e faʻavae i luga o tekonolosi i luga o le upega tafaʻilagi poʻo totonu o masini komepiuta e faʻavae i luga o le Node.js platform. O le DBMS ua mamanuina e avea o se faletusi JavaScript ma faʻatagaina le faʻaogaina o le gagana SQL. O loʻo lagolagoina le teuina o faʻamaumauga i laulau faʻaleaganuʻu masani poʻo le faʻaogaina o fausaga JSON faʻapipiʻi e le manaʻomia ai se faʻamatalaga malosi o le polokalame teuina. O loʻo tuʻuina atu le faʻaogaina o le alasql e faʻatautaia ai faʻamatalaga mai le laina o le poloaiga. O le tulafono o le poloketi o loʻo tusia i le JavaScript ma tufatufaina i lalo ole laisene MIT.
E lagolagoina e AlaSQL le tele o le gagana SQL-99 ma tu'uina atu fo'i fa'aopoopoga mo le faiga o le NoSQL-style (e aunoa ma le fa'ama'otiina o se fuafuaga e teu ai) ma le fa'aogaina o kalafi. I fa'amatalaga SQL, e mafai ona e fa'atino galuega FA'AIGA, GROUP, UNION, fa'aoga subqueries ma fa'amatalaga e pei o ANY, ALL ma IN, ma fa'aoga le ROLLUP(), CUBE() ma GROUPING SETS() galuega. E utiuti le lagolago tau fefa'atauaiga. Lagolagoina le faʻamatalaga o galuega faʻapitoa e faʻaaogaina e mafai ona faʻaogaina i fesili SQL. Ina ia vave vala'au galuega ma fa'amatalaga SQL e mafai ona tu'ufa'atasia (fa'atusa ma le SQL PREPARE operator).
O le AlaSQL DBMS ua mamanuina e faʻaaoga ai le ETL (Extract, Transform, Load) faʻataʻitaʻiga ma faʻaogaina faʻamatalaga i le tulaga o le faʻaulufale mai / faʻagasologa / faʻatau atu. LocalStorage, IndexedDB, CSV, TAB, TXT, JSON, SQLite ma Excel (.xls ma .xlsx) formats e mafai ona faʻaogaina mo le teuina, auina atu i fafo ma le faʻaulufale mai, o lona uiga o faʻamaumauga o loʻo teuina i totonu o faʻamaumauga e mafai ona fesiligia saʻo pe faʻaulufale mai ma faʻatau atu faʻamatalaga. . E mafai fo'i ona fai se fa'agaioiga FILIFILI i so'o se fa'amatalaga i mea JavaScript.
O le faletusi o loʻo faʻatulagaina faʻapitoa mo le faʻaogaina vave o le mafaufau mo faʻamatalaga atamai pisinisi ma lagolagoina faʻataʻitaʻiga e pei o le faʻaogaina o fesili i le tulaga o galuega tuʻufaʻatasia, faʻasologa faʻasolosolo o faʻatasiga laulau, ma le faʻamamaina o WHERE fuaiupu aʻo leʻi tuʻufaʻatasia galuega. Pe a faʻatusatusa i isi galuega faʻatusa, AlaSQL e faʻatolu ona vave nai lo SQL.js pe a filifilia ma le SUM, JOIN ma GROUP BY faʻagaioiga, faʻalua taimi sili atu nai lo Linq pe a faʻaaoga GROUP BY, ma e tusa ma le tulaga tutusa ma le WebSQL API ( se faʻaopoopoga i SQLite, lea o le a le pine ae aveese mai le Chrome) pe a filifilia ma le SUM, JOIN ma GROUP BY gaioiga.
puna: opennet.ru