History[02][04][05]

The author of AlaSQL is Andrey Gershun, a Russian developer. The initial commit for AlaSQL on Github was on October 26, 2014.

In 2014, there were a handful of NoSQL in-memory databases that can be directly used in browser. The lack of a SQL compliant alternative motivated the AlaSQL project.

One of the major milestones/releases of the AlaSQL project is version 0.1.4 in which foreign keys, unique/not-null/check constraints were added. In version 0.4.0, support for Typescript syntax checking was added.

Checkpoints

Concurrency Control

Concurrency control is not supported, nor is parallel execution.

Data Model[06]

AlaSQL supports the relational model, but can also act as a document store. Most standard SQL data types are supported, in additional to a number of JavaScript data types, like JSON objects.

Foreign Keys[07]

Indexes[08]

AlaSQL uses hash tables for its indexes. Upon index creation, all entries in the table are hashed and stored in a JavaScript object.

Joins[09]

All SQL join types are supported. Prior to executing a join, both tables are pre-indexed, and WHERE predicates are evaluated.

Logging

Query Interface[10]

Currently, AlaSQL is only available for JavaScript. AlaSQL uses standard SQL interfaces. However, like many other database management systems, AlaSQL is not fully compliant with any revisions of the SQL database query language. For example, the ALLOCATE keyword, which is available since SQL-92, is not supported by AlaSQL.

Storage Architecture[01]

AlaSQL is an in-memory database that is intended for Node.js and in-browser usage.