AlaSQL 4.0 inowanikwa kuti ishandiswe mubrowser-based web applications, web-based mobile applications, kana server-side handlers zvichibva paNode.js platform. Iyo DBMS yakagadzirwa seJavaScript raibhurari uye inobvumidza iwe kushandisa mutauro weSQL. Inotsigira kuchengetedza dhata mumatafura ehukama echinyakare kana muchimiro cheiyo nested JSON zvimiro zvisingade kuomarara tsananguro yeiyo yekuchengetedza schema. Iyo alasql utility inopihwa kushandura data kubva kumutsara wekuraira. Iyo kodhi yeprojekiti yakanyorwa muJavaScript uye yakagoverwa pasi peMIT rezinesi.
AlaSQL inotsigira yakawanda yemutauro weSQL-99, uye inopa mawedzero eNoSQL-maitiro ekugadzirisa (hapana chekuchengetedza schema tsananguro) uye graph manipulation. Mumibvunzo yeSQL, unogona kuita kubatanidza (JOIN), kuisa boka (GROUP), mubatanidzwa (Union) mashandiro, shandisa zvinyorwa uye mataurirwo akaita CHETE, ALL uye IN, shandisa ROLLUP (), CUBE () uye GROUPING SETS () mabasa. Pane tsigiro shoma yekutengeserana. Inotsigira tsananguro yevashandisi-yakatsanangurwa mabasa anogona kushandiswa muSQL mibvunzo. Kune yekukurumidza basa kufona uye SQL mataurirwo anogona kuunganidzwa (akafanana ne PREPARE SQL statement).
Iyo AlaSQL DBMS yakagadzirirwa kushandisa ETL (Kubvisa, Shandura, Kutakura) paradigm uye kushandura data nenzira yekutumira / kugadzirisa / kutumira kunze. LocalStorage, IndexedDB, CSV, TAB, TXT, JSON, SQLite uye Excel (.xls uye .xlsx) mafomati anogona kushandiswa kuchengetedza, kutumira kunze uye kunze kwenyika, zvinonzwisisika kuti unogona kubvunza zvakananga kubva kune data yakachengetwa mumafomati akaiswa, kana kupinza uye kutumira data. Izvo zvakare zvinogoneka kuita SELECT oparesheni pane chero data muJavaScript zvinhu.
Raibhurari yacho yakagadzirirwa kukurumidza mu-memory data kugadziridzwa kwebhizinesi rehungwaru maapplication uye inotsigira optimizations senge query caching muchimiro chemabasa akaunganidzwa, proactive tafura batanidza indexing, uye PANE kusefa clause usati wabatanidza mashandiro. Kana ichienzaniswa nemamwe mapurojekiti akafanana, AlaSQL yaive nekukurumidza zvakapetwa katatu pane SQL.js pakusarudza neSUM, JOIN uye GROUP BY mashandiro, kaviri nekukurumidza seLinq paunenge uchishandisa GROUP BY uye nezve nhanho yakafanana neWebSQL API (add-on pamusoro peSQLite (ichakurumidza kubviswa kubva kuChrome) paunenge uchisarudza neSUM, JOIN, uye GROUP BY mashandiro.
Source: opennet.ru