Ana samun AlaSQL 4.0 don amfani a aikace-aikacen gidan yanar gizo na tushen burauza, aikace-aikacen wayar hannu na tushen yanar gizo, ko masu kula da gefen uwar garke bisa dandalin Node.js. An tsara DBMS azaman ɗakin karatu na JavaScript kuma yana ba ku damar amfani da yaren SQL. Yana goyan bayan adana bayanai a cikin allunan alaƙa na al'ada ko a cikin sigar tsarin gida na JSON waɗanda ba sa buƙatar ma'anar ma'anar tsarin ajiya. An tanadar da amfanin alasql don sarrafa bayanai daga layin umarni. An rubuta lambar aikin a cikin JavaScript kuma an rarraba a ƙarƙashin lasisin MIT.
AlaSQL yana goyan bayan yawancin yaren SQL-99, kuma yana ba da ƙari don sarrafa salon NoSQL (babu ma'anar tsarin ajiya) da magudin hoto. A cikin tambayoyin SQL, zaku iya aiwatar da haɗin gwiwa (JOIN), ƙungiyoyin (GROUP), ayyukan ƙungiyar (UNION), amfani da subqueries da maganganu kamar KOWANE, DUK da IN, yi amfani da ayyukan ROLLUP (), CUBE () da GROUPING SETS (). Akwai iyakataccen tallafi don ma'amaloli. Yana goyan bayan ma'anar ƙayyadaddun ayyuka masu amfani waɗanda za a iya amfani da su a cikin tambayoyin SQL. Don kiran aiki mai sauri kuma ana iya haɗa maganganun SQL (mai kama da bayanin PREPARE SQL).
An tsara AlaSQL DBMS don amfani da tsarin ETL (Tsarin, Canjawa, Load) da sarrafa bayanai ta hanyar shigo da / sarrafawa / fitarwa. LocalStorage, IndexedDB, CSV, TAB, TXT, JSON, SQLite da Excel (.xls da .xlsx) za a iya amfani da tsarin ajiya, fitarwa da shigo da su, an fahimci cewa za ku iya yin tambaya kai tsaye daga bayanan da aka adana a cikin alamomin tsari, ko shigo da bayanan fitarwa. Hakanan yana yiwuwa a yi aikin SELECT akan kowane bayanai a cikin abubuwan JavaScript.
An tsara ɗakin karatu na asali don sarrafa bayanan ƙwaƙwalwar ajiya cikin sauri don aikace-aikacen leƙen asiri na kasuwanci kuma yana goyan bayan ingantawa kamar caching na tambaya a cikin nau'ikan ayyukan da aka haɗa, firikwensin haɗaɗɗiyar tebur, da tace INA magana kafin haɗa ayyukan. Idan aka kwatanta da sauran ayyuka masu kama da wannan, AlaSQL ya kasance sau uku da sauri fiye da SQL.js lokacin zabar SUM, JOIN da GROUP BY ayyuka, sau biyu da sauri fiye da Linq lokacin amfani da GROUP BY kuma kusan matakin ɗaya da WebSQL API (ƙara a kan). saman SQLite (nan ba da jimawa ba za a cire shi daga Chrome) lokacin zaɓi tare da SUM, JOIN, da GROUP BY ayyuka.
source: budenet.ru