Ntọhapụ nke AlaSQL 4.0 DBMS dị, nke ezubere maka iji na ngwa weebụ na ihe nchọgharị, na ngwa mkpanaaka dabere na teknụzụ weebụ ma ọ bụ na nhazi ihe nkesa dabere na ikpo okwu Node.js. Emebere DBMS ka ọbá akwụkwọ Javascript ma na-enye ohere iji asụsụ SQL. A na-akwado nchekwa data na tebụl mmekọrịta ọdịnala ma ọ bụ n'ụdị arụrụ arụ JSON akwụghị ụgwọ nke na-achọghị nkọwa siri ike nke atụmatụ nchekwa ahụ. Enyere uru alasql iji megharịa data sitere na ahịrị iwu. Edere koodu oru ngo na Javascript wee kesaa n'okpuru ikike MIT.
AlaSQL na-akwado ọtụtụ asụsụ SQL-99 ma na-enyekwa ndọtị maka nhazi ụdị NoSQL (na-akọwapụtaghị atụmatụ nchekwa) na nhazi eserese. Na ajụjụ SQL, ị nwere ike ịrụ ọrụ JOIN, GROUP, UNION, jiri subqueries na okwu dị ka Ọ BỤLA, ALL na IN, wee jiri ọrụ ROLLUP(), CUBE() na GROUPING SETS(). Enwere nkwado azụmahịa nwere oke. Na-akwado nkọwapụta ọrụ akọwapụtara nke onye ọrụ nwere ike iji na ajụjụ SQL. Iji kpọọ ọrụ ngwa ngwa yana enwere ike ikpokọta okwu SQL (dịka onye ọrụ SQL PREPARE).
Emebere AlaSQL DBMS ka o jiri ETL (Nwepụta, Gbanwee, Ibu) paradigm na ijikwa data n'ụdị mbubata / usoro / mbupu. Enwere ike iji usoro nchekwa mpaghara, IndexedDB, CSV, TAB, TXT, JSON, SQLite na Excel (.xls na .xlsx) maka nchekwa, mbupụ na mbubata, nke pụtara na data echekwara na usoro edeturu nwere ike jụọ ma ọ bụ bubata na mbupụ data ozugbo. . Ọ dịkwa ike ịrụ ọrụ SELECT na data ọ bụla dị na ihe Javascript.
A haziri ọbá akwụkwọ ahụ nke ọma maka nhazi ebe nchekwa ngwa ngwa maka ngwa ọgụgụ isi azụmaahịa ma na-akwado njikarịcha dị ka caching ajụjụ n'ụdị ọrụ achịkọtara, ntinye ngwa ngwa nke nchịkọta tebụl, na nzacha nkebiokwu WHERE tupu ijikọ ọrụ. Mgbe atụnyere ọrụ ndị ọzọ yiri ya, AlaSQL tụgharịrị ka ọ bụrụ ugboro atọ ngwa ngwa karịa SQL.js mgbe ị na-ahọrọ na SUM, JOIN and GROUP BY arụmọrụ, ugboro abụọ ngwa ngwa karịa Linq mgbe ị na-eji GROUP BY, na ihe dị ka otu ọkwa dị ka WebSQL API ( ihe mgbakwunye na SQLite, nke a ga-ewepụ na Chrome n'oge na-adịghị anya) mgbe ị na-ahọrọ na SUM, JOIN na GROUP BY arụmọrụ.
isi: opennet.ru