The release of the AlaSQL 4.0 database management system is now available, designed for use in web applications in browsers, in mobile applications based on web technologies, or in server-side processors built on the Node.js platform. The database is presented as a JavaScript library and allows the use of SQL language. It supports data storage in traditional relational tables or in the form of nested JSON structures that do not require strict schema definitions. An alasql utility is provided for data manipulation from the command line. The project code is written in JavaScript and is distributed under the MIT license. <\/p>\n
AlaSQL supports most of the SQL-99 language, and also provides extensions for NoSQL-style processing (without schema definition) and graph manipulation. SQL queries can perform operations like joins (JOIN), groupings (GROUP), unions (UNION), use subqueries and expressions like ANY, ALL, and IN, and apply functions like ROLLUP(), CUBE(), and GROUPING SETS(). Limited transaction support is available. User-defined functions can be defined and used in SQL queries. For quick function calls, SQL expressions can be compiled (similar to the SQL PREPARE statement). <\/p>\n
The AlaSQL database is designed to use the ETL (Extract, Transform, Load) paradigm and manipulate data in the form of import\/process\/export. The storage, export, and import can utilize formats such as localStorage, IndexedDB, CSV, TAB, TXT, JSON, SQLite, and Excel (.xls and .xlsx), and it is implied that queries can be executed directly from the data stored in these specified formats, or data can be imported and exported. It is also possible to perform SELECT operations on any data within JavaScript objects. <\/p>\n
The library is initially designed for fast data processing in memory for business analytics applications and supports optimizations such as caching queries in compiled function form, proactive merging of tables, and filtering WHERE expressions before merge operations. Compared to other similar projects, AlaSQL proved to be three times faster than SQL.js for queries involving SUM, JOIN, and GROUP BY operations, twice as fast as Linq when using GROUP BY, and approximately at the same level as the WebSQL API (a wrapper over SQLite that will soon be removed from Chrome) for queries with SUM, JOIN, and GROUP BY operations. \n Source: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"