I-AlaSQL 4.0 iyatholakala ukuthi isetshenziswe kuzinhlelo zokusebenza zewebhu ezisekelwe kusiphequluli, izinhlelo zokusebenza zeselula ezisekelwe kuwebhu, noma izibambi eziseceleni kweseva ngokusekelwe kuplathifomu ye-Node.js. I-DBMS yakhelwe njengomtapo wezincwadi we-JavaScript futhi ikuvumela ukuthi usebenzise ulimi lwe-SQL. Isekela ukugcinwa kwedatha kumathebula okusebenzelana endabuko noma ngendlela yezakhiwo ze-JSON ezisidleke ezingadingi incazelo eqinile ye-schema sesitoreji. Insiza ye-alasql ihlinzekelwe ukuphatha idatha kusuka kumugqa womyalo. Ikhodi yephrojekthi ibhalwe ku-JavaScript futhi isatshalaliswa ngaphansi kwelayisensi ye-MIT.
I-AlaSQL isekela iningi lolimi lwe-SQL-99, futhi inikeza izengezo zokucutshungulwa kwesitayela se-NoSQL (ayikho incazelo ye-schema sesitoreji) kanye nokukhohlisa kwegrafu. Emibuzweni ye-SQL, ungenza imisebenzi yokuhlanganisa (JOIN), ukwenza iqembu (IQEMBU), inyunyana (i-UNION), usebenzise imibuzo engezansi nezisho ezifana nokuthi NOMA NOMA YILUPHI, KONKE nokuthi IN, sebenzisa imisebenzi ye-ROLLUP (), CUBE () kanye ne-GROUPING SETS (). Kukhona ukwesekwa okulinganiselwe kokwenziwe. Isekela incazelo yemisebenzi echazwe umsebenzisi engasetshenziswa kumibuzo ye-SQL. Ukuze uthole ucingo lomsebenzi osheshayo kanye nezinkulumo ze-SQL zingahlanganiswa (ezifana nesitatimende se-PREPARE SQL).
I-AlaSQL DBMS iklanyelwe ukusebenzisa ipharadigm ye-ETL (Extract, Transform, Load) futhi ilawule idatha ngendlela yokungenisa/ukucubungula/ukuthekelisa. Amafomethi we-LocalStorage, IndexedDB, CSV, TAB, TXT, JSON, SQLite ne-Excel (.xls kanye .xlsx) angasetshenziselwa ukugcinwa, ukuthekelisa kanye nokungenisa, kuyaqondakala ukuthi ungabuza ngokuqondile idatha egcinwe kumafomethi amakiwe, noma ukungenisa nokuthekelisa idatha. Kungenzeka futhi ukwenza umsebenzi othi KHETHA kunoma iyiphi idatha ezintweni ze-JavaScript.
Umtapo wolwazi uklanyelwe ukucutshungulwa kwedatha enkumbulo ngokushesha yezinhlelo zokusebenza zobuhlakani bebhizinisi futhi isekela ukulungiselelwa okufana nokugcinwa kwesikhashana kwemibuzo ngendlela ehlanganisiwe yemisebenzi, ukuhlanganisa ithebula elisebenzayo lokukhomba, kanye nokuthi LAPHO ukuhlunga isigatshana ngaphambi kokuhlanganisa imisebenzi. Uma iqhathaniswa namanye amaphrojekthi afanayo, i-AlaSQL ibishesha ngokuphindwe kathathu kune-SQL.js lapho ikhetha ngokusebenza kwe-SUM, JOIN kanye ne-GROUP BY, ngokushesha okuphindwe kabili kune-Linq uma usebenzisa i-GROUP BY futhi cishe nezinga elifanayo ne-WebSQL API (i-add-on phezulu kwe-SQLite (izokhishwa maduze ku-Chrome) uma ukhetha nge-SUM, JOIN, kanye nemisebenzi ye-GROUP BY.
Source: opennet.ru