AlaSQL 4.0 ikupezeka kuti igwiritsidwe ntchito pamawebusayiti ozikidwa pa msakatuli, mapulogalamu am'manja ozikidwa pa intaneti, kapena othandizira mbali ya seva potengera nsanja ya Node.js. DBMS idapangidwa ngati laibulale ya JavaScript ndipo imakulolani kugwiritsa ntchito chilankhulo cha SQL. Imathandizira kusunga deta pamagome achikhalidwe kapena m'mapangidwe a JSON omwe safuna tanthauzo lolimba la schema yosungirako. Chida cha alasql chimaperekedwa pakuwongolera deta kuchokera pamzere wamalamulo. Khodi ya polojekitiyi idalembedwa mu JavaScript ndikugawidwa pansi pa layisensi ya MIT.
AlaSQL imathandizira zilankhulo zambiri za SQL-99, ndipo imapereka zowonjezera pakukonza kalembedwe ka NoSQL (palibe tanthauzo la schema) ndikusintha ma graph. Mumafunso a SQL, mutha kuchita kuphatikiza (JOIN), gulu (GROUP), mgwirizano (UNION), kugwiritsa ntchito mafunso ndi mawu ngati ANY, ALL ndi IN, gwiritsani ntchito ROLLUP (), CUBE () ndi GROUPING SETS () ntchito. Pali chithandizo chochepa cha zochitika. Imathandizira kutanthauzira kwa ntchito zomwe zimagwiritsidwa ntchito ndi ogwiritsa ntchito zomwe zingagwiritsidwe ntchito pafunso la SQL. Kuti muyimbire mwachangu ntchito ndi mawu a SQL zitha kupangidwa (zofanana ndi PREPARE SQL statement).
AlaSQL DBMS idapangidwa kuti igwiritse ntchito paradigm ya ETL (Extract, Transform, Load) ndikuwongolera deta munjira yolowera / kukonza / kutumiza kunja. Mawonekedwe a LocalStorage, IndexedDB, CSV, TAB, TXT, JSON, SQLite ndi Excel (.xls ndi .xlsx) angagwiritsidwe ntchito posungira, kutumiza kunja ndi kutumiza kunja, zimamveka kuti mukhoza kufunsa mwachindunji kuchokera ku deta yosungidwa m'mawonekedwe olembedwa, kapena kulowetsa ndi kutumiza deta. Ndikothekanso kuchita zisankho pa data iliyonse muzinthu za JavaScript.
Laibulaleyi idapangidwa kuti izikhala yofulumira kwambiri pakukonza ma data pazantchito zamabizinesi ndipo imathandizira kukhathamiritsa monga kusungitsa mafunso m'njira zophatikizidwira, kuphatikizika kwa tebulo loyang'anira, ndi KUTI kusefa kwa ndime musanaphatikize ntchito. Poyerekeza ndi ntchito zina zofananira, AlaSQL inali yachangu katatu kuposa SQL.js posankha ndi ntchito za SUM, JOIN ndi GROUP BY, kuwirikiza kawiri kuposa Linq mukamagwiritsa ntchito GROUP BY komanso mulingo wofanana ndi WebSQL API (zowonjezera). pamwamba pa SQLite (kuchotsedwa posachedwa ku Chrome) posankha ndi SUM, JOIN, ndi GROUP BY ntchito.
Source: opennet.ru